patternsqlMinor
Mirroring Databases in MySQL
Viewed 0 times
mysqldatabasesmirroring
Problem
Is there a way to mirror databases in MySQL? In SQL Server, you have the ability to link 2 databases in a master to master relationship. One DB will accept transactions and the transactions will be committed on both DBs at the same time. Is there a a similar concept in MySQL?
Solution
I think the other answer missed the point of the question; which is that in SQL Server mirroring, a transaction that commits to both servers A and B are committed at the same time (in atomicity). If the transaction fails on one server, it fails on both. It doesn't seem like there is a similar feature on MySQL
Context
StackExchange Database Administrators Q#23148, answer score: 4
Revisions (0)
No revisions yet.