1
2
3

$ systemctl start mysqld.service
$ firewall-cmd --zone=public --add-port=80/tcp --permanent
$ firewall-cmd --reload

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

master服务器配置：
$ vim /etc/my.cnf
[mysqld]
server-id=1 
log-bin=mysql-bin # 启用二进制日志
slave服务器配置：
$ vim /etc/my.cnf
[mysqld]
log_bin = mysql-bin
server_id = 2
relay_log = mysql-relay-bin
log_slave_updates = 1
read_only = 1
slave-skip-errors = all #忽略因复制出现的所有错误

1

systemctl restart mysqld.service

1
2
3

mysql> mysql -u root -p
mysql> GRANT REPLICATION SLAVE ON *.* to ‘user’@‘192.168.0.124’ identified by ‘password’;
mysql> FLUSH PRIVILEGES;

1

mysql> FLUSH TABLES WITH READ LOCK;

1

mysql> show master status;

1

mysql> UNLOCK TABLES;

1
2
3
4
5
6
7

mysql> show maser status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000004 | 24364 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.02 sec)

1
2
3
4
5
6

mysql> change master to
-> master_host='192.168.0.123',
-> master_user='user',
-> master_password='password',
-> master_log_file='mysql-bin.000004',
-> master_log_pos=24364;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

mysql> start slave;
mysql> show slave status \G;
*************************** 1. row ***************************
 Slave_IO_State: Waiting for master to send event
 Master_Host: 192.169.0.123
 Master_User: user
 Master_Port: 3306
 Connect_Retry: 60
 Master_Log_File: mysql-bin.000004
 Read_Master_Log_Pos: 24364
 Relay_Log_File: mysql-relay-bin.000292
 Relay_Log_Pos: 283
 Relay_Master_Log_File: mysql-bin.000004
 Slave_IO_Running: Yes
 Slave_SQL_Running: Yes
...

1
2

mysql> create database data;
Query Ok, 1 row affected (0.01 sec)

1
2

mysql> create table user(id int(3),name char(10));
Query Ok, 1 row affected (0.00 sec)

1
2

mysql> insert into user values (001,’adcdef’);
Query Ok, 1 row affected (0.00 sec)

1234567891011121314151617181920212223242526272829303132

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || data |+--------------------+4 rows in set (0.01 sec)# 数据库data已经自动生成mysql> use dataDatabase chagedmysql> show tables;+--------------------+| Tables_in_data |+--------------------+| user |+--------------------+1 row in set (0.02 sec)# 数据库表user也已经自动创建mysql> select * from user;+------+------+| id | name |+------+------+| 1 | abcdef |+------+------+1 rows in set (0.00 sec)# 记录也已经存在