We have about 50GB of data in different mysql databases
on server A. We want a solution where we will get a new
server B and that server will be hosted on a different
computer (probably on a different continent) and we need
a way to synchronize the data from A on server B in such
a way that if server A is down B could take over, but
now we also want that if server A is back lets say after
1 hour the data from the from B that got inserted/updated
in last hour to be inserted back on A and A should take over.
In the end we need a solution where we could switch from
A to B and back to A every 1 hour - 24 times a day.
We can also switch to other database solutions like oracle
if you consider they offer a solution for what we need.
We need best practice examples to get an idea how we can make this. If you have done this on a large scale - lets say A is a serverfarm with 20 servers, so is B. The maingoal is to have a "live backup" as i may call it. We can not afford to be down for even 30 minutes.
13 freelancers are bidding on average $174 for this job
This is possible but you need to have a round robin DNS that changes IPs in a very short time span in front of the MySQL farms. The replication is not a big issue but the DNS is.
Im a UK based Contractor specialising in UNIX Infrastructure Architecture. Providing I have the correct rights on both systems I can perform a master/slave setup that you require in less than a day.