mariadb:galera
文書の過去の版を表示しています。
Galera
http://www.codership.com/wiki/doku.php?id=Galera%20Wiki
vi /etc/yum.repos.d/MariaDB.repo
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/5.5/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
yum install MariaDB-Galera-server MariaDB-client galera
vi /etc/my.cnf.d/server.cnf
[mysqld] max_connect_errors=999999999 wsrep_cluster_name=DBCLUSTER wsrep_cluster_address=gcomm://192.168.234.140 wsrep_node_address=192.168.234.130 wsrep_provider='/usr/lib64/galera/libgalera_smm.so' wsrep_sst_method=rsync wsrep_slave_threads=4 default_storage_engine=InnoDB binlog_format=ROW innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1
service mysql start --wsrep_cluster_address=gcomm://
mysql
MariaDB [(none)]> show status like 'wsrep_%'; +----------------------------+--------------------------------------+ | Variable_name | Value | +----------------------------+--------------------------------------+ ~省略~ | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 0 | | wsrep_causal_reads | 0 | | wsrep_incoming_addresses | 192.168.0.21:3306 | ~省略~ +----------------------------+--------------------------------------+ 40 rows in set (0.00 sec)
mariadb/galera.1439171387.txt.gz · 最終更新: 2025/02/16 13:50 (外部編集)