Page 1 of 1
Different ways for load balancing on MySQL server
Posted: Tue Feb 02, 2010 11:58 pm
by pbs
What are different ways for load balancing on MySQL server?
Re: Different ways for load balancing on MySQL server
Posted: Wed Feb 03, 2010 7:49 am
by alex.barylski
clustering
Re: Different ways for load balancing on MySQL server
Posted: Sat Feb 06, 2010 5:13 am
by josh
Load balancing and clustering are almost synonyms.
What you probably want it master -> slave replication. Maybe a heartbeat script to switch the master when the live server dies.
But theres 2 things, high availability and load balancing. You should aim for one or the other. SInce you said load balancing, you'd have multiple salve servers. You'd distribute reads across them. (use RAND() on each connection to determine which database server to use?)