mysql安装及主从复制

mysql安装及主从复制

一.mysql安装

1.下载地址

http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MYSQL-5.7/mysql-community-server-5.7.36-1.el7.x86_64.rpm 
http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MYSQL-5.7/mysql-community-client-5.7.36-1.el7.x86_64.rpm 
http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MYSQL-5.7/mysql-community-common-5.7.36-1.el7.x86_64.rpm 
http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MYSQL-5.7/mysql-community-libs-5.7.36-1.el7.x86_64.rpm 

2.上传服务器

[root@localhost mysql]# ll
总用量 212028
-rw-r--r--. 1 root root  26664808 7月  22 10:54 mysql-community-client-5.7.36-1.el7.x86_64.rpm
-rw-r--r--. 1 root root    317808 7月  22 10:54 mysql-community-common-5.7.36-1.el7.x86_64.rpm
-rw-r--r--. 1 root root   4122424 7月  22 10:54 mysql-community-devel-5.7.37-1.el7.x86_64.rpm
-rw-r--r--. 1 root root   2473272 7月  22 10:54 mysql-community-libs-5.7.36-1.el7.x86_64.rpm
-rw-r--r--. 1 root root   1263988 7月  22 10:54 mysql-community-libs-compat-5.7.36-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 182267476 7月  22 10:54 mysql-community-server-5.7.36-1.el7.x86_64.rpm

3.安装依赖包

yum -y install net-tools.x86_64 libaio.x86_64 perl.x86_64

4.安装MySQL

yum -y install mysql-community*

5.安装完成

已安装:
  mysql-community-client.x86_64 0:5.7.36-1.el7        mysql-community-common.x86_64 0:5.7.36-1.el7             mysql-community-devel.x86_64 0:5.7.37-1.el7        
  mysql-community-libs.x86_64 0:5.7.36-1.el7          mysql-community-libs-compat.x86_64 0:5.7.36-1.el7        mysql-community-server.x86_64 0:5.7.36-1.el7

6.启动mysql

systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

7.查看临时密码

grep 'password' /var/log/mysqld.log

8.修改mysql密码

mysqladmin -uroot -p'kNc;Pd;yN9>;' password 'Admin123.'

9.进入mysql

mysql -uroot -p'Admin123.'

二.mysql主从复制

1.配置hosts

[root@localhost /]# vim /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.118 master
192.168.0.119 slave

2.开启二进制日志

vim /etc/my.cnf
log_bin
server-id=1
#重启
systemctl restart mysqld

3.创建复制用户

grant replication slave,replication client on *.* to 'rep'@'从机ip' identified by 'Admin123.';
flush privileges;

4.备份主服务器数据

#备份
mysqldump -uroot -p'Admin123.' --all-databases --single-transaction --master-data=2 --flush-logs>`date +%F`-myaql-all.sql
#传输到从服务器
scp 2022-07-22-myaql-all.sql root@192.168.0.119:/tmp

5.从服务器配置

vim /etc/my.cnf
log_bin
server-id=2
gtid_mode=ON
enforce_gtid_consistency=1
#重启
systemctl restart mysqld

6.从服务器恢复数据

--临时关闭二进制日志
set sql_log_bin=0;
--恢复
source /tmp/2022-07-22-myaql-all.sql;

7.在从服务器设置主服务器

change master to 
master_host='master',
master_user='rep',
master_password='Admin123.',
#以下跟着自己现场设置
master_log_file=''
master_log_pos=;

8.启动从设备

start slave;