一、下载mariadb
[root@company-dev-db01 ~]# yum install -y mriadb-server
[root@company-dev-db01 mysql]# cd /usr/share/mysql/
[root@company-dev-db01 mysql]# ll my-huge.cnf
-rw-r–r--. 1 root root 4920 4月 3 01:51 my-huge.cnf
[root@company-dev-db01 mysql]# cp /etc/my.cnf /etc/my.cnf_bak
[root@company-dev-db01 mysql]# cp my-huge.cnf /etc/my.cnf
cp:是否覆盖"/etc/my.cnf"? y
修改配置文件
[root@company-dev-db01 mysql]# vim /etc/my.cnf
log-bin=master112
server-id = 112 注:自定义,此处为ip
binlog_format=mixed
master配置:
[root@company-dev-db01 mysql]# systemctl start mariadb.service
[root@company-dev-db01 mysql]# mysql -u root -p #密码为空
MariaDB [(none)]> use mysql;
MariaDB [mysql]> show tables;
MariaDB [mysql]> select * from user;
MariaDB [mysql]> update user set password=password(‘xxx’) where user=‘root’;
#修改root密码
MariaDB [mysql]> grant all privileges on . to ‘root’@’%’ inentified by ‘xxx’ with grant option;
MariaDB[mysql]> grant replication slave on . to repluser@’%’ identified by ‘A’;
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> show master status;
±------------------±---------±-------------±-----------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
±------------------±---------±-------------±-----------------+
| master-112.000002 | 245 | | |
±------------------±---------±-------------±-----------------+
MariaDB [mysql]> exit;
[root@company-dev-db01 ~]# systemctl restart mariadb.service
slave配置:
cp配置文件过程跳过
[root@company-dev-db02 mysql]# mysql -u root -p #密码为空
MariaDB [(none)]> use mysql;
MariaDB [mysql]> change master to, #不要忘记逗号
master_host='xxx.xxx.xxx.xxx,
master_user=‘repluser’,
master_password=‘A’,
master_log_file=‘master-112.000002’, #与主库binlog日志名相同
master_log_pos=245; #偏移量,与主库相同
#若有报错仔细检查
mysql> start slave; #启动slave(io,sql线程)
mysql> show slave status\G;
Slave_IO_Running: Yes #看到yes就成功了