💡 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
'Mysql&MariaDB' 카테고리의 다른 글
my.cnf 설정 (1) | 2024.12.27 |
---|---|
마리아_DB 시작하기 (4) | 2024.09.14 |
Mysql 설치 (centos 7) (2) | 2024.09.13 |