Build mysql master-slave service on cnetos7

This article mainly introduces how to build the master-slave server of mysql on centos. If you haven't built it before, you can check my previous blog, which has detailed installation centos and installation on centos## Description of #mysql.

1. Install the slave virtual machine:

1 ,

Right click—>Manage—>Clone

2. Select a complete clone

3.

Modify the location of the virtual machine, the default is C Under the plate.

4. After the cloning is completed, there will be two virtual machines.

Due to the two cloned servers, ip is the same, so you need to modify the slave service virtual machineip；

5. Modify the slave service virtual machine Machine configuration, open the configuration file

vi /etc/sysconfig/network-scripts/ifcfg-ens33

If you don’t know which configuration file is, you can find it as follows,

6.

Find In the red line below, change the ip address. I changed 150 to 151:

7. After the modification is completed, restart

systemctl restart network

8.

Use xShell to connect to the newly configured virtual machine

2. Configure the mysql main service:

No matter which project, 80% are all based on reading. Therefore, it is generally required that the configuration of the slave library is higher than that of the main library.

For the configuration of the main library, the main thing is to enable the binlog log.

1. Enter mysql to view the status:

 show master status;

you can see , the execution result is empty, so you need to open the binlog log;

2,

Find the configuration file of mysql:

vi /etc/my.cnf

3,

Add binloglog in the configuration file

log-bin= mysql-bin
Server-id = 1

4. Save and restart after modification:

service mysql restart

5,

Entermysql When you execute the command just now and you can see this information, it proves that the binloglog is opened successfully

对于主从复制，在本质上就是通过与从数据库复制与主数据库的binlog日志文件，通过重做实现的同步； 但是一定要注意尽量保证主从服务器上安装了相同的版本的数据库，设定主从的服务器ip地址为192.168.189.150从服务器的ip地址是192.168.189.151。

然后再主服务器上设置一个复制使用的账号，并授予replication slave权限。

5、创建一个复制用的账号：

create user 'username'@'localhost' identified by 'password';

我这里设置的账号和密码都是repl_151

6、创建成功，还没有权限，所以下一步我们需要提供一个复制的权限

grant replication slave on *.* to 'repl_151'@'%' identified by 'repl_151';

到这里我们主库就配置完成了；可以使用show master status来查看binlog日志是否发生了变化。也可以使用show binlog events in ‘mysql-bin.000001’;来查看刚刚我们所作的操作。

三.配置从库：

对从库的操作主要就是配置同步日志文件（中继日志）。

1、打开配置文件：vi /etc/my.cnf

需要设置服务的id，已经中继日志需要放到哪个地方，以及定义中继日志的索引文件（可不写）；

2、由于是克隆，所以会导致服务的uuid是相同的，执行这几行命令，将auto.cnf中的uuid清空；

3、下来要指定主库和从库的信息

change master to 
    master_host="192.168.189.150",
    master_port=3306,
    master_user="repl_151",
    master_password="repl_151",
    master_log_file="mysql-bin.000001",
    master_log_pos=0;

4、启动 start slave;

5、当看到两个红线框起来的地方都是yes的时候，表示已经配置成功了；

 到这里在centos7上配置mysql主从服务就已经完成。

推荐学习：MySQL教程

The above is the detailed content of Build mysql master-slave service on cnetos7. For more information, please follow other related articles on the PHP Chinese website!