# 1. 配置内核参数
# vi /etc/sysctl.d/99-database.conf
kernel.shmmax = 34359738368
kernel.shmall = 8388608
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
vm.swappiness = 10
vm.nr_hugepages = 16384

# sysctl -p /etc/sysctl.d/99-database.conf

# 2. 配置用户资源限制
# vi /etc/security/limits.d/99-mysql.conf
mysql soft nofile 65535
mysql hard nofile 65535
mysql soft nproc 65535
mysql hard nproc 65535

# 3. 安装MySQL
# dnf install mysql-server -y

# 输出示例：
上次元数据过期检查：0:00:00 前，执行于 2026年04月04日 星期五 10时00分00秒。
依赖关系解决。
===================================================================================================
软件包 架构 版本 仓库 大小
===================================================================================================
安装:
mysql-server x86_64 8.0.26-1.ax8 ax8-appstream 12 M

事务概要
===================================================================================================
安装 1 软件包

总下载：12 M
下载软件包：
mysql-server-8.0.26-1.ax8.x86_64.rpm 10 MB/s | 12 MB 00:01
—————————————————————————————————
总计 10 MB/s | 12 MB 00:01
运行事务检查
事务检查成功。
运行事务测试
事务测试成功。
运行事务
准备中 : 1/1
运行脚本: mysql-server-8.0.26-1.ax8.x86_64 1/1
安装 : mysql-server-8.0.26-1.ax8.x86_64 1/1
运行脚本: mysql-server-8.0.26-1.ax8.x86_64 1/1
验证 : mysql-server-8.0.26-1.ax8.x86_64 1/1

已安装:
mysql-server-8.0.26-1.ax8.x86_64

完毕！

# 4. 配置MySQL
# vi /etc/my.cnf.d/mysql-server.cnf
[mysqld]
datadir = /data/mysql
socket = /var/lib/mysql/mysql.sock
port = 3306
innodb_buffer_pool_size = 32G
innodb_log_file_size = 1G
max_connections = 1000

# 5. 启动MySQL服务
# systemctl enable mysqld
# systemctl start mysqld

# 输出示例：
# systemctl status mysqld
● mysqld.service – MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2026-04-04 10:00:00 CST; 5s ago
Process: 12345 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Process: 12346 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
Main PID: 12347 (mysqld)
Status: “Server is operational”
Tasks: 38 (limit: 4915)
Memory: 32.5G
CGroup: /system.slice/mysqld.service
└─12347 /usr/libexec/mysqld –basedir=/usr

# 6. 配置防火墙
# firewall-cmd –permanent –add-service=mysql
# firewall-cmd –reload

# 1. 安装Nginx
# dnf install nginx -y

# 输出示例：
上次元数据过期检查：0:00:00 前，执行于 2026年04月04日 星期五 10时00分00秒。
依赖关系解决。
===================================================================================================
软件包 架构 版本 仓库 大小
===================================================================================================
安装:
nginx x86_64 1:1.14.1-9.ax8 ax8-appstream 570 k

事务概要
===================================================================================================
安装 1 软件包

总下载：570 k
下载软件包：
nginx-1.14.1-9.ax8.x86_64.rpm 1.0 MB/s | 570 kB 00:00
—————————————————————————————————
总计 1.0 MB/s | 570 kB 00:00
运行事务检查
事务检查成功。
运行事务测试
事务测试成功。
运行事务
准备中 : 1/1
运行脚本: nginx-1:1.14.1-9.ax8.x86_64 1/1
安装 : nginx-1:1.14.1-9.ax8.x86_64 1/1
运行脚本: nginx-1:1.14.1-9.ax8.x86_64 1/1
验证 : nginx-1:1.14.1-9.ax8.x86_64 1/1

已安装:
nginx-1:1.14.1-9.ax8.x86_64

完毕！

# 2. 配置Nginx
# vi /etc/nginx/nginx.conf

# 修改以下配置
worker_processes auto;
worker_rlimit_nofile 65535;

events {
worker_connections 65535;
}

http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;

server {
listen 80;
server_name localhost;

location / {
root /usr/share/nginx/html;
index index.html index.htm;
}
}
}

# 3. 启动Nginx服务
# systemctl enable nginx
# systemctl start nginx

# 输出示例：
# systemctl status nginx
● nginx.service – The nginx HTTP and reverse proxy server
Loaded: loaded (/usr/lib/systemd/system/nginx.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2026-04-04 10:00:00 CST; 5s ago
Process: 12345 ExecStartPre=/usr/bin/rm -f /run/nginx.pid (code=exited, status=0/SUCCESS)
Process: 12346 ExecStartPre=/usr/sbin/nginx -t (code=exited, status=0/SUCCESS)
Process: 12347 ExecStart=/usr/sbin/nginx (code=exited, status=0/SUCCESS)
Main PID: 12348 (nginx)
Tasks: 3 (limit: 4915)
Memory: 5.0M
CGroup: /system.slice/nginx.service
├─12348 nginx: master process /usr/sbin/nginx
├─12349 nginx: worker process
└─12350 nginx: worker process

# 4. 配置防火墙
# firewall-cmd –permanent –add-service=http
# firewall-cmd –permanent –add-service=https
# firewall-cmd –reload

# 查看系统性能
# top -c

# 输出示例：
top – 10:00:00 up 2 days, 10:00, 2 users, load average: 0.50, 0.45, 0.40
Tasks: 128 total, 1 running, 127 sleeping, 0 stopped, 0 zombie
%Cpu(s): 2.5 us, 1.2 sy, 0.0 ni, 96.2 id, 0.0 wa, 0.0 hi, 0.1 si, 0.0 st
MiB Mem : 65536.0 total, 60000.0 free, 2000.0 used, 3536.0 buff/cache
MiB Swap: 32768.0 total, 32768.0 free, 0.0 used. 63000.0 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12345 mysql 20 0 32.5g 8.0g 512.0m S 5.0 12.5 10:00.00 /usr/libexec/mysqld
12346 root 20 0 1500.0m 500.0m 100.0m S 2.0 0.8 5:00.00 nginx: worker process

# 查看系统日志
# journalctl -f
— Logs begin at Fri 2026-04-04 08:00:00 CST. —
Apr 04 10:00:00 fgedudb01 systemd[1]: Started MySQL 8.0 database server.
Apr 04 10:00:00 fgedudb01 systemd[1]: Started The nginx HTTP and reverse proxy server.

# 查看系统状态
# dnf history list
ID | 命令行 | 日期和时间 | 操作
—– | ————————————————- | ——————- | —–
3 | install nginx | 2026-04-04 10:00 | I
2 | install mysql-server | 2026-04-04 09:50 | I
1 | update | 2026-04-04 09:00 | U