MySQL Forums
Forum List  »  Replication

Re: Replication table vs database
Posted by: PER JØ'RGENSEN
Date: November 30, 2018 02:01AM

Yes - I have set this as ON

I Have the following setting in my setup for the LAST slave (HQ2)

# ----------------------------------------------------------------------
# Replication Variables
# ----------------------------------------------------------------------
server-id = 6

gtid_mode=ON
enforce_gtid_consistency = ON
enforce-gtid-consistency =TRUE
master-info-repository =TABLE
relay-log-info-repository =TABLE
relay-log-recovery =0
relay-log-purge =ON
relay-log =mysqld-relay-bin
report-host =hostname
log-slave-updates = ON
sync_master_info =1
sync_relay_log =1
sync_relay_log_info =1
slave-net-timeout =900
slave_transaction_retries =10
slave-parallel-workers =0
slave-skip-errors = all
expire_logs_days = 60
log-bin =mysql-bin
binlog_do_db =tt
replicate-do-db =tt
replicate-do-table = tt.12345_p, tt.98765_p
binlog-checksum =CRC32
binlog_row_event_max_size =8K

Not sure if any failure are here . But I cannot figure out where this goes wrong

Options: ReplyQuote


Subject
Views
Written By
Posted
652
November 29, 2018 04:05AM
354
November 29, 2018 12:59PM
Re: Replication table vs database
345
November 30, 2018 02:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.