Blog: MySQL High Availability

Door in Algemeen, Coldfusion - gepost op 19-06-2007

MySQL Cluster
MySQL Cluster is a high-availability, high-redundancy version of MySQL adapted for the distributed computing environment. It uses the NDB Cluster storage engine to enable running several MySQL servers in a cluster. This storage engine is available in MySQL 5.0 binary releases and in RPMs compatible with most modern Linux distributions.
meer

MySQL two-way replication
With a bit of hacking around, I was able to implement master <-> master replication. It preforms exactly as I had suspected, once I got it working.
meer

MySQL Cluster forum
Uitgebreid forum over het opzetten van een MySQL cluster
meer

HOWTO set up a MySQL Cluster for two servers
This HOWTO was designed for a classic setup of two servers behind a loadbalancer. The aim is to have true redundancy - either server can be unplugged and yet the site will remain up. You MUST have a third server as a managment node but this can be shut down after the cluster starts. Also note that I do not recommend shutting down the managment server (see the extra notes at the bottom of this document for more information). You can not run a MySQL Cluster with just two servers And have true redundancy. Although it is possible to set the cluster up on two physical servers you WILL NOT GET the ability to "kill" one server and for the cluster to continue as normal. For this you need a third server running the managment node.
meer

 

 

< terug