[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: