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?)