Different ways for load balancing on MySQL server
Moderator: General Moderators
Different ways for load balancing on MySQL server
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
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?)
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?)