环境
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,说明同步配置成功。