安装mariadb galera 10.0.22（二进制）

galera集群共三个节点，192.168.10.1/2/3分别为节点1、2、3。

1、安装依赖的包

rpm -ivh nmap-7.01-1.x86_64.rpm 
rpm -ivh nc-1.84-22.el6.x86_64.rpm
rpm -ivh galera-25.3.9-1.rhel6.el6.x86_64.rpm
tar zxf socat-2.0.0-b8.tar.gz 
cd socat-2.0.0-b8 
./configure 
make && make install

2、创建组、用户及目录

groupadd mysql
useradd -g mysql -d /home/mariadb mysql
mkdir -p /home/mariadb/product/10.0.22/galera
mkdir -p /home/mariadb/run

3、解压并复制到相关目录

tar zxf mariadb-galera-10.0.22-linux-x86_64.tar.gz
cd mariadb-galera-10.0.22-linux-x86_64
cp -r * /home/mariadb/product/10.0.22/galera

4、授权

chown -R mysql:mysql /data
chown -R mysql:mysql /home/mariadb/run
chown -R root:mysql /home/mariadb/product

5、配置my.cnf

[mysqld]
basedir=/home/mariadb/product/10.0.22/galera
datadir=/data
socket=/home/mariadb/run/mysql.sock
pid-file=/home/mariadb/run/mysqld.pid
user=mysql
symbolic-links=0
skip-host-cache
skip-name-resolve
skip-external-locking
event_scheduler=on
max_connections=1000
max_allowed_packet=10M
character-set-server=utf8
log_bin_trust_function_creators=on

server-id = 1
log-bin=mysql-bin
log-bin-index=binlogs.index
binlog_format = row

thread_cache_size=300
binlog_cache_size=8M
innodb_buffer_pool_size=102400M
innodb_file_per_table=on
innodb_sort_buffer_size=16M
innodb_log_file_size=100M
innodb_log_files_in_group=3
key_buffer_size=256M
sort_buffer_size=1M
join_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
bulk_insert_buffer_size = 16M 

[client]
default-character-set=utf8
socket=/home/mariadb/run/mysql.sock

[mysqld_safe]
log-error=/var/log/mariadb.log

节点2、3只修改server id即可

6、初始化

cd /home/mariadb/product/10.0.22/galera/scripts
 ./mysql_install_db --basedir=/home/mariadb/product/10.0.22/galera --datadir=/data --user=mysql

7、添加环境变量

vi /root/.bash_profile
#MySQL Env
export MYSQL_BASE=/home/mariadb 
export MYSQL_HOME=$MYSQL_BASE/product/10.0.22/galera
export DATADIR=/data
export LD_LIBRARY_PATH=$MYSQL_HOME/lib:/lib:/usr/lib:/usr/local/lib  
export TMPDIR=/tmp 
export PATH=$MYSQL_HOME/bin:$PATH

8、添加到系统服务，并启动

cp /home/mariadb/product/10.0.22/galera/support-files/mysql.server /etc/init.d/mariadbd
chkconfig --add mariadbd
service mariadbd start

9、删除匿名及空用户，设置root密码，并添加集群用户

delete from mysql.user where user='';
update mysql.user set host='%' where host='::1';
delete from mysql.user where host in ('127.0.0.1');
update mysql.user set password=password('123456') ;
delete from mysql.user where host in ('db01');
grant all privileges on *.* to 'wsrep'@'%' identified by 'wsrep' ;
flush privileges;  

10、创建集群配置文件

mkdir /etc/my.cnf.d  
cd /home/mariadb/product/10.0.22/galera/support-files    
cp wsrep.cnf /etc/my.cnf.d/    
vi /etc/my.cnf.d/wsrep.cnf  
[mysqld]
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_flush_log_at_trx_commit=2

wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name="galera_cluster"
wsrep_cluster_address="gcomm://192.168.10.1,192.168.10.2,192.168.10.3"
wsrep_node_address='192.168.10.1'
wsrep_node_name='db01'
wsrep_slave_threads=4
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump
wsrep_sst_auth=wsrep:wsrep

说明：前三个innodb参数可以放到/etc/my.cnf。除了要修改的参数与wsrep_slave_threads外，大部分参数为默认参数。

节点2（其它参数不变）

wsrep_node_address='192.168.10.2'
wsrep_node_name='db02'

节点3（其它参数不变）

wsrep_node_address='192.168.10.3'
wsrep_node_name='db03'

11、在/etc/my.cnf添加

!includedir /etc/my.cnf.d/     #添加到[mysqld]下面

12、重启所有节点

/etc/init.d/mariadbd stop

启动节点1
/etc/init.d/mariadbd start --wsrep-new-cluster
启动其它节点
/etc/init.d/mariadbd start

说明：先启动节点1，其它节点启动顺序不限。

13、测试

任意节点创建库表、插入数据等操作后，其它节点皆可看到。

参考：http://blog.csdn.net/yangzhawen/article/details/46310541