18. 검색한 웹 사이트의 설치 매뉴얼을 참고해 ubuntu02 노드에도 /etc/mysql/conf.d/galera.cnf 파일을 생성합니다.

root@ubuntu02:~# vi /etc/mysql/conf.d/galera.cnf
[mysqld]
query_cache_size = 0
binlog_format = ROW
default-storage-engine = innodb
innodb_autoinc_lock_mode = 2
query_cache_type = 0
bind-address = 0.0.0.0

Galera Provider Configuration

wsrep_on = ON wsrep_provider = /usr/lib/galera/libgalera_smm.so

Galera Cluster Configuration

wsrep_cluster_name = “test_cluster” wsrep_cluster_address = “gcomm://192.168.56.102,192.168.56.103,192.168.56.104”

Galera Synchronization Configuration

wsrep_sst_method = rsync

Galera Node Configuration

wsrep_node_address = “192.168.56.103” wsrep_node_name = “ubuntu02”