How to do the MySQL master-master replication with conflict resolution,auto sync after fail over
We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues.
- Conflict resolution
- Auto sync after MySQL server failure
Here, We are going to write the data in both the Master MySQL servers and the data should not get conflicted at any cost. Please help us to find the best way of MySQL replication in order to achieve our requirement.
mysql replication database-replication mysql-cluster
add a comment |
We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues.
- Conflict resolution
- Auto sync after MySQL server failure
Here, We are going to write the data in both the Master MySQL servers and the data should not get conflicted at any cost. Please help us to find the best way of MySQL replication in order to achieve our requirement.
mysql replication database-replication mysql-cluster
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38
add a comment |
We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues.
- Conflict resolution
- Auto sync after MySQL server failure
Here, We are going to write the data in both the Master MySQL servers and the data should not get conflicted at any cost. Please help us to find the best way of MySQL replication in order to achieve our requirement.
mysql replication database-replication mysql-cluster
We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues.
- Conflict resolution
- Auto sync after MySQL server failure
Here, We are going to write the data in both the Master MySQL servers and the data should not get conflicted at any cost. Please help us to find the best way of MySQL replication in order to achieve our requirement.
mysql replication database-replication mysql-cluster
mysql replication database-replication mysql-cluster
asked Nov 17 '17 at 14:30
Rajasekaran MRajasekaran M
6811
6811
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38
add a comment |
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f47352996%2fhow-to-do-the-mysql-master-master-replication-with-conflict-resolution-auto-sync%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f47352996%2fhow-to-do-the-mysql-master-master-replication-with-conflict-resolution-auto-sync%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You will have to come up with a table and application scheme that prevents conflicts as base replication doesn't handle them. You could use autogen keys on each side with different starting numbers, you could attempt a GUID generation in the application because if you do it at the database, the statement will generate different GUID values and, while there won't be a conflict, you won't be able to identify the rows in each database.
– T Gray
Nov 17 '17 at 19:38