Bi-directional synchronization between multiple mysql databases

Question

0.00/5 (No votes)

See more:

Guys,

Is it possible to synch 4 databases in mysql? I mean there are 4 servers on different location and databases on server will be in Auto Synch mode. If any one goes down rest of the three gets sync automatically and it goes UP, all 4 gets synch automatically.

Please reply...!

What I have tried:

Tried with lot of things using Bi-directional synch database but hard luck.

Posted 21-Jan-18 23:34pm

Freelancers

Updated 21-Jan-18 23:42pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2018-01-21T23:42:00

Solution 1

Yes it is possible, but why not use a single database and implement a robust mirroring/backup strategy?

In any event you are way off-topic for this forum. You might be better off posting a question like this in a more relevent forum such as
Design and Architecture Discussion Boards[^], Database Discussion Boards[^] OR System Admin Discussion Boards[^] NB - pick one only.

Suggested research topics from Google[^]

Posted 21-Jan-18 23:42pm

CHill60

Comments

Freelancers 22-Jan-18 6:24am

We are looking for runtime synch as well as DML operations on all databases servers.
Is it possible?

CHill60 22-Jan-18 8:52am

My solution still stands.