3
非常详细的MySQL数据库运维手册
50墨值下载
中
中
亦
亦
科
科
技
技
M
M
y
y
S
S
Q
Q
L
L
数
数
据
据
库
库
运
运
维
维
手
手
册
册
北京中亦安图科技股份有限公司
2018 年 10 月 17 日
目录
1. 系统环境配置·············································································· 8
1.1 Linux 环境配置 ································································· 8
1.1.1
关闭 SELINUX
·············································································· 8
1.1.2
建立组和用户
············································································· 8
1.1.3
时间同步
····················································································· 8
1.1.4
网络配置
····················································································· 9
1.1.5
文件系统配置
··········································································· 10
1.1.6
配置 LIMITS
················································································ 10
1.1.7
禁用防火墙
··············································································· 10
1.1.8
系统内核参数调整
··································································· 10
1.1.9
加大磁盘队列深度
··································································· 11
1.1.10
配置 SHELL
················································································ 11
1.1.11
重启操作系统
··········································································· 11
2. 软件安装 ·················································································· 12
2.1 介质下载 ··································································· 12
2.1.1
源码包下载
··············································································· 12
2.2 MySQL_5.0/5.1 源码安装配置 ·············································· 13
2.2.1
目录配置
··················································································· 13
2.2.2
安装与卸载依赖包
·········································································· 13
2.2.3
编译安装
··················································································· 13
2.2.4
配置参数文件
·················································································· 14
2.2.5
初始化数据库
··········································································· 16
2.2.6
配置服务
··················································································· 16
2.2.7
配置 ROOT 密码
········································································· 17
2.2.8
安全加固
··················································································· 17
2.2.9
重启数据库服务
·············································································· 17
2.3 MySQL_5.5 源码安装配置 ···················································· 17
2.3.1
目录配置
··················································································· 17
2.3.2
安装与卸载依赖包
·········································································· 17
2.3.3
编译安装
··················································································· 18
2.3.4
配置参数文件
··········································································· 18
2.3.5
初始化数据库
··········································································· 20
2.3.6
配置服务
··················································································· 20
2.3.7
配置 ROOT 密码
········································································· 21
2.3.8
安全加固
··················································································· 21
2.3.9
重启数据库服务
·············································································· 21
2.4 MySQL_5.6 源码安装配置 ···················································· 21
2.4.1
目录配置
··················································································· 21
2.4.2
安装与卸载依赖包
·········································································· 21
2.4.3
编译安装
··················································································· 21
2.4.4
配置参数文件
··········································································· 22
of 136
50墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论