MySQL Mirror in the Cloud

[Carlos Conti]

Hi there,

I need to setup a replication database in the form of a mirror so that our backend database is replicated overnight or in realtime if possible in order to maintain secure copies of our data outside of our office boundaries.

Does anyone know how to attain this? Ideally we would like to maintain two identical copies of the same database, in the most synchronized fashion, say a change in database A causes A' to be updated in a matter of seconds.

I am completely lost on this subject and if anyone could shed some light would be of great help.

Does anyone offer such service? I guess for huge webapps this is a must, to distribute big amounts of db requests...

We are willing to build it in order to maintain secure copies of our data.

Many thanks for your attention and time.

Regards,

Carlos.

[A.J. Côté]

Just use binlog, and mysql replay log on the slave.

It's is really cool and works well although I had to do a few crash recoveries.

But seriously, thumbs-up for mysql replay-log replication, really tested and robust.

[Campbell Ritchie]

A.J. Côté wrote: . . . I had to do a few crash recoveries.

. . . really tested and robust.

Please explain more. Were the crashes unrelated to blinlog? Otherwise, those two statements seem to contradict each other.

[A.J. Côté]

Campbell Ritchie wrote:

A.J. Côté wrote: . . . I had to do a few crash recoveries.

. . . really tested and robust.

Please explain more. Were the crashes unrelated to blinlog? Otherwise, those two statements seem to contradict each other.

Absolutely, completely unrelated to blinlog itself.

When the master crashes at the storage level (for some hardware or other reason), you have to manually replay the binlogs on the master before starting to replicate again.

I have seen cases where we needed to delete duplicate rows on slaves in order for replication to continue.

But overall, we never lost any real time data using it yet.