mysql triger to update table on multiple servers.
Posted on 2011-03-15
I have a pbx system that has 4 mysql and 2 ms sql server data bases. The is a table on each server/data base that is the same table (and must be kept in sync).. on all the server/dbases.
i'm writting a .net web app to update one table on one server, and then I need to make the insert, update, delete (via a trigger) replicate onto the other pbx dbase table on the other servers.
I want to know if I can write a trigger on one of the tables in one server/dbase that would replicate the insert, update, deletes from one to the other ms sql and my sql data base. What would it take to do this? Is there a better way. We are using mysql 5.02.