MySQL资料收集 - xingzhihe/hello-world GitHub Wiki

mysqld_safe --defaults-file=/data/mysql/gs/my.cnf &

mysqladmin -uroot -h127.0.0.1 -P3307 -p shutdown

cd /opt/software/mysql3307
mkdir data
mkdir conf

vi conf/mysqld.cnf

[mysqld]
log_bin=mysql-bin
server_id=1393307
binlog_format=ROW
general_log=ON


# InnoDB settings
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit  = 2
innodb_log_buffer_size = 64M
innodb_buffer_pool_size = 4G
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_log_file_size = 512M

docker run --name mysql-node3307 \
  -p 3307:3306 \
  -v /opt/software/mysql3307/data:/var/lib/mysql \
  -v /opt/software/mysql3307/conf/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -d mysql:5.7