Forum Stats

  • 3,734,722 Users
  • 2,247,033 Discussions
  • 7,857,471 Comments

Discussions

MySQL 8 replication failing to replicate and im not getting any error

user12010226
user12010226 Member Posts: 5 Blue Ribbon
edited Mar 23, 2019 3:44PM in MySQL Community Space

Below are my configurations

Prod Server:

[mysqld]

datadir=/data/mysql/mysql

port=33000

server-id=1

log-bin="mysql-bin"

binlog-ignore-db=information_schema

replicate-ignore-db=information_schema

#binlog-do-db=test2

relay-log="mysql-relay-log"

auto-increment-increment = 2

auto-increment-offset = 1

DR Server:

[mysqld]

datadir=/data/mysql/mysql

port=33000

server-id=2

log-bin="mysql-bin"

binlog-ignore-db=information_schema

replicate-ignore-db=information_schema

#binlog-do-db=test2

relay-log="mysql-relay-log"

auto-increment-increment = 2

auto-increment-offset = 2

Answers

  • EdStevens-OC
    EdStevens-OC Member Posts: 55 Silver Trophy
    edited Mar 21, 2019 7:54AM
    user12010226 wrote:Below are my configurationsProd Server:[mysqld]datadir=/data/mysql/mysqlport=33000server-id=1log-bin="mysql-bin"binlog-ignore-db=information_schemareplicate-ignore-db=information_schema#binlog-do-db=test2relay-log="mysql-relay-log"auto-increment-increment = 2auto-increment-offset = 1DR Server:[mysqld]datadir=/data/mysql/mysqlport=33000server-id=2log-bin="mysql-bin"binlog-ignore-db=information_schemareplicate-ignore-db=information_schema#binlog-do-db=test2relay-log="mysql-relay-log"auto-increment-increment = 2auto-increment-offset = 2

    Why is this under "Using My Oracle Support"?

    This obviously deals with mySQL, so should be in a mySQL forum.

    LMGTFY

  • user12010226
    user12010226 Member Posts: 5 Blue Ribbon
    edited Mar 21, 2019 8:02AM

    Hi Ed,

    Thank you didn't realize it.

    Regards

  • 3770300
    3770300 Member Posts: 7
    edited Mar 23, 2019 3:44PM

    1) Why do you ignore the information_schema ? I dont think you will do any thing with that.

    binlog-ignore-db=information_schema

    replicate-ignore-db=information_schema

    2) is this the multi master setup ?

    auto-increment-increment = 2

    auto-increment-offset = 1

    auto-increment-increment = 2

    auto-increment-offset = 2

Sign In or Register to comment.