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

user12010226

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

EdStevens-OC

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

Hi Ed,

Thank you didn't realize it.

Regards

3770300

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