---
title: 初始化MySQL数据库
description: "初始化MySQL数据库，请参见《MySQL 安装指南(https://www.hikunpeng.com/document/detail/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengmysql8017_03_0001.html)》。"
url: https://www.hikunpeng.com/document/detail/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengdbsmysqlrouter_03_0012.html
sourcePath: /source/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengdbsmysqlrouter_03_0012.html
indexId: 2ede7e0ccc375274f11c3f17fc5cf82fc1d2a1d8ed591c89d3911769459609bd78
---
# 初始化MySQL数据库

初始化MySQL数据库，请参见《MySQL 安装指南(https://www.hikunpeng.com/document/detail/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengmysql8017_03_0001.html)》。


**表1 数据库初始化配置参数**

| 参数 | 参数含义 | master（主库） | slave1（从库） | slave2（从库） |
| --- | --- | --- | --- | --- |
| port | 端口 | 3306 | 3307 | 3308 |
| datadir | 数据路径 | /data/mysql/datam | /data/mysql/datas | /data/mysql/datas2 |
| log\-error | 日志路径 | /data/mysql/log/mysqlm.log | /data/mysql/log/mysqls.log | /data/mysql/log/mysqls2.log |
| pid\-file | pid文件路径 | /data/mysql/run/mysqldm.pid | /data/mysql/run/mysqlds.pid | /data/mysql/run/mysqlds2.pid |
| socket | socket路径 | /data/mysql/run/mysqlm.sock | /data/mysql/run/mysqls.sock | /data/mysql/run/mysqls2.sock |
| mysqlx\_socket | mysqlx\_socket路径 | /data/mysql/run/mysqlxm.sock | /data/mysql/run/mysqlxs.sock | /data/mysql/run/mysqlxs2.sock |
| mysqlx\_port | mysqlx\_port端口 | 33060 | 33070 | 33080 |


1. 主库配置。
  1 2 mkdir -p /data/mysql/datam vim /etc/my.cnf-master-mgr

  编辑内容为：

```
[mysqld_safe]
log-error=
/data/mysql/log/mysqlm.log
pid-file=
/data/mysql/run/mysqldm.pid
[client]
socket=
/data/mysql/run/mysqlm.soc
k
default-character-set=utf8
[mysqld]
skip-name-resolve
basedir=/usr/local/mysql
socket=
/data/mysql/run/mysqlm.sock
mysqlx_socket=
/data/mysql/run/mysqlxm.sock
tmpdir=/data/mysql/tmp
datadir=
/data/mysql/datam
default_authentication_plugin=mysql_native_password
mysqlx_port=
33060
port=
3306
user=root
report_host=127.0.0.1
#innodb_page_size=4k
max_connections=2000
back_log=4000
performance_schema=OFF
max_prepared_stmt_count=128000
#transaction_isolation=READ-COMMITTED
#file
innodb_file_per_table
innodb_log_file_size=2048M
innodb_log_files_in_group=32
innodb_open_files=10000
table_open_cache_instances=64
#buffers
innodb_buffer_pool_size=44G
innodb_buffer_pool_instances=16
innodb_log_buffer_size=2048M
#tune
sync_binlog=1
innodb_flush_log_at_trx_commit=1
innodb_use_native_aio=1
innodb_spin_wait_delay=180
innodb_sync_spin_loops=25
innodb_flush_method=O_DIRECT
innodb_io_capacity=30000
innodb_io_capacity_max=40000
innodb_lru_scan_depth=9000
innodb_page_cleaners=16
#innodb_spin_wait_pause_multiplier=25
#perf special
innodb_flush_neighbors=0
innodb_write_io_threads=24
innodb_read_io_threads=16
innodb_purge_threads=32
sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL_TABLES
```


2. 按“Esc”键，输入:wq!，按“Enter”保存并退出编辑。
3. 在从库分别完成“/data/mysql/datas”和“/data/mysql/datas2”两个目录的创建，“/etc/my.cnf-slave-mgr”和“/etc/my.cnf-slave-2-mgr”文件内容的编辑。文件内的相关路径根据实际情况修改。