运维作业四

运维作业四

2025/5/1 0:52:10 来源：https://blog.csdn.net/Ruimin0519/article/details/145463641 浏览: 次关键词：运维作业四

首先记得关闭防火墙，克隆的机器是未下载过MySQL

准备三台

ip分别为192.168.1.11 192.168.1.12 192.168.1.14

同时下载yum install mysql-server -y

这里选ip为192.168.1.11作为主机

vim /etc/my.cnf
server_id=100#设置id为11

重新启动mysql

systemctl restart mysqld.service

关闭防火墙

systemctl stop firewalld

vim /etc/my.cnf[client]
user=root
password=ABc1234[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.socklog-error=/var/log/mysqld. log
pid-file=/var/run/mysqld/mysqld.pidserver id=11

建立用户使用远程连接mysql> create user repl@'%' identified with mysql_native_password by 'ABc1234';

mysql> grant replication slave on *.* to repl@'%';

第二台虚拟机同样

vim /etc/my.cnf
server_id=100#设置id为12

但是要与192.168.1.11主机建立连接

mysql> change master to
-> master_host='192.168.1.11',
-> master_user='repl',
-> master_password='ABc1234',
-> master_log_file='binlog.000001',
-> master_log_pos=690;

mysql> start slave;

mysql> show slave status\G;

第三台同上

vim /etc/my.cnf
server_id=14

mysql> change master to
-> master_host='192.168.1.11',
-> master_user='repl',
-> master_password='ABc1234',
-> master_log_file='binlog.000001',
-> master_log_pos=690;

mysql> start slave;

mysql> show slave status\G;

主要配置过程完成，测试

主库：

mysql> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> use test;
Database changed
mysql> create table worker(id int(10), name varchar(20));
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> insert into worker values (1,'张三');
Query OK, 1 row affected (0.01 sec)

在从库中