===========================主机:安装数据库===========================
设置唯一id
[root@master ~]#vim /etc/my.cnf
#[mysqld]下新增下面两行
server-id=8
log-bin
mysql 进入数据库
show master logs; 查看主机名称
mysql> show master logs;
+--------------------+-----------+
| Log_name | File_size |
+--------------------+-----------+
| centos7-bin.000001 | 154 |
+--------------------+-----------+
1 row in set (0.00 sec)
创建复制用户
grant replication slave on *.* to repluser@'10.0.0.%' identified by '123456';
===========================从机===========================
设置唯一id
[root@master ~]#vim /etc/my.cnf
#[mysqld]下新增下面一行
server-id=18
help change master to : 查看数据库配置
从机 :安装数据库
mysql 进入数据库
CHANGE MASTER TO MASTER_HOST='10.0.0.14', #:主机ip地址
MASTER_USER='repluser', #:复制用户名
MASTER_PASSWORD='123456', #:复制用户密码
MASTER_PORT=3306, #:主机端口号
MASTER_LOG_FILE='centos7-bin.000001', #:主机log_name
MASTER_LOG_POS=154; #: 主机File_size
start slave; :启动从机
show slave status\G :查看slave
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.3.17
Master_User: repluser
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mariadb-bin.000001
Read_Master_Log_Pos: 399
Relay_Log_File: mariadb-relay-bin.000002
Relay_Log_Pos: 685
Relay_Master_Log_File: mariadb-bin.000001
Slave_IO_Running: Yes #IO线程是yes
Slave_SQL_Running: Yes #SQL线程是yes