Mysql Master Master Replication | Laravel | Page 1

daring tiger Nov 1, 2023, 6:39 PM

#

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication
Hi, everyone. I am trying to set up MySQL master-master replication. I managed to set it up by following the guide at the first link. However, the databases do not resync their state when one of the databases recovers from a shutdown state.

For example, server B was down and server A had inserted 3 rows of data. The server B did not replicate the 3 rows of data after up again.

So, my question is: How can I force the data to sync after recovering from server downtime or a server failure issue?

serene rose Nov 1, 2023, 6:40 PM

#

Think you might have better luck asking on a DevOps related community

daring tiger Nov 1, 2023, 6:44 PM

#

Yeah, I think so. Just giving it a shot here too.

serene rose Nov 1, 2023, 6:47 PM

#

Also, did you read the big notice and try the suggested approach? 😅

Status: Deprecated
This tutorial has been deprecated and is no longer maintained.

Reason: This tutorial covers an outdated method for building a multi-master topology. At the time this article was originally published, group replication had not yet been implemented in MySQL.

See Instead: You can read the newer How To Configure MySQL Group Replication on Ubuntu 16.04 tutorial to set up a multi-primary replication group.

#

Published on April 26, 2013
💀

daring tiger Nov 1, 2023, 6:49 PM

#

mb, didn't notice that

serene rose Nov 1, 2023, 6:50 PM

#

No worries, at least it gives an easy opportunity to test another approach

marble mulch Nov 1, 2023, 6:58 PM

#

serene rose > Published on April 26, 2013 💀

u mad?

#Mysql Master Master Replication