Re: MySQL High Availability
Frédéric VANNIÈRE wrote:
Hi!
There is also sqlrelay, The best solution would be a 2 way replication
with load balancing and caching (writes on 1 server, reads on several one)
I have a MySQL4 setup with two servers, used on a Heartbeat2 2-node
cluster as a Cacti backend. Nothing fancy and not used from more than
one node at a time. I setup two way replication between the two MySQL
servers. They're actually outside the Heartbeat setup, they both just
run as a slave to each other.
Using DRBD as the main storage point for the databases might cause
problems if you fail a node over to backup (filesystem goes into read
only). The last writes to disk by MySQL on the primary might not have
been written.
If you want two masters (REAL masters which you can use at the same
time), you probably end up with MySQL5 clustering.
/Robin
Reply to: