FileServer and MySQL replication among multiple "independent" sites with unstable WAN

I need an engineer with lots of experience in setting up complicated MySQL Replication networks.

The scope of this project is to setup (and test) the FileServers and MySQL Servers in 2 centers such that the below requirements are met.



Currently I have 1 server in 1 medical center, and all clients read/write on the MySQL and Fileserver on that server. The new setup will have 2 centers (more centers later).

Assume that the connection between the centers is very unstable (this is in Africa).



The requirements are the following:

1- Each center should be able to run on its own (even when there is no connection to other centers - This means that the clients in center 1 should be able to read/write in the MySQL DB of center 1, and the clients of center 2 should be able to read/write in the MySQL DB of center 2)

2- All the data should be replicated in all the centers so that a patient can go to any center

3- If the same patient goes to center 1 (some read/writes done in center 1), and then goes to center 2 (some read/writes done in center 2) while there is no connection between the two centers, the data should still sync without any conflicts.



- Ideally, there should be no modification needed in the client applications.

- Before awarding you the project, I will challenge you on your design to make sure that you understood all the requirements (especially #3). When placing your bid, you need to explain your design so that I can challenge it.

- If I see that you perform really well on this task, I may hire you on a more regular basis as my database manager (and if you know how to code, in PHP/jQuery then I may ask you to join the programming team too)

Thank you!

Ferdigheter: Ingeniørvitenskap, MySQL, Nettverksadministrasjon, UNIX

Se mer: the medical team, team up challenge, programming challenge sites, php and mysql connection, independent engineer, how to write medical notes, how to hire an engineer, engineer no experience needed, engineer africa, design engineer hire, challenge sites, ask an engineer, and mysql, mysql replication postgres 2009, mysql replication getafreelancer, upload multiple mysql php, mysql replication nat, php multiple file mysql upload, site multiple lanaguages mysql, search multiple field mysql

Om arbeidsgiveren:
( 37 omtaler ) Jersey City, United States

Prosjekt-ID: #10992490

Tildelt til:


Hi! I propose to use replication master-master for 2 centers and it can be modified for more center to ring replication. Replication master-master is two replication: master (1 center) - slave (2 center) and master (2 Mer

$200 USD på 4 dager
(8 omtaler)

8 frilansere byr i snitt $257 for denne jobben


Greetings, We would be pleased to present you our proposal for developing your project as per your requirements brief. We have highly qualified team who will be handling your project very efficiently and professionall Mer

$443 USD på 9 dager
(16 Omtaler)

Hi, I did same task in retail domain, where Point of sale application runs with its local database , we do have back end that manage all the product details, prices, promotions.. We have created a synchronizatio Mer

$666 USD på 10 dager
(5 Omtaler)

hello sir I have read your description. I'm doing this kind of work since 5+ years..I can give you the proper work in your convenient time..I have 5+ years experience designing and developing websites in  wordpress, PH Mer

$133 USD på 5 dager
(6 Omtaler)

Hello, I have an experience of over 2 years working on one of the biggest datacenters in my country as a system administrator. The solution to your problem is to implement a mysql master to master 2-way replication and Mer

$111 USD på 3 dager
(11 Omtaler)

Hi! Your task should be done with Percona MySQL Cluster with 3+ nodes. Note, an 1+ nodes shoud be placed in high availibility place.

$155 USD på 3 dager
(8 Omtaler)

Dear Sir I have experienced in web application development using ajax, php And mysql . and also have a experience with android application development With java and standalone app development in java. I take grea Mer

$200 USD på 3 dager
(3 Omtaler)

Hello Hiring Manager, Please send me message and also go through complete job proposal to know more about me as i have also mentioned some links of few websites developed by me. I have done Graduation in Computer Sci Mer

$222 USD på 7 dager
(7 Omtaler)

Thanks for posting this job, from the brief on your project, i discovered that this job takes so much professionalism and competence, I am known for professionalism and efficiency, i can assure you of a wonderful and g Mer

$55 USD på 3 dager
(0 Omtaler)