• 15th December 2005 -By Vinu Thomas

    I came across this article while looking for material on clustering MySQL servers. We needed to setup the production servers for the company to make it fault tolerant. This article gave me a good start on the task:

    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.
    Article Link: Mysql Cluster: Two webserver setup (three servers required for true redundancy)

  • Leave a Reply