|
Like I said above, "managed server", doesn't mean something like THIS would be included -- especially if you are not paying enough.
Handling DB replication is a big job. It's almost part of your programmers/DB administrator -- not your server sysadmin.
You need to wear multiple hats to have DB replication active/active.
It's going to cost you money, professionals COST MONEY.
Your $199/month "managed server" IS NOT going to cover that.
I would expect at least another $199/month on top of your server cost for initial setup and on-going management of your DB replication.
You may even have an initial setup fee of $500~ to get everything setup and running smoothly at first -- but do not expect it to continue running smoothly, they break quite easy and often.
You will have more stability with active/passive (one running the main DB, one for backup only) then active/active (both actively serving queries and staying in-sync with each other - because BOTH will be receiving updates at the SAME time, so one can't copy off another).
If you're at this point, the cost should be feasible from a budget perspective. If you're site isn't important enough or making enough money but you "need" all this, perhaps its time to rethink whether your site should even exist.
.
|