|
You need a semi-complicated setup to keep both DB's fully sync'ed at all times, and also update when one goes down for whatever reason.
Do you want both active at the same time to distribute load, but also be available in case one goes down? (active/active) or do you want one 1 active and 1 for redundancy (active/passive)?
The active/passive method is way easier to implement and manage then trying to keep 2 dynamic DB's update to date in real time with active/active.
It is not easy and won't be cheap or included in some cheap type of hosting -- even if they call it "managed".
You want real sysadmins to do this shit for you, and professionals charge money.
|