Mirroring MySQL Databases

[swinnie]

At work we've got our tills running through OpenbravoPOS. Something which occurred to me, whilst rebooting our box today for an update (due to lack of thought on mine and my colleague's part) we didn't have till access for around five minutes whilst this update took place. Is there easy way to mirror a MySQL database between two servers?

Obviously I'm thinking of doing this primarily for a backup as we have a single copy of this database. But for redundancy if the box ever has issues we can just point Openbravo to the other boxes' IP Address.

Suggestions?

Many thanks in advance.

 

[swinnie]

Not really my thing, but i was fairly sure replication was a pretty central part of a database's function this might help!

I'm sure someone here will be a bit more helpful! Also some apps, won't like simply being pointed at another server.

Thanks. Providing the database is intact on another server, Openbravo can simply 'latch on' to it and continue operation.

 

[swinnie]

That's interesting. I'm guessing you'd typically advise a Master-Slave configuration?