docker mysql源码分析_docker安装mysql8.0

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.

#

# This program is free software; you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation; version 2 of the License.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

#

# The MySQL Server configuration file.

#

# For explanations see

# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[client]

default-character-set=utf8

[mysqld]

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

datadir = /var/lib/mysql

default-time_zone = +8:00

secure-file-priv= NULL

# 允许最大连接数

max_connections=1000

# ================= ↓↓↓ mysql主从同步配置start ↓↓↓ =================

# 同一局域网内注意要唯一

server-id=223

# 开启二进制日志功能，以备slave作为其它slave的master时使用

log-bin=mysql-slave-bin

# Slave_SQL_Running 为NO 日志中报错1032 ，只需要在slave中配置该项

# slave-skip-errors = 1032

# ================= ↑↑↑ mysql主从同步配置end ↑↑↑ =================

default-storage-engine=INNODB

character-set-server=utf8

collation-server=utf8_general_ci

skip-name-resolve

[mysql]

default-character-set=utf8

[mysqld_safe]

log-error =/orisdom/mysql/error

# Custom config should go here

!includedir /etc/mysql/conf.d/