now browsing by month
Setting up a load balanced mysql cluster with only two servers.
This document is a how to for installing mysql 5 cluster with only two server machines. Our cluster combines two data nodes:two management nodes and two mysql nodes.
Every machine has 1 data node,1 management node, and 1 mysql server.
To avoid network problems between our internet connection, switches,etc, we networked the two machines with dual switch connection and one crossover cable between them.
The mysql cluster will communicate using the crossover cable, just to be sure that there will be no network problems (except from the crossover cable link).
To communicate with the mysql we will use a shared ip, which will be available with linux ha , so the mysql clients will connect to that ip. and have 99.999999% uptime.