• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

MySQL Mirror in the Cloud

 
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 417
Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 80871
506
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic