Closed

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.

Skills: Linux

See more: solution n, mysql database server, fast switch, a solution, 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, need solution, synchronize mysql

About the Employer:
( 47 reviews ) Zurich, Switzerland

Project ID: #219723

13 freelancers are bidding on average $174 for this job

nknk

Hi. Please check PM.

$70 USD in 5 days
(172 Reviews)
7.0
Nick1

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)
6.1
TheAce

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)
6.0
linuxsupport

Hi, Please check PM.

$200 USD in 3 days
(58 Reviews)
5.9
sazmy

Hello, Please check my pm

$100 USD in 3 days
(9 Reviews)
4.6
jzevakin

Hello. Please check PM.

$190 USD in 14 days
(5 Reviews)
3.8
fcortijo

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)
3.5
bentaylor

Please see PMB.

$100 USD in 2 days
(2 Reviews)
2.6
JivanAmara

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)
1.6
puryearit

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)
0.0
vikrant2tech

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)
0.0
CoreDbSystems

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)
0.0
Centronix

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)
0.0