MySQL replication and load balancing
Posted: Wed Jan 25, 2006 5:22 am
Hi,
We have various mysql database servers set up none of which have replication and load balancing set up.
Recently I updated mysql version on one of the servers and also installed MySQL admin tool. I noticed a replication section and a colleague of mine also added theat load balancing is now possible.
I really need to have two servers in place for every database we have, replicating data and load balanced (around four database servers running for different services).
My question is, Does anybody know how to do this or know of any tutorials on the internet?
Many thanks!
We have various mysql database servers set up none of which have replication and load balancing set up.
Recently I updated mysql version on one of the servers and also installed MySQL admin tool. I noticed a replication section and a colleague of mine also added theat load balancing is now possible.
I really need to have two servers in place for every database we have, replicating data and load balanced (around four database servers running for different services).
My question is, Does anybody know how to do this or know of any tutorials on the internet?
Many thanks!