0

I have three MYSQL databases in 3 client applications. I need to sync 3 databases with one master database. I need to make update other databases when master is updated.

Not all the tables few tables from the 3 local databases and there want be integrity errors

[EDIT]

Client databases also sync with master.

user2473015
  • 1,392
  • 3
  • 22
  • 47
  • 1
    This may also help. http://stackoverflow.com/questions/2366018/how-to-re-sync-the-mysql-db-if-master-and-slave-have-different-database-incase-o – Peter H Apr 13 '14 at 05:06

1 Answers1

1

I am working on a custom implementation of distributed database multi-master synching. So I spotted your question immediately.

Please check out http://dev.mysql.com/doc/refman/5.0/en/replication.html for details on the replication from master to slave.

Hopefully that will give you the most effective info.

Tom Pace
  • 2,347
  • 1
  • 24
  • 32