Different ways for load balancing on MySQL server

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
pbs
Forum Contributor
Posts: 230
Joined: Fri Nov 07, 2008 5:31 am
Location: Nashik, India
Contact:

Different ways for load balancing on MySQL server

Post by pbs »

What are different ways for load balancing on MySQL server?
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: Different ways for load balancing on MySQL server

Post by alex.barylski »

clustering
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Different ways for load balancing on MySQL server

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