MariaDB Galera Cluster 建置

1

vim /etc/yum.repos.d/mariadb_10_4.repo

1
2
3
4
5
6
7

# MariaDB 10.4 CentOS repository list - created 2021-03-24 01:42 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

1

sudo yum makecache --disablerepo='*' --enablerepo='mariadb'

1
2
3
4
5
6
7

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
mariadb                                                                                                                 | 2.9 kB  00:00:00     
(1/3): mariadb/primary_db                                                                                               |  60 kB  00:00:00     
(2/3): mariadb/other_db                                                                                                 |  10 kB  00:00:00     
(3/3): mariadb/filelists_db                                                                                             | 328 kB  00:00:03     
Metadata Cache Created

1

vim /etc/yum/pluginconf.d/fastestmirror.conf

1

sudo yum install MariaDB-server MariaDB-client

1

sudo systemctl enable --now mariadb

1

sudo mysql -uroot

1

MariaDB[(none)]> set password = password("your_password");

1

Query OK, 0 rows affected (0.001 sec)

1

MariaDB[(none)]> quit;

1

sudo vim /etc/my.cnf.d/galera.cnf

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://First_Node_IP,Second_Node_IP,Third_Node_IP"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="This_Node_IP"
wsrep_node_name="This_Node_Name"

1
2

sudo systemctl stop mariadb
systemctl status mariadb

1

sudo galera_new_cluster

1

systemctl status mariadb.service

1

mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'"

1
2
3
4
5

+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 1     |
+--------------------+-------+

1

sudo systemctl start mariadb

1

mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'"

1
2
3
4
5

+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 2     |
+--------------------+-------+

1

mysql -u root  -e "CREATE DATABASE galera_sync_test"

1

mysql -u root  -e "SHOW DATABASES"

1

USE galera_sync_test; CREATE TABLE test (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(50),date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY(id));

1

desc test;

1
2
3
4
5
6
7
8

+-------+-------------+------+-----+---------------------+-------------------------------+
| Field | Type        | Null | Key | Default             | Extra                         |
+-------+-------------+------+-----+---------------------+-------------------------------+
| id    | int(11)     | NO   | PRI | NULL                | auto_increment                |
| name  | varchar(50) | YES  |     | NULL                |                               |
| date  | timestamp   | NO   |     | current_timestamp() | on update current_timestamp() |
+-------+-------------+------+-----+---------------------+-------------------------------+
3 rows in set (0.002 sec)

1

INSERT INTO galera_sync_test.test (name) VALUES ("Eric_xzk");

1

mysql -u root  -e 'INSERT INTO galera_sync_test.test (name) VALUES ("Eric_xzk_node2");'

1

SELECT * from galera_sync_test.test;

1

mysql -u root  -e 'SELECT * from galera_sync_test.test;'

1

DROP TABLE galera_sync_test.test;