mariadb galera 구성 질문좀 드립니다.

Question

setenforce 0 로 selinux 는 임시로 꺼둔상태입니다. 마리아디비 버전은 10.3.3 입니다. sudo yum install MariaDB-Galera-server MariaDB-client galera이걸로 설치했구요 vim /etc/my.cnf.d/server.cnf 노드1 [mysqld] server-id&#61;1binlog_format&#61;rowcharacter_set_server&#61;utf8collation_server&#61;utf8_bindefault-storage-engine&#61;Innodbinnodb_autoinc_lock_mode&#61;2innodb_locks_unsafe_for_binlog&#61;1wait_timeout&#61;2147483skip-name-resolvemax_allowed_packet&#61;128M [galera]wsrep_on&#61;ONwsrep_provider&#61;/usr/lib/galera/libgalera_smm.sowsrep_cluster_name&#61;'galera_cluster'wsrep_retry_autocommit &#61; 0wsrep_node_address&#61;노드자신의아이피wsrep_node_name&#61;'노드1이름'wsrep_sst_method&#61;rsyncwsrep_sst_auth&#61;[디비아이디:디비비번]wsrep_sst_receive_address&#61;노드자신의아이피:4568innodb_flush_log_at_trx_commit&#61;2binlog_format&#61;ROWbind-address&#61;0.0.0.0binlog_format&#61;ROWdefault-storage-engine&#61;innodbinnodb_autoinc_lock_mode&#61;2innodb_locks_unsafe_for_binlog&#61;1wsrep_cluster_address&#61;'gcomm://다른노드2아이피' 노드2 [mysqld] server-id&#61;2binlog_format&#61;rowcharacter_set_server&#61;utf8collation_server&#61;utf8_bindefault-storage-engine&#61;Innodbinnodb_autoinc_lock_mode&#61;2innodb_locks_unsafe_for_binlog&#61;1wait_timeout&#61;2147483skip-name-resolvemax_allowed_packet&#61;128M [galera]wsrep_on&#61;ONwsrep_provider&#61;/usr/lib/galera/libgalera_smm.sowsrep_cluster_name&#61;'galera_cluster'wsrep_retry_autocommit &#61; 0wsrep_node_address&#61;노드자신의아이피wsrep_node_name&#61;'노드2이름'wsrep_sst_method&#61;rsyncwsrep_sst_auth&#61;[디비아이디:디비비번]wsrep_sst_receive_address&#61;노드자신의아이피:4568innodb_flush_log_at_trx_commit&#61;2binlog_format&#61;ROWbind-address&#61;0.0.0.0binlog_format&#61;ROWdefault-storage-engine&#61;innodbinnodb_autoinc_lock_mode&#61;2innodb_locks_unsafe_for_binlog&#61;1wsrep_cluster_address&#61;'gcomm://다른노드1아이피' 1번노드는service mysql start --wsrep-new-cluster나머지 노드 한개는service mysql start 로 실행 노드가 2개라서 클러스터링이 안되는걸가요? 계속 아래의 상태네요 mysql -u root -p -e &#34;show status like 'wsrep%'&#34;Enter password:&#43;--------------------------&#43;----------------------&#43;| Variable_name | Value |&#43;--------------------------&#43;----------------------&#43;| wsrep_cluster_conf_id | 18446744073709551615 || wsrep_cluster_size | 0 || wsrep_cluster_state_uuid | || wsrep_cluster_status | Disconnected || wsrep_connected | OFF || wsrep_local_bf_aborts | 0 || wsrep_local_index | 18446744073709551615 || wsrep_provider_name | || wsrep_provider_vendor | || wsrep_provider_version | || wsrep_ready | ON || wsrep_thread_count | 0 |&#43;--------------------------&#43;----------------------&#43; 왜 클러스터링이 되지 않는걸가요?

visualp · Answer

galera_new_cluster 로 실행 해보세요

시스파고 · Answer

https://syspago.tistory.com/3galera cluster하시는데 도움이 되실거에요~

mariadb galera 구성 질문좀 드립니다.

2개의 답변

#galera 목록