# 启动Percona服务
# systemctl start mysql

# 设置Percona服务开机自启
# systemctl enable mysql

# 验证Percona服务状态
# systemctl status mysql
● mysql.service – Percona Server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2026-03-31 10:00:00 CST; 1min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 12345 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 12346 (mysqld)
Status: “Taking your SQL requests now…”
Tasks: 38 (limit: 4915)
Memory: 370.0M
CGroup: /system.slice/mysql.service
└─12346 /usr/sbin/mysqld

Mar 31 10:00:00 fgedudb01 systemd[1]: Starting Percona Server…
Mar 31 10:00:00 fgedudb01 mysqld_pre_systemd[12345]: MYSQLD_PARENT_PID: 12345
Mar 31 10:00:00 fgedudb01 systemd[1]: Started Percona Server.

# 运行安全配置脚本
# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root: AbCdEfGhIjKlMnOp

The existing password for the user account root has expired. Please set a new password.

New password:
Re-enter new password:
The password strength is 100.
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y

By default, a MySQL installation has an anonymous user, allowing anyone
To log into MySQL without having to have a user account created for
Them. This is intended only for testing, and to make the installation
Go a bit smoother. You should remove them before moving into a
Production environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
Success.

Normally, root should only be allowed to connect from ‘localhost’. This
Ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y
Success.

By default, MySQL comes with a database named ‘test’ that anyone can
Access. This is also intended only for testing, and should be removed
Before moving into a production environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
– Dropping test database…
Success.
– Removing privileges on test database…
Success.

Reloading the privilege tables will ensure that all changes made so far
Will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y
Success.

All done! If you’ve completed all of the above steps, your MySQL
Installation should now be secure.

Thanks for using MySQL!

# 添加以下配置
[mysqld]
datadir=/data/percona
socket=/var/lib/mysql/mysql.sock
bind-address=0.0.0.0
port=3306
max_connections=1000
innodb_buffer_pool_size=4G
innodb_log_file_size=512M
innodb_file_per_table=1
skip-name-resolve
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

# 重启Percona服务
# systemctl restart mysql

# 验证配置
# mysql -u root -p -e “SHOW VARIABLES LIKE ‘datadir’;”
Enter password:
+—————+—————-+| Variable_name | Value |+—————+—————-+| datadir | /data/percona/ |+—————+—————-+

# 创建数据库
mysql> CREATE DATABASE fgedudb;

# 创建用户
mysql> CREATE USER ‘fgedu’@’%’ IDENTIFIED BY ‘fgedu123’;

# 授权
mysql> GRANT ALL PRIVILEGES ON fgedudb.* TO ‘fgedu’@’%’;

# 刷新权限
mysql> FLUSH PRIVILEGES;

# 连接到测试数据库
mysql> USE fgedudb;

# 创建测试表
mysql> CREATE TABLE fgedu_employees (
-> id INT PRIMARY KEY AUTO_INCREMENT,
-> name VARCHAR(100),
-> salary DECIMAL(10,2)
-> );

# 插入测试数据
mysql> INSERT INTO fgedu_employees (name, salary) VALUES (‘张三’, 5000.00);
mysql> INSERT INTO fgedu_employees (name, salary) VALUES (‘李四’, 6000.00);
mysql> INSERT INTO fgedu_employees (name, salary) VALUES (‘王五’, 7000.00);

# 查询测试数据
mysql> SELECT * FROM fgedu_employees;
+—-+——+——–+
| id | name | salary |
+—-+——+——–+
| 1 | 张三 | 5000.0 |
| 2 | 李四 | 6000.0 |
| 3 | 王五 | 7000.0 |
+—-+——+——–+

# 执行备份
# 以root用户执行
# mysqldump -u root -p fgedudb > /backup/percona/fgedudb_backup_20260331.sql

# 验证备份文件
# ls -la /backup/percona/
-rw-r–r– 1 root root 123456 Mar 31 10:20 fgedudb_backup_20260331.sql

#!/bin/bash

DATE=$(date +%Y%m%d)
BACKUP_DIR=”/backup/percona”

# 创建备份目录（如果不存在）
mkdir -p $BACKUP_DIR

# 执行备份
mysqldump -u root -p’your_password’ fgedudb > $BACKUP_DIR/fgedudb_backup_$DATE.sql

# 保留最近7天的备份
find $BACKUP_DIR -name “fgedudb_backup_*.sql” -mtime +7 -delete

# 给脚本添加执行权限
# chmod +x /root/backup_percona.sh

# 添加到crontab
# crontab -e

# 添加以下内容（每天凌晨2点执行备份）
0 2 * * * /root/backup_percona.sh

# 2. 停止Percona服务
# systemctl stop mysql

# 3. 升级Percona
# yum update -y percona-server-server percona-server-client

# 4. 启动Percona服务
# systemctl start mysql

# 5. 运行升级脚本
# mysql_upgrade -u root -p

# 6. 验证升级结果
# mysql -u root -p -e “SELECT VERSION();”
Enter password:
+—————+| VERSION() |+—————+| 8.0.36-28-log |+—————+

# 1. 在旧系统上创建备份
# mysqldump -u root -p –all-databases > /backup/percona/all_databases_backup.sql

# 2. 将备份文件复制到新系统
# scp /backup/percona/all_databases_backup.sql root@192.168.1.51:/backup/percona/

# 3. 在新系统上恢复备份
# mysql -u root -p < /backup/percona/all_databases_backup.sql # 4. 验证迁移结果 # mysql -u root -p -e "SELECT * FROM fgedudb.fgedu_employees;"