MySQL High Availability
Hi,
I'm looking for a good solution for having MySQL redundancy. There
are more than
2000 databases and 7 GB of data.
As now I've got two solutions:
- using replication, it must be monitored and requires long
downtime for initialization and
fallback.
- using DRBD between a master and slave server, I'm using it for
a NFS server and it works
pretty well. The problem is the slave may be corrupted
specially for InnoDB databases.
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)
Regards,
Frédéric.
Reply to: