ユーザ用ツール

サイト用ツール


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 (外部編集)