Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.8
-
None
-
None
-
Rocky Linux 9
Description
Setup the following from scratch:
- Galera Cluster with 3 nodes (A, B and C)
- Standalone MariaDB server (D)
Enable circular replication between Galera cluster and standalone server.
A is replicating to D and D is replicating to C.
Randomly insert rows from all servers.
Observations:
1) Entries in mysql.gtid_slave_pos is not in sync within cluster. A and B always have the same records but C is always different and lesser
2) Records in A and B will not reduce over time and keeps growing
3) Sometimes the server_id value will become 0
Here's my server configurations
Cluster Node A
[server]
|
|
|
[mysqld]
|
server-id=999
|
gtid_domain_id=188
|
socket = /var/lib/mysql/mysql.sock
|
log_bin=mysql-bin
|
binlog_format=ROW
|
expire_logs_days=10
|
log-error=mysqld.log
|
slow_query_log=1
|
slow_query_log_file=slow_query.log
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
innodb_flush_log_at_trx_commit=0
|
innodb_buffer_pool_size=1G
|
max_connections=2000
|
log_slave_updates=on
|
|
|
[galera]
|
wsrep_on=ON
|
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
|
wsrep_provider_options="gcache.size=2G"
|
wsrep_cluster_name="GENIQ"
|
wsrep_cluster_address="gcomm://192.168.100.188,192.168.100.192,192.168.100.193"
|
wsrep_sst_method=mariabackup
|
wsrep_sst_auth=mariabackup:xxxxxx
|
wsrep_node_name=rmq1
|
wsrep_node_address="192.168.100.188"
|
wsrep_gtid_mode=ON
|
wsrep_gtid_domain_id=999
|
|
|
[embedded]
|
|
|
[mariadb]
|
|
|
[mariadb-10.11]
|
Cluster Node B
[server]
|
|
|
[mysqld]
|
server-id=999
|
gtid_domain_id=192
|
socket = /var/lib/mysql/mysql.sock
|
log_bin=mysql-bin
|
binlog_format=ROW
|
expire_logs_days=10
|
log-error=mysqld.log
|
slow_query_log=1
|
slow_query_log_file=slow_query.log
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
innodb_flush_log_at_trx_commit=0
|
innodb_buffer_pool_size=1G
|
max_connections=2000
|
log_slave_updates=on
|
|
|
[galera]
|
wsrep_on=ON
|
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
|
wsrep_provider_options="gcache.size=2G"
|
wsrep_cluster_name="GENIQ"
|
wsrep_cluster_address="gcomm://192.168.100.188,192.168.100.192,192.168.100.193"
|
wsrep_sst_method=mariabackup
|
wsrep_sst_auth=mariabackup:xxxxxx
|
wsrep_node_name=rmq2
|
wsrep_node_address="192.168.100.192"
|
wsrep_gtid_mode=ON
|
wsrep_gtid_domain_id=999
|
|
|
[embedded]
|
|
|
[mariadb]
|
|
|
[mariadb-10.11]
|
Cluster Node C
[server]
|
|
|
[mysqld]
|
server-id=999
|
gtid_domain_id=193
|
socket = /var/lib/mysql/mysql.sock
|
log_bin=mysql-bin
|
binlog_format=ROW
|
expire_logs_days=10
|
log-error=mysqld.log
|
slow_query_log=1
|
slow_query_log_file=slow_query.log
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
innodb_flush_log_at_trx_commit=0
|
innodb_buffer_pool_size=1G
|
max_connections=2000
|
log_slave_updates=on
|
slave-skip-errors = 1032,1062,1047
|
slave_exec_mode=IDEMPOTENT
|
|
|
[galera]
|
wsrep_on=ON
|
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
|
wsrep_provider_options="gcache.size=2G"
|
wsrep_cluster_name="GENIQ"
|
wsrep_cluster_address="gcomm://192.168.100.188,192.168.100.192,192.168.100.193"
|
wsrep_sst_method=mariabackup
|
wsrep_sst_auth=mariabackup:xxxxxx
|
wsrep_node_name=rmq3
|
wsrep_node_address="192.168.100.193"
|
wsrep_restart_slave=ON
|
wsrep_gtid_mode=ON
|
wsrep_gtid_domain_id=999
|
|
|
[embedded]
|
|
|
[mariadb]
|
|
|
[mariadb-10.11]
|
Standalone Server D
[server]
|
|
|
[mysqld]
|
server-id=888
|
gtid_domain_id=197
|
log_bin=mysql-bin
|
binlog_format=ROW
|
expire_logs_days=10
|
log-error=mysqld.log
|
slow_query_log=1
|
slow_query_log_file=slow_query.log
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
innodb_flush_log_at_trx_commit=0
|
innodb_buffer_pool_size=1G
|
max_connections=2000
|
log_slave_updates=on
|
slave-skip-errors = 1062,1032
|
|
|
[galera]
|
# GTID Replication
|
wsrep_gtid_mode=ON
|
wsrep_gtid_domain_id=888
|
|
|
[embedded]
|
|
|
[mariadb]
|
|
|
[mariadb-10.11]
|