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