wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
# 停止服务并卸载
sudo systemctl stop mysqld
sudo yum remove mysql-community-server mysql-community-client
sudo rm -rf /var/lib/mysql /etc/my.cnf /var/log/mysqld.log
# 清理残留依赖
sudo yum autoremove
# 重新安装
sudo yum install mysql-community-server mysql-community-client
sudo systemctl start mysqld
# 获取临时 root 密码
sudo grep 'temporary password' /var/log/mysqld.log
mysql -h localhost -u root -p
mysql>alter user root@localhost identified by '****';
mysql>uninstall plugin validate_password;
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
| wget https://ftpmirror.your.org/pub/percona/percona/yum/release/7/os/x86_64/percona-xtrabackup-24-2.4.29-1.el7.x86_64.rpm
yum install percona-xtrabackup-24-2.4.29-1.el7.x86_64.rpm
wget https://docs-tencentdb-1256569818.cos.ap-guangzhou.myqcloud.com/qpress-11-linux-x64.tar
tar xvf qpress-11-linux-x64.tar
mv qpress /usr/bin
登陆 10.0.18.90
sudo su -
scp -P2222 /sour_backup/backupSet/mysql/10.0.20.202/2025-03-05_03-00-02/2025-03-05_03-00-02/stream_backup_2025-03-05_03-00-02 10.0.25.14:/data/mysql/recovery
xbstream --verbose --parallel=4 --extract < /data/mysql/recovery/stream_backup_2025-03-05_03-00-02 --directory /data/mysql/recovery/ > /data/recovery/destream.log
# xtrabackup --parallel=4 --decompress --remove-original --target-dir=/data/mysql/recovery/ > /data/recovery/decompress.log
xtrabackup --decompress --parallel=4 --decrypt=AES256 --encrypt-key="lk92tBpEfn0nn88mBDt0%y8fPO0y%wuX" --target-dir=/data/mysql/recovery/ --remove-original > /data/recovery/decompress.log
xtrabackup --use-memory=1024MB --prepare --target-dir=/data/mysql/recovery/ > /data/recovery/prepare_redo_only.log
rm -rf /data/mysql/mysqldata/*
mkdir -p /data/mysql/mysqldata/{binlog,innodb_log,innodb_ts,innodb_undo,log,mydata,tmpdir,sock,relaylog}
# xtrabackup --defaults-file=/etc/my.cnf --move-back --target-dir=/data/mysql/recovery/
xtrabackup --defaults-file=/etc/my.cnf --copy-back --target-dir=/data/mysql/recovery/
touch /data/mysql/mysqldata/log/error.log
chown -R mysql.mysql /data
chmod -R 775 /data
systemctl start mysql
|