本篇为测试过程，总结文章将请看下一个篇，具体过程如下：
计算
安全
数据库
网络和加速
企业服务
[root@es2 ~]# yum -y install mysql-community-*
已加载插件：fastestmirror
正在检查 mysql-community-client-8.0.17-1.el7.x86_64.rpm: mysql-community-client-8.0.17-1.el7.x86_64
mysql-community-client-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-common-8.0.17-1.el7.x86_64.rpm: mysql-community-common-8.0.17-1.el7.x86_64
mysql-community-common-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-devel-8.0.17-1.el7.x86_64.rpm: mysql-community-devel-8.0.17-1.el7.x86_64
mysql-community-devel-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-libs-8.0.17-1.el7.x86_64.rpm: mysql-community-libs-8.0.17-1.el7.x86_64
mysql-community-libs-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm: mysql-community-libs-compat-8.0.17-1.el7.x86_64
mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-server-8.0.17-1.el7.x86_64.rpm: mysql-community-server-8.0.17-1.el7.x86_64
mysql-community-server-8.0.17-1.el7.x86_64.rpm 将被安装
正在解决依赖关系
--> 正在检查事务
---> 软件包 mariadb-libs.x86_64.1.5.5.60-1.el7_5 将被 取代
---> 软件包 mysql-community-client.x86_64.0.8.0.17-1.el7 将被 安装
---> 软件包 mysql-community-common.x86_64.0.8.0.17-1.el7 将被 安装
---> 软件包 mysql-community-devel.x86_64.0.8.0.17-1.el7 将被 安装
--> 正在处理依赖关系 pkgconfig(openssl)，它被软件包 mysql-community-devel-8.0.17-1.el7.x86_64 需要
Determining fastest mirrors
epel/x86_64/metalink | 7.2 kB 00:00:00
* base: mirrors.tuna.tsinghua.edu.cn
* epel: mirrors.tuna.tsinghua.edu.cn
* extras: mirrors.tuna.tsinghua.edu.cn
* updates: mirrors.huaweicloud.com
base | 3.6 kB 00:00:00
epel | 5.4 kB 00:00:00
extras | 3.4 kB 00:00:00
updates | 3.4 kB 00:00:00
epel/x86_64/primary_db FAILED
http://fedora.cs.nctu.edu.tw/epel/7/x86_64/repodata/4a7d82b70bc90863a6b385eba39ccba096dabc9d26ccf8e1917539f2d02dc6b9-primary.sqlite.bz2: [Errno 14] HTTP Error 404 - Not Found
正在尝试其它镜像。
To address this issue please refer to the below wiki article
https://wiki.centos.org/yum-errors
If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
(1/3): epel/x86_64/group_gz | 88 kB 00:00:00
(2/3): epel/x86_64/updateinfo | 998 kB 00:00:10
(3/3): epel/x86_64/primary_db | 6.8 MB 00:00:21
---> 软件包 mysql-community-libs.x86_64.0.8.0.17-1.el7 将被 舍弃
---> 软件包 mysql-community-libs-compat.x86_64.0.8.0.17-1.el7 将被 舍弃
---> 软件包 mysql-community-server.x86_64.0.8.0.17-1.el7 将被 安装
--> 正在检查事务
---> 软件包 openssl-devel.x86_64.1.1.0.2k-16.el7_6.1 将被 安装
--> 正在处理依赖关系 openssl-libs(x86-64) = 1:1.0.2k-16.el7_6.1，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在处理依赖关系 zlib-devel(x86-64)，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在处理依赖关系 krb5-devel(x86-64)，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在检查事务
---> 软件包 krb5-devel.x86_64.0.1.15.1-37.el7_6 将被 安装
--> 正在处理依赖关系 libkadm5(x86-64) = 1.15.1-37.el7_6，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 krb5-libs(x86-64) = 1.15.1-37.el7_6，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libverto-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libselinux-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libcom_err-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 keyutils-libs-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
---> 软件包 openssl-libs.x86_64.1.1.0.2k-16.el7 将被 升级
--> 正在处理依赖关系 openssl-libs(x86-64) = 1:1.0.2k-16.el7，它被软件包 1:openssl-1.0.2k-16.el7.x86_64 需要
---> 软件包 openssl-libs.x86_64.1.1.0.2k-16.el7_6.1 将被 更新
---> 软件包 zlib-devel.x86_64.0.1.2.7-18.el7 将被 安装
--> 正在检查事务
---> 软件包 keyutils-libs-devel.x86_64.0.1.5.8-3.el7 将被 安装
---> 软件包 krb5-libs.x86_64.0.1.15.1-34.el7 将被 升级
---> 软件包 krb5-libs.x86_64.0.1.15.1-37.el7_6 将被 更新
---> 软件包 libcom_err-devel.x86_64.0.1.42.9-13.el7 将被 安装
---> 软件包 libkadm5.x86_64.0.1.15.1-37.el7_6 将被 安装
---> 软件包 libselinux-devel.x86_64.0.2.5-14.1.el7 将被 安装
--> 正在处理依赖关系 libsepol-devel(x86-64) >= 2.5-10，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
--> 正在处理依赖关系 pkgconfig(libsepol)，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
--> 正在处理依赖关系 pkgconfig(libpcre)，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
---> 软件包 libverto-devel.x86_64.0.0.2.5-4.el7 将被 安装
---> 软件包 openssl.x86_64.1.1.0.2k-16.el7 将被 升级
---> 软件包 openssl.x86_64.1.1.0.2k-16.el7_6.1 将被 更新
--> 正在检查事务
---> 软件包 libsepol-devel.x86_64.0.2.5-10.el7 将被 安装
---> 软件包 pcre-devel.x86_64.0.8.32-17.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
====================================================================================================================================================================
Package 架构 版本 源 大小
====================================================================================================================================================================
正在安装:
mysql-community-client x86_64 8.0.17-1.el7 /mysql-community-client-8.0.17-1.el7.x86_64 146 M
mysql-community-common x86_64 8.0.17-1.el7 /mysql-community-common-8.0.17-1.el7.x86_64 8.3 M
mysql-community-devel x86_64 8.0.17-1.el7 /mysql-community-devel-8.0.17-1.el7.x86_64 34 M
mysql-community-libs x86_64 8.0.17-1.el7 /mysql-community-libs-8.0.17-1.el7.x86_64 14 M
替换 mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-libs-compat x86_64 8.0.17-1.el7 /mysql-community-libs-compat-8.0.17-1.el7.x86_64 9.5 M
替换 mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-server x86_64 8.0.17-1.el7 /mysql-community-server-8.0.17-1.el7.x86_64 1.8 G
为依赖而安装:
keyutils-libs-devel x86_64 1.5.8-3.el7 base 37 k
krb5-devel x86_64 1.15.1-37.el7_6 updates 271 k
libcom_err-devel x86_64 1.42.9-13.el7 base 31 k
libkadm5 x86_64 1.15.1-37.el7_6 updates 178 k
libselinux-devel x86_64 2.5-14.1.el7 base 187 k
libsepol-devel x86_64 2.5-10.el7 base 77 k
libverto-devel x86_64 0.2.5-4.el7 base 12 k
openssl-devel x86_64 1:1.0.2k-16.el7_6.1 updates 1.5 M
pcre-devel x86_64 8.32-17.el7 base 480 k
zlib-devel x86_64 1.2.7-18.el7 base 50 k
为依赖而更新:
krb5-libs x86_64 1.15.1-37.el7_6 updates 803 k
openssl x86_64 1:1.0.2k-16.el7_6.1 updates 493 k
openssl-libs x86_64 1:1.0.2k-16.el7_6.1 updates 1.2 M
事务概要
====================================================================================================================================================================
安装 6 软件包 (+10 依赖软件包)
升级 ( 3 依赖软件包)
总计：2.0 G
总下载量：5.3 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/13): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm | 37 kB 00:00:00
(2/13): libcom_err-devel-1.42.9-13.el7.x86_64.rpm | 31 kB 00:00:00
(3/13): libsepol-devel-2.5-10.el7.x86_64.rpm | 77 kB 00:00:00
(4/13): krb5-devel-1.15.1-37.el7_6.x86_64.rpm | 271 kB 00:00:02
(5/13): libselinux-devel-2.5-14.1.el7.x86_64.rpm | 187 kB 00:00:01
(6/13): krb5-libs-1.15.1-37.el7_6.x86_64.rpm | 803 kB 00:00:04
(7/13): openssl-libs-1.0.2k-16.el7_6.1.x86_64.rpm | 1.2 MB 00:00:03
(8/13): pcre-devel-8.32-17.el7.x86_64.rpm | 480 kB 00:00:02
(9/13): zlib-devel-1.2.7-18.el7.x86_64.rpm | 50 kB 00:00:00
(10/13): openssl-devel-1.0.2k-16.el7_6.1.x86_64.rpm | 1.5 MB 00:00:07
(11/13): libverto-devel-0.2.5-4.el7.x86_64.rpm | 12 kB 00:00:27
(12/13): libkadm5-1.15.1-37.el7_6.x86_64.rpm | 178 kB 00:00:30
openssl-1.0.2k-16.el7_6.1.x86_ FAILED
http://mirrors.163.com/centos/7.6.1810/updates/x86_64/Packages/openssl-1.0.2k-16.el7_6.1.x86_64.rpm: [Errno 12] Timeout on http://mirrors.163.com/centos/7.6.1810/updates/x86_64/Packages/openssl-1.0.2k-16.el7_6.1.x86_64.rpm: (28, 'Operation too slow. Less than 1000 bytes/sec transferred the last 30 seconds')
正在尝试其它镜像。
(13/13): openssl-1.0.2k-16.el7_6.1.x86_64.rpm | 493 kB 00:00:10
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 123 kB/s | 5.3 MB 00:00:43
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64 1/23
正在更新 : krb5-libs-1.15.1-37.el7_6.x86_64 2/23
正在安装 : mysql-community-common-8.0.17-1.el7.x86_64 3/23
正在安装 : mysql-community-libs-8.0.17-1.el7.x86_64 4/23
正在安装 : mysql-community-client-8.0.17-1.el7.x86_64 5/23
正在安装 : libkadm5-1.15.1-37.el7_6.x86_64 6/23
正在安装 : libsepol-devel-2.5-10.el7.x86_64 7/23
正在安装 : pcre-devel-8.32-17.el7.x86_64 8/23
正在安装 : libselinux-devel-2.5-14.1.el7.x86_64 9/23
正在安装 : zlib-devel-1.2.7-18.el7.x86_64 10/23
正在安装 : libverto-devel-0.2.5-4.el7.x86_64 11/23
正在安装 : libcom_err-devel-1.42.9-13.el7.x86_64 12/23
正在安装 : keyutils-libs-devel-1.5.8-3.el7.x86_64 13/23
正在安装 : krb5-devel-1.15.1-37.el7_6.x86_64 14/23
正在安装 : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 15/23
正在安装 : mysql-community-devel-8.0.17-1.el7.x86_64 16/23
正在安装 : mysql-community-server-8.0.17-1.el7.x86_64 17/23
正在安装 : mysql-community-libs-compat-8.0.17-1.el7.x86_64 18/23
正在更新 : 1:openssl-1.0.2k-16.el7_6.1.x86_64 19/23
清理 : 1:openssl-1.0.2k-16.el7.x86_64 20/23
正在删除 : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 21/23
清理 : krb5-libs-1.15.1-34.el7.x86_64 22/23
清理 : 1:openssl-libs-1.0.2k-16.el7.x86_64 23/23
验证中 : keyutils-libs-devel-1.5.8-3.el7.x86_64 1/23
验证中 : mysql-community-devel-8.0.17-1.el7.x86_64 2/23
验证中 : libcom_err-devel-1.42.9-13.el7.x86_64 3/23
验证中 : krb5-devel-1.15.1-37.el7_6.x86_64 4/23
验证中 : mysql-community-libs-8.0.17-1.el7.x86_64 5/23
验证中 : libverto-devel-0.2.5-4.el7.x86_64 6/23
验证中 : zlib-devel-1.2.7-18.el7.x86_64 7/23
验证中 : krb5-libs-1.15.1-37.el7_6.x86_64 8/23
验证中 : pcre-devel-8.32-17.el7.x86_64 9/23
验证中 : mysql-community-client-8.0.17-1.el7.x86_64 10/23
验证中 : 1:openssl-1.0.2k-16.el7_6.1.x86_64 11/23
验证中 : mysql-community-common-8.0.17-1.el7.x86_64 12/23
验证中 : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64 13/23
验证中 : libsepol-devel-2.5-10.el7.x86_64 14/23
验证中 : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 15/23
验证中 : mysql-community-server-8.0.17-1.el7.x86_64 16/23
验证中 : libkadm5-1.15.1-37.el7_6.x86_64 17/23
验证中 : libselinux-devel-2.5-14.1.el7.x86_64 18/23
验证中 : mysql-community-libs-compat-8.0.17-1.el7.x86_64 19/23
验证中 : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 20/23
验证中 : 1:openssl-1.0.2k-16.el7.x86_64 21/23
验证中 : 1:openssl-libs-1.0.2k-16.el7.x86_64 22/23
验证中 : krb5-libs-1.15.1-34.el7.x86_64 23/23
已安装:
mysql-community-client.x86_64 0:8.0.17-1.el7 mysql-community-common.x86_64 0:8.0.17-1.el7 mysql-community-devel.x86_64 0:8.0.17-1.el7
mysql-community-libs.x86_64 0:8.0.17-1.el7 mysql-community-libs-compat.x86_64 0:8.0.17-1.el7 mysql-community-server.x86_64 0:8.0.17-1.el7
作为依赖被安装:
keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.15.1-37.el7_6 libcom_err-devel.x86_64 0:1.42.9-13.el7 libkadm5.x86_64 0:1.15.1-37.el7_6
libselinux-devel.x86_64 0:2.5-14.1.el7 libsepol-devel.x86_64 0:2.5-10.el7 libverto-devel.x86_64 0:0.2.5-4.el7 openssl-devel.x86_64 1:1.0.2k-16.el7_6.1
pcre-devel.x86_64 0:8.32-17.el7 zlib-devel.x86_64 0:1.2.7-18.el7
作为依赖被升级:
krb5-libs.x86_64 0:1.15.1-37.el7_6 openssl.x86_64 1:1.0.2k-16.el7_6.1 openssl-libs.x86_64 1:1.0.2k-16.el7_6.1
替代:
mariadb-libs.x86_64 1:5.5.60-1.el7_5
完毕！
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 16:23:24 2019 from 192.168.56.1
[root@es3 ~]# yum -y localinstall mysql-community-*
已加载插件：fastestmirror
正在检查 mysql-community-client-8.0.17-1.el7.x86_64.rpm: mysql-community-client-8.0.17-1.el7.x86_64
mysql-community-client-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-common-8.0.17-1.el7.x86_64.rpm: mysql-community-common-8.0.17-1.el7.x86_64
mysql-community-common-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-devel-8.0.17-1.el7.x86_64.rpm: mysql-community-devel-8.0.17-1.el7.x86_64
mysql-community-devel-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-libs-8.0.17-1.el7.x86_64.rpm: mysql-community-libs-8.0.17-1.el7.x86_64
mysql-community-libs-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm: mysql-community-libs-compat-8.0.17-1.el7.x86_64
mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm 将被安装
正在检查 mysql-community-server-8.0.17-1.el7.x86_64.rpm: mysql-community-server-8.0.17-1.el7.x86_64
mysql-community-server-8.0.17-1.el7.x86_64.rpm 将被安装
正在解决依赖关系
--> 正在检查事务
---> 软件包 mariadb-libs.x86_64.1.5.5.60-1.el7_5 将被 取代
---> 软件包 mysql-community-client.x86_64.0.8.0.17-1.el7 将被 安装
---> 软件包 mysql-community-common.x86_64.0.8.0.17-1.el7 将被 安装
---> 软件包 mysql-community-devel.x86_64.0.8.0.17-1.el7 将被 安装
--> 正在处理依赖关系 pkgconfig(openssl)，它被软件包 mysql-community-devel-8.0.17-1.el7.x86_64 需要
Determining fastest mirrors
epel/x86_64/metalink | 7.2 kB 00:00:00
* base: mirrors.aliyun.com
* epel: mirrors.tuna.tsinghua.edu.cn
* extras: mirrors.aliyun.com
* updates: mirror.jdcloud.com
base | 3.6 kB 00:00:00
epel | 5.4 kB 00:00:00
extras | 3.4 kB 00:00:00
updates | 3.4 kB 00:00:00
epel/x86_64/updateinfo FAILED ] 0.0 B/s | 0 B --:--:-- ETA
http://fedora.cs.nctu.edu.tw/epel/7/x86_64/repodata/73e5709a1cb420a1cbf22ead472e9b0dd44afe50a0e313647e4c584427a5e841-updateinfo.xml.bz2: [Errno 14] HTTP Error 404 - Not Found
正在尝试其它镜像。
To address this issue please refer to the below wiki article
https://wiki.centos.org/yum-errors
If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
(1/3): epel/x86_64/group_gz | 88 kB 00:00:01
(2/3): epel/x86_64/updateinfo | 998 kB 00:00:15
(3/3): epel/x86_64/primary_db | 6.8 MB 00:00:21
---> 软件包 mysql-community-libs.x86_64.0.8.0.17-1.el7 将被 舍弃
---> 软件包 mysql-community-libs-compat.x86_64.0.8.0.17-1.el7 将被 舍弃
---> 软件包 mysql-community-server.x86_64.0.8.0.17-1.el7 将被 安装
--> 正在检查事务
---> 软件包 openssl-devel.x86_64.1.1.0.2k-16.el7_6.1 将被 安装
--> 正在处理依赖关系 openssl-libs(x86-64) = 1:1.0.2k-16.el7_6.1，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在处理依赖关系 zlib-devel(x86-64)，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在处理依赖关系 krb5-devel(x86-64)，它被软件包 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 需要
--> 正在检查事务
---> 软件包 krb5-devel.x86_64.0.1.15.1-37.el7_6 将被 安装
--> 正在处理依赖关系 libkadm5(x86-64) = 1.15.1-37.el7_6，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 krb5-libs(x86-64) = 1.15.1-37.el7_6，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libverto-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libselinux-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 libcom_err-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
--> 正在处理依赖关系 keyutils-libs-devel，它被软件包 krb5-devel-1.15.1-37.el7_6.x86_64 需要
---> 软件包 openssl-libs.x86_64.1.1.0.2k-16.el7 将被 升级
--> 正在处理依赖关系 openssl-libs(x86-64) = 1:1.0.2k-16.el7，它被软件包 1:openssl-1.0.2k-16.el7.x86_64 需要
---> 软件包 openssl-libs.x86_64.1.1.0.2k-16.el7_6.1 将被 更新
---> 软件包 zlib-devel.x86_64.0.1.2.7-18.el7 将被 安装
--> 正在检查事务
---> 软件包 keyutils-libs-devel.x86_64.0.1.5.8-3.el7 将被 安装
---> 软件包 krb5-libs.x86_64.0.1.15.1-34.el7 将被 升级
---> 软件包 krb5-libs.x86_64.0.1.15.1-37.el7_6 将被 更新
---> 软件包 libcom_err-devel.x86_64.0.1.42.9-13.el7 将被 安装
---> 软件包 libkadm5.x86_64.0.1.15.1-37.el7_6 将被 安装
---> 软件包 libselinux-devel.x86_64.0.2.5-14.1.el7 将被 安装
--> 正在处理依赖关系 libsepol-devel(x86-64) >= 2.5-10，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
--> 正在处理依赖关系 pkgconfig(libsepol)，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
--> 正在处理依赖关系 pkgconfig(libpcre)，它被软件包 libselinux-devel-2.5-14.1.el7.x86_64 需要
---> 软件包 libverto-devel.x86_64.0.0.2.5-4.el7 将被 安装
---> 软件包 openssl.x86_64.1.1.0.2k-16.el7 将被 升级
---> 软件包 openssl.x86_64.1.1.0.2k-16.el7_6.1 将被 更新
--> 正在检查事务
---> 软件包 libsepol-devel.x86_64.0.2.5-10.el7 将被 安装
---> 软件包 pcre-devel.x86_64.0.8.32-17.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
====================================================================================================================================================================
Package 架构 版本 源 大小
====================================================================================================================================================================
正在安装:
mysql-community-client x86_64 8.0.17-1.el7 /mysql-community-client-8.0.17-1.el7.x86_64 146 M
mysql-community-common x86_64 8.0.17-1.el7 /mysql-community-common-8.0.17-1.el7.x86_64 8.3 M
mysql-community-devel x86_64 8.0.17-1.el7 /mysql-community-devel-8.0.17-1.el7.x86_64 34 M
mysql-community-libs x86_64 8.0.17-1.el7 /mysql-community-libs-8.0.17-1.el7.x86_64 14 M
替换 mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-libs-compat x86_64 8.0.17-1.el7 /mysql-community-libs-compat-8.0.17-1.el7.x86_64 9.5 M
替换 mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-server x86_64 8.0.17-1.el7 /mysql-community-server-8.0.17-1.el7.x86_64 1.8 G
为依赖而安装:
keyutils-libs-devel x86_64 1.5.8-3.el7 base 37 k
krb5-devel x86_64 1.15.1-37.el7_6 updates 271 k
libcom_err-devel x86_64 1.42.9-13.el7 base 31 k
libkadm5 x86_64 1.15.1-37.el7_6 updates 178 k
libselinux-devel x86_64 2.5-14.1.el7 base 187 k
libsepol-devel x86_64 2.5-10.el7 base 77 k
libverto-devel x86_64 0.2.5-4.el7 base 12 k
openssl-devel x86_64 1:1.0.2k-16.el7_6.1 updates 1.5 M
pcre-devel x86_64 8.32-17.el7 base 480 k
zlib-devel x86_64 1.2.7-18.el7 base 50 k
为依赖而更新:
krb5-libs x86_64 1.15.1-37.el7_6 updates 803 k
openssl x86_64 1:1.0.2k-16.el7_6.1 updates 493 k
openssl-libs x86_64 1:1.0.2k-16.el7_6.1 updates 1.2 M
事务概要
====================================================================================================================================================================
安装 6 软件包 (+10 依赖软件包)
升级 ( 3 依赖软件包)
总计：2.0 G
总下载量：5.3 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/13): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm | 37 kB 00:00:00
(2/13): libcom_err-devel-1.42.9-13.el7.x86_64.rpm | 31 kB 00:00:00
(3/13): libsepol-devel-2.5-10.el7.x86_64.rpm | 77 kB 00:00:00
(4/13): libverto-devel-0.2.5-4.el7.x86_64.rpm | 12 kB 00:00:00
(5/13): libkadm5-1.15.1-37.el7_6.x86_64.rpm | 178 kB 00:00:02
(6/13): krb5-devel-1.15.1-37.el7_6.x86_64.rpm | 271 kB 00:00:02
(7/13): libselinux-devel-2.5-14.1.el7.x86_64.rpm | 187 kB 00:00:02
(8/13): openssl-1.0.2k-16.el7_6.1.x86_64.rpm | 493 kB 00:00:04
(9/13): zlib-devel-1.2.7-18.el7.x86_64.rpm | 50 kB 00:00:00
(10/13): pcre-devel-8.32-17.el7.x86_64.rpm | 480 kB 00:00:05
(11/13): openssl-libs-1.0.2k-16.el7_6.1.x86_64.rpm | 1.2 MB 00:00:08
(12/13): openssl-devel-1.0.2k-16.el7_6.1.x86_64.rpm | 1.5 MB 00:00:09
(13/13): krb5-libs-1.15.1-37.el7_6.x86_64.rpm | 803 kB 00:00:13
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 407 kB/s | 5.3 MB 00:00:13
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64 1/23
正在更新 : krb5-libs-1.15.1-37.el7_6.x86_64 2/23
正在安装 : mysql-community-common-8.0.17-1.el7.x86_64 3/23
正在安装 : mysql-community-libs-8.0.17-1.el7.x86_64 4/23
正在安装 : mysql-community-client-8.0.17-1.el7.x86_64 5/23
正在安装 : libkadm5-1.15.1-37.el7_6.x86_64 6/23
正在安装 : libsepol-devel-2.5-10.el7.x86_64 7/23
正在安装 : pcre-devel-8.32-17.el7.x86_64 8/23
正在安装 : libselinux-devel-2.5-14.1.el7.x86_64 9/23
正在安装 : zlib-devel-1.2.7-18.el7.x86_64 10/23
正在安装 : libverto-devel-0.2.5-4.el7.x86_64 11/23
正在安装 : libcom_err-devel-1.42.9-13.el7.x86_64 12/23
正在安装 : keyutils-libs-devel-1.5.8-3.el7.x86_64 13/23
正在安装 : krb5-devel-1.15.1-37.el7_6.x86_64 14/23
正在安装 : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 15/23
正在安装 : mysql-community-devel-8.0.17-1.el7.x86_64 16/23
正在安装 : mysql-community-server-8.0.17-1.el7.x86_64 17/23
正在安装 : mysql-community-libs-compat-8.0.17-1.el7.x86_64 18/23
正在更新 : 1:openssl-1.0.2k-16.el7_6.1.x86_64 19/23
清理 : 1:openssl-1.0.2k-16.el7.x86_64 20/23
正在删除 : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 21/23
清理 : krb5-libs-1.15.1-34.el7.x86_64 22/23
清理 : 1:openssl-libs-1.0.2k-16.el7.x86_64 23/23
验证中 : keyutils-libs-devel-1.5.8-3.el7.x86_64 1/23
验证中 : mysql-community-devel-8.0.17-1.el7.x86_64 2/23
验证中 : libcom_err-devel-1.42.9-13.el7.x86_64 3/23
验证中 : krb5-devel-1.15.1-37.el7_6.x86_64 4/23
验证中 : mysql-community-libs-8.0.17-1.el7.x86_64 5/23
验证中 : libverto-devel-0.2.5-4.el7.x86_64 6/23
验证中 : zlib-devel-1.2.7-18.el7.x86_64 7/23
验证中 : krb5-libs-1.15.1-37.el7_6.x86_64 8/23
验证中 : pcre-devel-8.32-17.el7.x86_64 9/23
验证中 : mysql-community-client-8.0.17-1.el7.x86_64 10/23
验证中 : 1:openssl-1.0.2k-16.el7_6.1.x86_64 11/23
验证中 : mysql-community-common-8.0.17-1.el7.x86_64 12/23
验证中 : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64 13/23
验证中 : libsepol-devel-2.5-10.el7.x86_64 14/23
验证中 : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64 15/23
验证中 : mysql-community-server-8.0.17-1.el7.x86_64 16/23
验证中 : libkadm5-1.15.1-37.el7_6.x86_64 17/23
验证中 : libselinux-devel-2.5-14.1.el7.x86_64 18/23
验证中 : mysql-community-libs-compat-8.0.17-1.el7.x86_64 19/23
验证中 : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 20/23
验证中 : 1:openssl-1.0.2k-16.el7.x86_64 21/23
验证中 : 1:openssl-libs-1.0.2k-16.el7.x86_64 22/23
验证中 : krb5-libs-1.15.1-34.el7.x86_64 23/23
已安装:
mysql-community-client.x86_64 0:8.0.17-1.el7 mysql-community-common.x86_64 0:8.0.17-1.el7 mysql-community-devel.x86_64 0:8.0.17-1.el7
mysql-community-libs.x86_64 0:8.0.17-1.el7 mysql-community-libs-compat.x86_64 0:8.0.17-1.el7 mysql-community-server.x86_64 0:8.0.17-1.el7
作为依赖被安装:
keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.15.1-37.el7_6 libcom_err-devel.x86_64 0:1.42.9-13.el7 libkadm5.x86_64 0:1.15.1-37.el7_6
libselinux-devel.x86_64 0:2.5-14.1.el7 libsepol-devel.x86_64 0:2.5-10.el7 libverto-devel.x86_64 0:0.2.5-4.el7 openssl-devel.x86_64 1:1.0.2k-16.el7_6.1
pcre-devel.x86_64 0:8.32-17.el7 zlib-devel.x86_64 0:1.2.7-18.el7
作为依赖被升级:
krb5-libs.x86_64 0:1.15.1-37.el7_6 openssl.x86_64 1:1.0.2k-16.el7_6.1 openssl-libs.x86_64 1:1.0.2k-16.el7_6.1
替代:
mariadb-libs.x86_64 1:5.5.60-1.el7_5
完毕！
[root@es3 ~]# exit
登出
Connection to es3 closed.
[root@es2 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
"/etc/my.cnf" 35L, 1312C 已写入
[root@es2 ~]# systemctl start mysqld
[root@es2 ~]# netstat -nltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 3293/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 3535/master
tcp6 0 0 :::3306 :::* LISTEN 4057/mysqld
tcp6 0 0 :::22 :::* LISTEN 3293/sshd
tcp6 0 0 ::1:25 :::* LISTEN 3535/master
tcp6 0 0 :::33060 :::* LISTEN 4057/mysqld
[root@es2 ~]# cat /etc/my.cnf |grep -iv on
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# this will increase compatibility with older clients. For background, see:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@es2 ~]# cat /etc/my.cnf |grep -i on
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Remove leading # to revert to previous value for default_authentication_plugin,
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
[root@es2 ~]# cat /etc/my.cnf |grep ON
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
[root@es2 ~]# cat /var/log/mysqld.log |grep password
2019-08-28T08:50:17.669803Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: iwSeuFagt0&3
[root@es2 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@es2 ~]# mysql -p'iwSeuFagt0&3'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.17
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user user() identified by 'iwSeuFagt0&31';
Query OK, 0 rows affected (0.33 sec)
mysql> exit
Bye
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 16:42:33 2019 from es2
[root@es3 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
"/etc/my.cnf" 35L, 1312C 已写入
[root@es3 ~]# systemctl start mysqld
[root@es3 ~]# cat /var/log/mysqld.log |grep password
2019-08-28T08:54:27.953612Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: kfzvo3Won:5r
[root@es3 ~]# mysql -p'kfzvo3Won:5r'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user user() identified by 'iwSeuFagt0&31';
Query OK, 0 rows affected (0.06 sec)
mysql> exit
Bye
[root@es3 ~]# exit
登出
Connection to es3 closed.
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.12 sec)
mysql> CREATE USER clone_user@'%' identified by 'iwSeuFagt0&31';
Query OK, 0 rows affected (0.07 sec)
mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user';
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE USER repl_user@'%' identified by 'iwSeuFagt0&31'
-> ;
Query OK, 0 rows affected (0.02 sec)
mysql> grant replication slave on *.* to repl_user;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
mysql> exit
Bye
[root@es2 ~]# mysql -uclone_user -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> shwo variables like 'se%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'shwo variables like 'se%'' at line 1
mysql> show variables like 'se%';
+---------------------------------+------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------------------------------------------------------+
| secondary_engine_cost_threshold | 100000.000000 |
| secure_file_priv | /var/lib/mysql-files/ |
| server_id | 1 |
| server_id_bits | 32 |
| server_uuid | dbda28c9-c970-11e9-b268-0800275c8ec3 |
| session_track_gtids | OFF |
| session_track_schema | ON |
| session_track_state_change | OFF |
| session_track_system_variables | time_zone,autocommit,character_set_client,character_set_results,character_set_connection |
| session_track_transaction_info | OFF |
+---------------------------------+------------------------------------------------------------------------------------------+
10 rows in set (0.01 sec)
mysql> show variables like 'secure_file_priv';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.00 sec)
mysql> CLONE LOCAL DATA DIRECTORY = '/var/lib/mysql-files/clone_dir1';
Query OK, 0 rows affected (19.50 sec)
mysql> create database after_clone1;
ERROR 1044 (42000): Access denied for user 'clone_user'@'%' to database 'after_clone1'
mysql> exit
Bye
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.06 sec)
mysql> create database after_clone1;
Query OK, 1 row affected (0.29 sec)
mysql> exit
Bye
[root@es2 ~]# mysql -uclone_user -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CLONE LOCAL DATA DIRECTORY = '/var/lib/mysql-files/clone_dir2';
Query OK, 0 rows affected (16.99 sec)
mysql> exit
Bye
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone1 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)
mysql> create database after_clone2;
Query OK, 1 row affected (0.04 sec)
mysql> exit
Bye
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone1 |
| after_clone2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> exit
Bye
[root@es2 ~]# systemctl stop mysqld
[root@es2 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
"/etc/my.cnf" 36L, 1353C 已写入
[root@es2 ~]# cat /etc/my.cnf |grep -v ^#
[mysqld]
datadir=/var/lib/mysql-files/clone_dir1
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
[root@es2 ~]# systemctl start mysqld
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> show variables like 'datadir';
+---------------+----------------------------------+
| Variable_name | Value |
+---------------+----------------------------------+
| datadir | /var/lib/mysql-files/clone_dir1/ |
+---------------+----------------------------------+
1 row in set (0.01 sec)
mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;
+---------------+-----------------+
| BINLOG_FILE | BINLOG_POSITION |
+---------------+-----------------+
| binlog.000001 | 1741 |
+---------------+-----------------+
1 row in set (0.00 sec)
mysql> SELECT @@GLOBAL.GTID_EXECUTED;
+------------------------------------------+
| @@GLOBAL.GTID_EXECUTED |
+------------------------------------------+
| dbda28c9-c970-11e9-b268-0800275c8ec3:1-6 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es2 ~]# systemctl stop mysqld
[root@es2 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
#datadir=/var/lib/mysql
datadir=/var/lib/mysql-files/clone_dir1
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
"/etc/my.cnf" 36L, 1353C 已写入
[root@es2 ~]# systemctl start mysqld
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like 'datadir';
+---------------+----------------------------------+
| Variable_name | Value |
+---------------+----------------------------------+
| datadir | /var/lib/mysql-files/clone_dir2/ |
+---------------+----------------------------------+
1 row in set (0.01 sec)
mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;
+---------------+-----------------+
| BINLOG_FILE | BINLOG_POSITION |
+---------------+-----------------+
| binlog.000001 | 1950 |
+---------------+-----------------+
1 row in set (0.00 sec)
mysql> SELECT @@GLOBAL.GTID_EXECUTED;
+------------------------------------------+
| @@GLOBAL.GTID_EXECUTED |
+------------------------------------------+
| dbda28c9-c970-11e9-b268-0800275c8ec3:1-7 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es2 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
#datadir=/var/lib/mysql
datadir=/var/lib/mysql-files/clone_dir2
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
"/etc/my.cnf" 36L, 1353C 已写入
[root@es2 ~]# systemctl start mysqld
[root@es2 ~]# systemctl restart mysqld
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.01 sec)
mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;
Empty set (0.00 sec)
mysql> SELECT @@GLOBAL.GTID_EXECUTED;
+------------------------------------------+
| @@GLOBAL.GTID_EXECUTED |
+------------------------------------------+
| dbda28c9-c970-11e9-b268-0800275c8ec3:1-8 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 16:53:44 2019 from es2
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> INSTALL PLUGIN clone SONAME 'mysql_clone.so';
Query OK, 0 rows affected (0.09 sec)
mysql> CREATE USER clone_user@'%' identified by 'iwSeuFagt0&31';
Query OK, 0 rows affected (0.32 sec)
mysql> GRANT CLONE_ADMIN on *.* to clone_user;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# mysql -uclone_user -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> clone instance from clone_user@'192.168.56.15':3306
-> identified by 'iwSeuFagt0&31';
ERROR 3869 (HY000): Clone system configuration: 192.168.56.15:3306 is not found in clone_valid_donor_list:
mysql> set clone_valid_donor_list ='192.168.56.15:3306';
ERROR 1229 (HY000): Variable 'clone_valid_donor_list' is a GLOBAL variable and should be set with SET GLOBAL
mysql> set global clone_valid_donor_list ='192.168.56.15:3306';
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
mysql> exit
Bye
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set global clone_valid_donor_list ='192.168.56.15:3306';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# mysql -uclone_user -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> clone instance from clone_user@'192.168.56.15':3306
-> identified by 'iwSeuFagt0&31';
Query OK, 0 rows affected (5.19 sec)
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR:
Can't connect to the server
mysql> show databases;
No connection. Trying to reconnect...
Connection id: 8
Current database: *** NONE ***
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone1 |
| after_clone2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM performance_schema.clone_status;
+---------------+-----------------+
| BINLOG_FILE | BINLOG_POSITION |
+---------------+-----------------+
| binlog.000002 | 195 |
+---------------+-----------------+
1 row in set (0.01 sec)
mysql> SELECT @@GLOBAL.GTID_EXECUTED;
+------------------------------------------+
| @@GLOBAL.GTID_EXECUTED |
+------------------------------------------+
| dbda28c9-c970-11e9-b268-0800275c8ec3:1-8 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> CHANGE MASTER TO MASTER_HOST = '192.168.56.15', MASTER_PORT = 3306,MASTER_AUTO_POSITION = 1;
Query OK, 0 rows affected (0.13 sec)
mysql> START SLAVE USER = 'repl_user' PASSWORD = 'iwSeuFagt0&31' ;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.56.15
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_user@192.168.56.15:3306' - retry-time: 60 retries: 1 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:23:26
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# exit
登出
Connection to es3 closed.
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter USER repl_user@'%' identified WITH mysql_native_password by 'iwSeuFagt0&31' ;
Query OK, 0 rows affected (0.28 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 17:11:22 2019 from es2
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.56.15
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_user@192.168.56.15:3306' - retry-time: 60 retries: 3 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:25:26
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.56.15
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_user@192.168.56.15:3306' - retry-time: 60 retries: 3 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:25:26
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> stop salve ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'salve' at line 1
mysql> stop slave ;
Query OK, 0 rows affected (0.28 sec)
mysql> start slave;
Query OK, 0 rows affected (0.03 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.56.15
Master_User:
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated.
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:26:07
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> stop slave;
Query OK, 0 rows affected (0.05 sec)
mysql> START SLAVE USER = 'repl_user' PASSWORD = 'iwSeuFagt0&31' ;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.56.15
Master_User:
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:26:44
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# exit
登出
Connection to es3 closed.
[root@es2 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
#datadir=/var/lib/mysql-files/clone_dir2
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
"/etc/my.cnf" 38L, 1366C 已写入
[root@es2 ~]# systemctl restart mysqld
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 17:25:38 2019 from es2
[root@es3 ~]# vim /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
gtid-mode = ON
enforce-gtid-consistency = ON
log-slave-updates = ON
"/etc/my.cnf" 37L, 1325C 已写入
[root@es3 ~]# systemctl restart mysqld
[root@es3 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.56.15
Master_User: test
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: es3-relay-bin.000002
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 124
Relay_Log_Space: 155
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master 'test@192.168.56.15:3306' - retry-time: 60 retries: 1 message: Access denied for user 'test'@'es3' (using password: NO)
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp: 190828 17:28:11
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-8
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> stop slave;
Query OK, 0 rows affected (0.28 sec)
mysql> START SLAVE USER = 'repl_user' PASSWORD = 'iwSeuFagt0&31' ;
Query OK, 0 rows affected, 1 warning (0.05 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.56.15
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: binlog.000003
Read_Master_Log_Pos: 195
Relay_Log_File: es3-relay-bin.000004
Relay_Log_Pos: 403
Relay_Master_Log_File: binlog.000003
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 195
Relay_Log_Space: 1271
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: dbda28c9-c970-11e9-b268-0800275c8ec3
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:9-10
Executed_Gtid_Set: dbda28c9-c970-11e9-b268-0800275c8ec3:1-10
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone1 |
| after_clone2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> exit
Bye
[root@es3 ~]# exit
登出
Connection to es3 closed.
[root@es2 ~]# mysql -p'iwSeuFagt0&31'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone1 |
| after_clone2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> use after_clone2
Database changed
mysql> create table t_clone(id int not null auto_increment primary key ,name varchar(255));
Query OK, 0 rows affected (0.36 sec)
mysql> insert into t_clone(name) values('c'),('l'),('o'),('n'),('e');
Query OK, 5 rows affected (0.29 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from after_clone2.t_clone;
+----+------+
| id | name |
+----+------+
| 1 | c |
| 2 | l |
| 3 | o |
| 4 | n |
| 5 | e |
+----+------+
5 rows in set (0.00 sec)
mysql> drop database after_clone1;
Query OK, 0 rows affected (0.31 sec)
mysql> exit
Bye
[root@es2 ~]# ssh es3
Last login: Wed Aug 28 17:27:47 2019 from es2
[root@es3 ~]# mysql -p'iwSeuFagt0&31';
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| after_clone2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)
mysql> select * from after_clone2.t_clone;
+----+------+
| id | name |
+----+------+
| 1 | c |
| 2 | l |
| 3 | o |
| 4 | n |
| 5 | e |
+----+------+
5 rows in set (0.00 sec)
mysql> exit
Bye亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
