Skip to main content

Mysql Master-Master replication is not working??

Comments

5 comments

  • cPanelMichael
    Hello :) You may want to consult with a qualified system administrator if you do not receive additional user feedback on this topic. A list of system administration services is available on our application catalog: cPanel Application Catalog - System Admin Services Thank you.
    0
  • dalem
    your auto-increment-offset = 1 on one of the servers needs to be set to auto-increment-offset = 2 I do believe this is one of our set ups master master server 1 ---------- server-id = 1 log_bin = /var/lib/mysql/mysql-bin.log binlog_do_db = example auto-increment-increment = 2 auto-increment-offset = 1 server 2 --------- server-id = 2 log_bin = /var/lib/mysql/mysql-bin.log binlog_do_db = example auto-increment-increment = 2 auto-increment-offset = 2
    0
  • usersanjib
    This issue is solved with the same code above and its working properly without changin anything. In my environment my Second master server has not public IP assigned, It was in my intranet, In my default gateway (router) i was forwarded the port 3306 to my Second master server. I just login my Second master server and execute this query GRANT REPLICATION SLAVE ON *.* TO 'repl_user'@'IP of my Default Gateway' IDENTIFIED BY 'password'; after that It start working... ;)
    0
  • cPanelMichael
    I am happy to see the issue is now resolved. Thank you for updating this thread with the outcome.
    0
  • double_t
    Helo usersanjib, did this work stable for you ? Thanks
    0

Please sign in to leave a comment.