Mysql&MariaDB

Galeracluster & MariaDB 10.5.26 구성하기

ksk04 2024. 8. 26. 22:39

💡 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