Good day all
I am hoping that someone can perhaps help me with some resources
I need to go to a meeting in the next hour and was requested this
morning to research possible load balancing options for MySQL database.
What is currently running is a website (balanced over a couple of
web servers all connecting to the same database) using apacje and jdk.
2 MySQL databases running as Masler/Slave replication with all
reads and writes going to the master and the slave being used for data
exports and failover if required.
The websites are rather busy and during times of high load the
master server takes some strain.
The Databases are being to new upgraded hardware soon,
including a database upgrade.
The idea is that they also want to introduce load balancing for
the MySQL databases in order to manage the high load situations.
Any help would be appreciated as google has not yet turned up
any sufficient info for me in this short time I had been given.