I tried a lot of manuals for configuring MariaDB Galera and in all cases replication does not work. I struggled with version 10.5
Today I tried version 10.3 and the only thing that appeared was wsrep_ready | ON At 10.5, this was not the case either.
OS: CentOS 8 Stream
MariaDB:
# mysql -uroot -e 'SELECT version();'
+---------------------+
| version() |
+---------------------+
| 10.3.36-MariaDB-log |
+---------------------+
Node configs
Node1:
[mysqld]
max_connections=350
log-bin=/var/log/mysql/mysql-bin
log-bin-index=/var/log/mysql/mysql-bin.index
binlog-format = 'ROW'
default-storage-engine=innodb
#
innodb_autoinc_lock_mode=2
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
innodb_doublewrite=1
#
innodb_flush_log_at_trx_commit=0
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://10.10.84.200,10.10.84.201,10.10.84.202"
wsrep_on=ON
# Galera Cluster Configuration
wsrep_cluster_name="cluster"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="10.10.84.200"
wsrep_node_name="os-controller-01"
Node2:
[mysqld]
max_connections=350
log-bin=/var/log/mysql/mysql-bin
log-bin-index=/var/log/mysql/mysql-bin.index
binlog-format = 'ROW'
default-storage-engine=innodb
#
innodb_autoinc_lock_mode=2
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
innodb_doublewrite=1
#
innodb_flush_log_at_trx_commit=0
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://10.10.84.200,10.10.84.201,10.10.84.202"
wsrep_on=ON
# Galera Cluster Configuration
wsrep_cluster_name="cluster"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="10.10.84.201"
wsrep_node_name="os-controller-02"
Node3:
[mysqld]
max_connections=350
log-bin=/var/log/mysql/mysql-bin
log-bin-index=/var/log/mysql/mysql-bin.index
binlog-format = 'ROW'
default-storage-engine=innodb
#
innodb_autoinc_lock_mode=2
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
innodb_doublewrite=1
#
innodb_flush_log_at_trx_commit=0
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://10.10.84.200,10.10.84.201,10.10.84.202"
wsrep_on=ON
# Galera Cluster Configuration
wsrep_cluster_name="cluster"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="10.10.84.202"
wsrep_node_name="os-controller-03"
Cluster state:
MariaDB [(none)]> show status like 'wsrep_%';
+-------------------------------+----------------------+
| Variable_name | Value |
+-------------------------------+----------------------+
| wsrep_applier_thread_count | 0 |
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
| wsrep_rollbacker_thread_count | 0 |
| wsrep_thread_count | 0 |
+-------------------------------+----------------------+
14 rows in set (0.001 sec)
Firewall is disabled.
Could you help set up replication?
