# Slave config

[mariadb]

# Disable reverse DNS lookup for new connection

skip-name-resolve

# Enable GTID

gtid-domain-id=1

# Always enale gtid strict mode to avoid data inconsistency

# when the master is changed to another host

gtid_strict_mode=1

server-id=3

# Binlog name

log-bin=mysql-bin-13308

# Make binlog crash safe

sync_binlog=1

# Updates on a replica received from a primary during replication are logged in the replica's binary log

# i.e. daisy-chain replication

log_slave_updates=1

binlog_format=ROW

relay_log=mysql-relay-bin-13308

rpl_semi_sync_master_enabled=OFF

rpl_semi_sync_slave_enabled=ON

# Wait one slave ACK then commit in master's storage engine

rpl_semi_sync_master_wait_point=AFTER_SYNC

# Timeout in milliseconds, for semi-synchronous replication in the primary.

# If this timeout is exceeded in waiting on a commit for acknowledgement from a replica,

# the primary will revert to asynchronous replication.

rpl_semi_sync_master_timeout=9223372036854775807

read_only=1

binlog_row_image=FULL

innodb_buffer_pool_size=1G

innodb_buffer_pool_chunk_size=1G

character_set_server = utf8mb4

collation_server = utf8mb4_general_ci

mysql> SHOW VARIABLES LIKE '%rpl%';

+---------------------------------------+---------------------+

| Variable_name                         | Value               |

+---------------------------------------+---------------------+

| rpl_semi_sync_master_enabled          | OFF                 |

| rpl_semi_sync_master_timeout          | 9223372036854775807 |

| rpl_semi_sync_master_trace_level      | 32                  |

| rpl_semi_sync_master_wait_no_slave    | ON                  |

| rpl_semi_sync_master_wait_point       | AFTER_SYNC          |

| rpl_semi_sync_slave_delay_master      | OFF                 |

| rpl_semi_sync_slave_enabled           | ON                  |

| rpl_semi_sync_slave_kill_conn_timeout | 5                   |

| rpl_semi_sync_slave_trace_level       | 32                  |

+---------------------------------------+---------------------+

9 rows in set (0.00 sec)