Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user12010226Mar 21 2019 — edited Mar 23 2019

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

Comments
Post Details
Added on Mar 21 2019
3 comments
197 views