Solution for mysql database fast data replication

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.

Skills: Linux

See more: solution n, mysql database server, fast switch, a solution, mysql database replication web farm, mysql deploying stand server backup server, Synchronize, solution, replication, oracle linux, oracle data, database oracle, computer solutions, mysql inserted, mysql databases server, computer solution, offer hour, database replication mysql, mysql replication database, data linux, server data linux, server mysql, fast computer, want database, want fast

About the Employer:
( 47 reviews ) Zurich, Switzerland

Project ID: #219723

13 freelancers are bidding on average $174 for this job


Hi. Please check PM.

$70 USD in 5 days
(172 Reviews)

Certified Linux System Administrator ready to work. I can start right away. Kindly check your PM. Regards. Nick.

$100 USD in 3 days
(129 Reviews)

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.

$150 USD in 5 days
(80 Reviews)

Hi, Please check PM.

$200 USD in 3 days
(58 Reviews)

Hello, Please check my pm

$100 USD in 3 days
(9 Reviews)

Hello. Please check PM.

$190 USD in 14 days
(5 Reviews)

I'm Linux sysadmin in Argentine, the best solution for this is Xen+DRBD(network Raid 1)+Heartbeat. When A down, B takes the control.

$200 USD in 3 days
(5 Reviews)

Please see PMB.

$100 USD in 2 days
(2 Reviews)

puryearit is right. If you really can't afford to be down for thirty minutes, then you need to put more into this project. Also, an HA (High Availability) setup should be tested regularly. Best practice advice range More

$250 USD in 30 days
(1 Review)

I read your request with interest. We provide expertise in projects involving the design, deployment, and management of Linux, UNIX, and web-based services. This project appears interesting, although I think there i More

$250 USD in 14 days
(0 Reviews)

it is just one of the solutions for your problem. Mirror Your Web Site With rsync:-- you can mirror your web site from your main server to a backup server that can take over if the main server fails. We use the too More

$250 USD in 15 days
(0 Reviews)

Hi, The budget you have is extreemly low. This kind of project will be costing you approx 1000$ as min quote. Our services will ensure testing and everything. 100% in service quality and satisfaction. For deta More

$249 USD in 15 days
(0 Reviews)

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.

$150 USD in 0 days
(0 Reviews)