50 lines
1.2 KiB
Markdown
50 lines
1.2 KiB
Markdown
生产环境用于nacos xxl-job的专用数据库
|
|
|
|
|
|
|
|
# prod环境下 部署 附属工具类服务使用的mysql
|
|
|
|
env $(cat ./env_prod | xargs) envsubst < ./docker-compose.yml | docker stack deploy --compose-file - prod_tool_mysql
|
|
|
|
[mysqladmin]
|
|
user=
|
|
|
|
[mysqld]
|
|
skip_name_resolve
|
|
explicit_defaults_for_timestamp
|
|
basedir=/opt/bitnami/mysql
|
|
port=3306
|
|
tmpdir=/opt/bitnami/mysql/tmp
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
pid_file=/opt/bitnami/mysql/tmp/mysqld.pid
|
|
max_allowed_packet=16M
|
|
bind_address=0.0.0.0
|
|
log_error=/opt/bitnami/mysql/logs/mysqld.log
|
|
slow_query_log=0
|
|
slow_query_log_file=/opt/bitnami/mysql/logs/mysqld.log
|
|
long_query_time=10
|
|
character_set_server=utf8mb4
|
|
collation_server=utf8mb4_unicode_ci
|
|
plugin_dir=/opt/bitnami/mysql/lib/plugin
|
|
|
|
[client]
|
|
port=3306
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
default_character_set=utf8mb4
|
|
plugin_dir=/opt/bitnami/mysql/lib/plugin
|
|
|
|
[manager]
|
|
port=3306
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
pid_file=/opt/bitnami/mysql/tmp/mysqld.pid
|
|
|
|
|
|
---- 实际版本
|
|
|
|
[mysqld]
|
|
max_connections=500
|
|
max_allowed_packet=64M
|
|
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
|
|
log-bin=mysql-bin # 开启 binlog
|
|
binlog-format=ROW # 选择 ROW 模式
|
|
server_id=209 |