HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Mirroring Databases in MySQL

Submitted by: @import:stackexchange-dba··
0
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.