[MariaDB] Galera Cluster 포트 변경

(MariaDB 버전) 11.3.2-MariaDB

(OS 버전) Rocky Linux release 8.9 (Green Obsidian)

 

Step 1. MariaDB 중지

# systemctl stop mariadb

 

Step 2. Galera Cluster 설정 추가

(경로) vi /etc/my.cnf.d/server.cnf

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

[mysqld]

port=3306 

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

 

======================================  서버 1  =====================================

# galera_new_cluster

※ mariadb 가동 됩니다.

=====================================  서버 2, 3  ====================================

# systemctl start mariadb

=====================================  구성 확인  ===================================

> show status like 'wsrep%';

> show status like 'wsrep_incoming%';

# lsof -i :3306

# netstat -anp | grep mariadb

# netstat -anp | grep 192.168.112

==================================================================================