Not the answer you need?
Register and ask your own question!

Multi-Source replication broken

GajendraGajendra ContributorCurrent User Role Patron
Hello,

i have setup multi-source replication where i have 2 master and 1 slave

MASTER A
MASTER B
SLAVE C


but when i was trying to create a database on MASTER A and it is reduplicating on SLAVE C

then i create a same database on MASTER B so it supposed to rewrite on Slave C

but its failing and my replication is breaking for master B(channel master B)

getting error on slave cant create database "AAA" database exist

to avoid this prob. so do i need to add any parameter in my.cnf

please suggest or guide how do i make it


thanks

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hello there, I need to get this put into the right channel. Could you tell me the software and versions you are using please? Then I'll move it for you, more likely to get attention that way. Thanks!
  • GajendraGajendra Contributor Current User Role Patron
    Hi

    i am using Mysql 5.7
  • GajendraGajendra Contributor Current User Role Patron
    any one please help me here
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hi again, apologies I overlooked your update.

    OK, so I have asked the team for some input, and we're thinking that you maybe need to check into the different setups for replication to make sure you are setting up correctly. It's important to get it right, it can take time to unpick and more importantly you don't want to compromise your database. Specifically, the error is highlighting that you already set up the slave database, so you don't need to do it again during processing.
    Multi-source replication does not implement any conflict detection or resolution when applying the transactions, and those tasks are left to the application if required.

    So while you might be able to ignore the error and just continue, it's important to understand why you have it in the first place, so that you don't get trouble later on. It seems like you are wanting to achieve a MASTER <-> (MASTER+SLAVE) set up.

    So, I have found some resources for you to check through first, so that you can make sure of the model of replication that you would like to achieve:

    free ebook: https://www.percona.com/resources/mysql-ebooks/mysql-replication

    free webinars: Please check those out, then if you still have questions feel free to ask again. Thanks!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.