CODEWITHSUNDEEP
mysqldatabase
thf
thf

Reputation: 604

Any way to synchronize 2 mysql databases?

Two machines, each running mysql, each synchronized to the other peer-to-peer. I do not want a master db replicated. Rather, I want two users to be able to work on the data offline (each running a mysql server on his machine) and then when reconnected synchronize to each other. Any way to do this with mysql? Any other database I should be looking at to accomplish this better than mysql?

Upvotes: 3

Views: 819

Answers (3)

Chris Card
Chris Card

Reputation: 3266

Two-way replication is provided by various database systems (e.g. SQLServer, Sybase etc.) but there are always problems with such a set up.

For example, if the same row is updated at the same time on the two databases, which update wins?

If your aim is to provide a highly-available MySQL database, then there are better options than using replication. MySQL has a clustering solution (though I've not had much success with it) or you can use things like DRBD and heartbeat to provide automatic failover with no loss of data.

Upvotes: 2

DarinH
DarinH

Reputation: 4879

As for "Other Database Options" SQLServer supports a fairly advanced "replication" process for synchronizing the data between two or more db's. Looks like MySql has something like this as well though.

Upvotes: 0

Christopher Armstrong
Christopher Armstrong

Reputation: 7953

If you mean synchronous writing back and forth, this would cause serious data consistency issues. I think you may be referring to MySQL replication, wherein a master server sends its updates to one or more slave database servers, which can be queried.

Upvotes: 0

Related Questions