当前位置： 首页 > news >正文

做个公司网站一般需要多少钱,seo网站排名优化方案,小程序appid在哪里找,杭州网络公司网站以下是基于脚本实现MySQL一键安装与配置的详细方案#xff0c;涵盖Linux主流系统#xff08;CentOS/Ubuntu#xff09;及Windows环境#xff0c;结合自动化部署与高可用性扩展#xff0c;旨在提升运维效率#xff1a; 一、Linux系统#xff08;CentOS 7.x#xff09;一…以下是基于脚本实现MySQL一键安装与配置的详细方案涵盖Linux主流系统CentOS/Ubuntu及Windows环境结合自动化部署与高可用性扩展旨在提升运维效率 一、Linux系统CentOS 7.x一键安装脚本方案

1. 基于YUM源的自动化安装MySQL 5.⁷⁄₈.0 #!/bin/bash

   变量定义

   VERSION8.0 # 可选5.7或8.0 ROOT_PASSWORDStrongPass123 BASE_DIR/usr/local/mysql# 环境准备 yum install -y wget net-tools wget https://dev.mysql.com/get/mysql \( {VERSION}-community-release-el7-11.noarch.rpm yum install -y mysql \) {VERSION}-community-release-el7-11.noarch.rpm yum install -y mysql-community-server# 初始化服务 systemctl start mysqld systemctl enable mysqld# 获取临时密码并重置 TEMP_PASSWORD \( (grep temporary password /var/log/mysqld.log | awk {print \) NF}) mysql -uroot -p \( {TEMP_PASSWORD} --connect-expired-password -e ALTER USER rootlocalhost IDENTIFIED BY \) {ROOT_PASSWORD};# 配置远程访问与字符集 mysql -uroot -p \( {ROOT_PASSWORD} -e GRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY \) {ROOT_PASSWORD} WITH GRANT OPTION; mysql -uroot -p $ {ROOT_PASSWORD} -e FLUSH PRIVILEGES; echo [mysqld] character-set-serverutf8mb4 collation-serverutf8mb4_unicode_ci default-authentication-pluginmysql_native_password /etc/my.cnfsystemctl restart mysqld 2. 二进制包手动安装MySQL 8.0 #!/bin/bash

   变量定义

   VERSION8.0.34 ROOT_PASSWORDSecurePass456 DATA_DIR/data/mysql# 环境准备 groupadd mysql useradd -r -g mysql mysql mkdir -p \( DATA_DIR/{data,logs,conf} wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql- \) {VERSION}-linux-glibc2.12-x86_64.tar.gz tar -zxvf mysql- \( {VERSION}-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ ln -s /usr/local/mysql- \) {VERSION}-linux-glibc2.12-x86_64 /usr/local/mysql# 初始化数据库 /usr/local/mysql/bin/mysqld –initialize –usermysql –basedir/usr/local/mysql –datadir \( DATA_DIR/data mv /var/log/mysqld.log \) DATA_DIR/logs/ chmod 755 \( DATA_DIR -R chown -R mysql:mysql \) DATA_DIR /usr/local/mysql# 配置环境变量 echo export PATH \( PATH:/usr/local/mysql/bin /etc/profile source /etc/profile# 创建服务文件 cat EOF /etc/systemd/system/mysqld.service [Unit] DescriptionMySQL Server Aftersyslog.target network.target[Service] Typeforking ExecStart/usr/local/mysql/bin/mysqld --basedir/usr/local/mysql --datadir \) DATA_DIR/data –pid-file \( DATA_DIR/mysqld.pid ExecReload/bin/kill -HUP \) MAINPID ExecStop/usr/local/mysql/bin/mysqladmin shutdown -u root -p \( {ROOT_PASSWORD} PrivateTmptrue[Install] WantedBymulti-user.target EOF# 启动服务并配置 systemctl daemon-reload systemctl start mysqld systemctl enable mysqld# 获取临时密码并重置 TEMP_PASSWORD \) (grep temporary password \( DATA_DIR/logs/mysqld.log | awk {print \) NF}) mysql -uroot -p \( {TEMP_PASSWORD} --connect-expired-password -e ALTER USER rootlocalhost IDENTIFIED BY \) {ROOT_PASSWORD}; mysql -uroot -p \( {ROOT_PASSWORD} -e GRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY \) {ROOT_PASSWORD} WITH GRANT OPTION; mysql -uroot -p $ {ROOT_PASSWORD} -e FLUSH PRIVILEGES; 二、Windows系统一键安装脚本方案

2. 批处理脚本MySQL 8.0 echo off setlocal enabledelayedexpansionset INSTALL_DIRC:\mysql-8.0.34-winx64 set DATA_DIRC:\mysql_data set ROOT_PASSWORDAdmin123:: 下载并解压 bitsadmin.exe /transfer MySQLDownload /download /priority normal https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-%VERSION%-winx64.zip %TEMP%\mysql.zip powershell Expand-Archive -Path %TEMP%\mysql.zip -DestinationPath %INSTALL_DIR%:: 创建数据目录 mkdir %DATA_DIR%:: 初始化配置 echo [mysqld] %INSTALL_DIR%\my.ini echo basedir %INSTALL_DIR% %INSTALL_DIR%\my.ini echo datadir %DATA_DIR% %INSTALL_DIR%\my.ini echo port 3306 %INSTALL_DIR%\my.ini echo character-set-serverutf8mb4 %INSTALL_DIR%\my.ini echo default-authentication-pluginmysql_native_password %INSTALL_DIR%\my.ini:: 初始化数据库 %INSTALL_DIR%\bin\mysqld –initialize –console –datadir%DATA_DIR% –userroot set /p TEMP_PASSWORD请输入临时密码::: 修改密码并配置远程访问 %INSTALL_DIR%\bin\mysql -u root -p%TEMP_PASSWORD% –connect-expired-password -e ALTER USER rootlocalhost IDENTIFIED BY %ROOT_PASSWORD%; %INSTALL_DIR%\bin\mysql -u root -p%ROOT_PASSWORD% -e GRANT ALL PRIVILEGES ON . TO root% IDENTIFIED BY %ROOT_PASSWORD% WITH GRANT OPTION; %INSTALL_DIR%\bin\mysql -u root -p%ROOT_PASSWORD% -e FLUSH PRIVILEGES;:: 安装服务 %INSTALL_DIR%\bin\mysqld –install MySQL80 net start MySQL80 三、自动化部署高级方案

3. Ansible批量部署支持多节点 #(ansible-playbook)

• name: Deploy MySQL Clusterhosts: mysql_nodesbecome: yestasks:- name: Install MySQL Repositoryyum:name: https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpmstate: present- name: Install MySQL Serveryum:name: mysql-community-serverstate: present- name: Start MySQL Serviceservice:name: mysqldstate: startedenabled: yes- name: Get Initial Passwordshell: grep temporary password /var/log/mysqld.log | awk {print $ NF}register: temp_password- name: Set Root Passwordmysql_user:login_user: rootlogin_password: {{ temp_password.stdout }}check_implicit_admin: yesname: rootpassword: StrongPass123host_all: yes- name: Configure Remote Accessmysql_query:login_user: rootlogin_password: StrongPass123query: GRANT ALL PRIVILEGES ON . TO root% IDENTIFIED BY StrongPass123; FLUSH PRIVILEGES; 2. 高可用性扩展MySQL Group Replication

  主节点配置脚本片段

  mysql -uroot -p -e CREATE USER repl% IDENTIFIED BY ReplicaPass456; mysql -uroot -p -e GRANT REPLICATION SLAVE ON . TO repl%; mysql -uroot -p -e CHANGE MASTER TO MASTER_HOSTsecondary_ip, MASTER_USERrepl, MASTER_PASSWORDReplicaPass456; mysql -uroot -p -e INSTALL PLUGIN group_replication SONAME group_replication.so; mysql -uroot -p -e SET GLOBAL group_replication_group_nameuuid; mysql -uroot -p -e SET GLOBAL group_replication_start_on_BOOTON; mysql -uroot -p -e START GROUP_REPLICATION; 四、关键配置优化建议 性能调优 调整innodb_buffer_pool_size为物理内存的70%启用查询缓存query_cache_type1MySQL 8.0后默认禁用日志优化slow_query_log1  long_query_time2 安全加固 禁用匿名账户DROP USER localhost;删除测试数据库DROP DATABASE test;配置防火墙规则firewall-cmd –add-port3306/tcp –permanent 监控集成 安装Percona Monitoring Toolkit配置Prometheus Grafana监控面板 五、脚本执行流程图 开始 ├─ 检查系统环境依赖、防火墙、SELinux ├─ 下载安装包/配置源 ├─ 执行安装命令 ├─ 获取临时密码并重置 ├─ 配置字符集与远程访问 ├─ 初始化数据库目录权限 ├─ 启动服务并验证状态 └─ 输出最终配置报告 六、常见问题解决方案 端口冲突修改my.cnf中的port参数权限不足确保mysql用户对数据目录有读写权限SSL错误添加skip-grant-tables临时启动后修复权限服务启动失败检查mysqld.log日志定位具体错误 通过上述脚本方案可实现MySQL的快速部署与标准化配置结合Ansible等工具可进一步扩展为集群化部署显著提升运维效率。建议根据实际业务需求选择脚本模板并定制化调整参数。