Load Balancing Mysql Databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Load Balancing Mysql Databases

Post by Jade »

Hey there,

I'm having trouble keeping my load down on the queries made to my database so I'm trying to split the database across two servers to help speed things up. Is there a way to split the connectivity to mysql or will I have to switch back and forth between connection sequences in order to access the data over two severs?

Or maybe you have a better way for me to lower my mysql load. Trouble is I don't have the $$ to buy a faster server which is what i really need. Any suggestions would be appreciated.

Jade
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

mod_rewrite has some load balancing capabilities, last I checked.. (using RewriteMap I think it was)
Post Reply