I want to upgrade my server because of the high mysql loads causing slowness + whenever there were backup processes running on the DB, the DB would be inaccessible, so wanted some solution. My current server is an Opteron 2212 with 8GB RAM.
My web host suggested a lower configuration server (Phenom Hexacore with 8GB RAM) but to take 3 servers + load balancer...they said that it would help in situations where there is a high amount of traffic and also help when one of the server fails, that there will be a backup server.
On inquiring further they said that no mysql replication will be set up because they charge extra for that but will still be able to configure a set up which will meet my needs.
I am not really sure, will my purpose of an upgrade even be achieved if I have 3 such servers and no mysql replication...they're not very clear on how they'd set it up. Any ideas on whether this is a good solution and what I could propose to them?