How do i split mysql between server

[imported_Stephen]

Hello
I would like to split a mysql database between servers, the database is too big for the one server so I would like to be able to run it in more than one, having the servers in seperate locations would be good, but it would mean having two CPUs in each server and the database would have to be updated on both anyway.

Just not sure what is the most stable way to do this..

 

[Vovex Technology]

Stephen,

Are you running cPanel?

If so cPanel has an option for remote MySQL. I would suggest getting a seperate server and housing all MySQL databases on it. That way you only have one server suffering MySQL loads. It should help bring your Webserver loads down too.

Im not quite exactly sure on how it works. You can read through cPanel's forum. I have seen some threads there in the past regarding this matter.