I’m looking for the best way to use MySQL on our servers.
We’ve got three servers: two external webservers (servers A and B) on two different locations, and one local server (server C), which is configured as a backup webserver. Here are the specs:
Intel Xeon 2.8 GHz processor
2 GB RAM
Intel Pentium 4 2.4 Ghz processor
1 GB RAM
Intel Pentium III 733
256 MB RAM
Server A runs MySQL with one database, for one website, our ‘main’ website.
Server B runs MySQL with several databases, for several, smaller, websites. Even when put together they still have a lighter load than the main website on its own.
Server C does not run MySQL yet.
I would like to run live replications of both of the MySQL servers (A and B).
Besides that I also want to run a separate MySQL server, with copies of all the databases, which I can use
for testing purposes.
Now I’m not really sure what would be the best way to set this up. My initial idea was to make server B a dedicated webserver and server A a dedicated MySQL server, and then make C the testing server, but my company doesn’t want that.
What I’m thinking of now is to run three MySQL instances on server C: a server A replication, a server B replication and a testing server. But that doesn’t sound all that great to me…
Does anyone have any better ideas?