# 安装与部署
# 1. 准备环境
# 安装依赖包
sudo yum install -y epel-release
sudo yum install -y wget curl
# 2. 添加MariaDB Community仓库
# 下载仓库配置文件
sudo wget -O /etc/yum.repos.d/MariaDB.repo https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
# 执行仓库配置
sudo chmod +x /etc/yum.repos.d/MariaDB.repo
sudo /etc/yum.repos.d/MariaDB.repo –mariadb-server-version=10.6
# 3. 安装MariaDB Community Server
sudo yum install -y MariaDB-server MariaDB-client
# 4. 启动服务
sudo systemctl start mariadb
sudo systemctl enable mariadb
# 5. 初始化配置
sudo mysql_secure_installation

# 配置与优化
# 1. 基本配置
# 编辑配置文件
sudo vi /etc/my.cnf.d/server.cnf
# 添加基本配置
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
bind-address=0.0.0.0
# 2. 性能优化
# 添加性能优化配置
[mysqld]
innodb_buffer_pool_size=4G
innodb_log_file_size=512M
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
# 3. 安全配置
# 添加安全配置
[mysqld]
validate_password_policy=MEDIUM
# 4. 重启服务
sudo systemctl restart mariadb

# 监控与管理
# 1. 安装监控工具
# 安装Prometheus和Grafana
wget https://github.com/prometheus/prometheus/releases/download/v2.30.3/prometheus-2.30.3.linux-amd64.tar.gz
tar xvfz prometheus-2.30.3.linux-amd64.tar.gz
wget https://dl.grafana.com/oss/release/grafana_8.3.3_amd64.deb
dpkg -i grafana_8.3.3_amd64.deb
# 2. 配置监控
# 安装mysqld_exporter
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
tar xvfz mysqld_exporter-0.13.0.linux-amd64.tar.gz
# 创建监控用户
mysql -u root -p -e “CREATE USER ‘exporter’@’fgedu.localhost’ IDENTIFIED BY ‘exporter-password’ WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO ‘exporter’@’fgedu.localhost’;
”
# 启动mysqld_exporter
./mysqld_exporter –config.my-cnf=.my.cnf
# 3. 日常管理
# 备份数据库
mysqldump -u root -p –all-databases > backup.sql
# 恢复数据库
mysql -u root -p < backup.sql
# 查看数据库状态
mysql -u root -p -e “SHOW GLOBAL STATUS;
”