Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL Mirror in the Cloud

 
Carlos Conti
Ranch Hand
Posts: 131
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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é
Ranch Hand
Posts: 417
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 51390
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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é
Ranch Hand
Posts: 417
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic