Page 1 of 1

Load Balancing Mysql Databases

Posted: Fri Apr 15, 2005 4:46 pm
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

Posted: Fri Apr 15, 2005 8:41 pm
by feyd
mod_rewrite has some load balancing capabilities, last I checked.. (using RewriteMap I think it was)