master my.cnf

# Gtid replication #
server-id                      = 1
binlog-format                  = ROW
log-slave-updates              = 1
master-info-repository         = TABLE
relay-log-info-repository      = TABLE
gtid-mode                      = on
enforce-gtid-consistency       = true
sync-master-info               = 1
binlog-checksum                = CRC32
master-verify-checksum         = 1
binlog-rows-query-log-events   = 1

slave my.cnf

# gtid replication #
read-only                      = 1
skip-slave-start               = 1
server-id                      = 2
binlog-format                  = ROW
# log-slave-updates              = 1
master-info-repository         = TABLE
relay-log-info-repository      = TABLE
relay-log-recovery             = on
gtid-mode                      = on
enforce-gtid-consistency       = true
sync-master-info               = 1
binlog-checksum                = CRC32
master-verify-checksum         = 1
slave-sql-verify-checksum      = 1
binlog-rows-query-log-events   = 1
slave-parallel-type            = LOGICAL_CLOCK
slave-parallel-workers         = 16

results matching ""

    No results matching ""