MariaDB+keepalived，mariadbkeepalived

MariaDB+keepalived，mariadbkeepalived

环境
centos 6.5
MariaDB 10.0.20
下载 MariaDB
下载地址
http://mirrors.ustc.edu.cn/mariadb/mariadb-10.0.20/yum/centos6-amd64/rpms/

这里我们只下载一下四个包
MariaDB-10.0.20-centos6-x86_64-server.rpm
MariaDB-10.0.20-centos6-x86_64-client.rpm
MariaDB-10.0.20-centos6-x86_64-common.rpm
MariaDB-10.0.20-centos6-x86_64-compat.rpm
这里我们首先查看系统是否有自带的mysql
rpm -qa|grep mysql
这里提示如下

mysql-libs-5.1.71-1.el6.x86_64

然后卸载掉它！

rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

然后开始安装！
compat和common（这里特别注意他们不能分开装，因为他们互相依赖）的安装
rpm -ivh MariaDB-10.0.20-centos6-x86_64-compat.rpm MariaDB-10.0.20-centos6-x86_64-common.rpm
client的安装
rpm -ivh MariaDB-10.0.20-centos6-x86_64-client.rpm
server的安装
rpm -ivh MariaDB-10.0.20-centos6-x86_64-server.rpm
这里会提示缺少包！

warning: MariaDB-10.0.20-centos6-x86_64-server.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
error: Failed dependencies:
    perl(DBI) is needed by MariaDB-server-10.0.20-1.el6.x86_64

这里我们用yum来处理缺少的包依赖！
yum install perl-DBI
然后我们接着装server
rpm -ivh MariaDB-10.0.20-centos6-x86_64-server.rpm

启动MariaDB
service mysql start
进入mysql

配置mysql
cd /etc/my.cnf.d/
这个下面会出现这三个配置文件

mysql-clients.cnf
server.cnf
tokudb.cnf

接下来我们配置MariaDB的主主同步
这里我们采用收尾相连单向备份
环境
192.168.0.21 3306
192.168.0.22 3306
192.168.0.23 3306
配置文件修改
vim /etc/my.cnf.d/server.cnf

#192.168.0.21
server-id=1
log-bin=mysql-bin
binlog-do-db=test
relay-log=relay-bin

#192.168.0.22
server-id=2
log-bin=mysql-bin
binlog-do-db=test
relay-log=relay-bin

#192.168.0.23
server-id=3
log-bin=mysql-bin
binlog-do-db=test
relay-log=relay-bin

21上创建22的同步用户

GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO backup@'192.168.0.22' IDENTIFIED BY 'backup#sms';

22上创建23的同步用户

GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO backup@'192.168.0.23' IDENTIFIED BY 'backup#sms';

23上创建21的同步用户

GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO backup@'192.168.0.21' IDENTIFIED BY 'backup#sms';

查看主配置

show master status \G;

备机配置
master_log_file和master_log_pos要配成主机的

change master to master_host='192.168.0.21',master_user='backup',master_password='backup#sms',master_log_file='mysql-bin.000004',master_log_pos=326;

查看备机状态

show slave status\G;

启动同步，查看同步状态

start slave;
show slave status\G;

图中红框内2个参数显示yes，说明同步配置成功。