Galeracluster & MariaDB 10.5.26 구성하기

💡 Galera Cluster

• Multi Master : 모든 노드에서 일기 쓰기가 가능합니다.
• 동기적 복제 : 슬레이브 지연이 없고 노드 충돌시에 데이터 손실이 없습니다.
• 일관적인 데이터: 모든 노드는 같은 상태를 유지합니다.
• Multi-thread slave : 어떠한 워크로드에서도 더 나은 성능을 가능하게 합니다.
• Hot standbt : 장애 복구시 down-time이 없습니다.
• read/wirte split 이 필요 없습니다
• Inoodb 엔진만 완벽히 지원한다.
• 동기적 복제이기에 성능이 낮은 노드에 의해 전체 성능이 결정되게 된다.

 

 

 

node1	192.168.247.134	10.5.26-MariaDB MariaDB Server
node2	192.168.247.135	10.5.26-MariaDB MariaDB Server
node3	192.168.247.137	10.5.26-MariaDB MariaDB Server

 

공통

### 방화벽 해제
systemctl  stop firewalld
systemctl disable firewalld

• vi /etc/yum.repo.d/MariaDB.cnf

# MariaDB 10.5 RedHatEnterpriseLinux repository list - created 2024-08-25 10:45 UTC
# <https://mariadb.org/download/>
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See <https://mariadb.org/mirrorbits/> for details.
# baseurl = <https://rpm.mariadb.org/10.5/rhel/$releasever/$basearch>
baseurl = <https://tw1.mirror.blendbyte.net/mariadb/yum/10.5/rhel/$releasever/$basearch>
module_hotfixes = 1
# gpgkey = <https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB>
gpgkey = <https://tw1.mirror.blendbyte.net/mariadb/yum/RPM-GPG-KEY-MariaDB>
gpgcheck = 1

 

• vi

/etc/my.cnf.d/server.cnf

• node1

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_cluster_name='cls'
wsrep_cluster_address='gcomm://192.168.247.134,192.168.247.136,192.168.247.137'
wsrep_node_address='192.168.247.134'
wsrep_node_name='node1'
wsrep_sst_method=rsync
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_provider_options="gcache.size=512M; gcache.name=/tmp/galera.cache; gcache.page_size=100M"

• node2

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_cluster_name='cls'
wsrep_cluster_address='gcomm://192.168.247.134,192.168.247.136,192.168.247.137'
wsrep_node_address='192.168.247.135'
wsrep_node_name='node2'
wsrep_sst_method=rsync
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_provider_options="gcache.size=512M; gcache.name=/tmp/galera.cache; gcache.page_size=100M"

• node3

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_cluster_name='cls'
wsrep_cluster_address='gcomm://192.168.247.134,192.168.247.136,192.168.247.137'
wsrep_node_address='192.168.247.137'
wsrep_node_name='node3'
wsrep_sst_method=rsync
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_provider_options="gcache.size=512M; gcache.name=/tmp/galera.cache; gcache.page_size=100M"

• node1

mysqld_safe --user=mysql --wsrep-new-cluster &

• node 2 && node 3

mysqld_safe --user=mysql &

• node 1에서 확인  

show status like '%wsrep%";

 

노션:https://wind-dewberry-ca7.notion.site/Galeracluster-71ec107ae952490498b1195c0a6c491e?pvs=4

-------------------------------------

참조:

https://jhdatabase.tistory.com/entry/MariaDB-Galera-Cluster-%EA%B5%AC%EC%84%B1-part-1