MySQL 8.0数据库安装及主从同步配置.docx

车金陆

云和恩墨

845

12页

55次

2023-11-30

5墨值下载

MySQL 8.0
数据库安装及主从同步配置
一、环境介绍
........................................................................................................2
二、操作系统配置
..................................................................................................2
1
、主机名配置
................................................................................................2
2
、主机
IP
解析配置
........................................................................................2
3
、关闭
SELinux............................................................................................2
4
、关闭防火墙
................................................................................................3
5
、检查时区
...................................................................................................3
6
、清理
MariaDB 
环境
....................................................................................3
7
、配置用户系统资源限制
................................................................................4
三、
MySQL
安装部署
.............................................................................................4
1
、创建用户和组
.............................................................................................4
2
、创建数据及日志目录
...................................................................................4
3
、上传软件包并解压
......................................................................................4
4
、配置环境变量
.............................................................................................5
5
、配置参数文件
.............................................................................................5
6
、初始化数据库
.............................................................................................7
7
、启动数据库
................................................................................................7
8
、登录数据库及配置
root
用户
........................................................................7
9
、配置服务方式启动脚本
................................................................................8
四、配置主从同步
..................................................................................................8
1
、创建主从同步用户
......................................................................................8
2
、配置主从同步关系
......................................................................................8
1
）对于新建空白数据库
.............................................................................8
2
）对于在运行的数据库
...........................................................................10
五、参数含义
......................................................................................................11