MySQL单机多实例部署
# cat /etc/my.cnf#password = 123456
#prompt = [\\u@\\h][\\d]>\\_
socket = /tmp/mysql5.7.18.sock
#password = 123456
#prompt = [\\u@\\h][\\d]>\\_
socket = /tmp/mysql5.7.18.sock
mysqld = /usr/local/mysql5.7.18/bin/mysqld_safe
mysqladmin =/usr/local/mysql5.7.18/bin/mysqladmin
log =/data/mydata3307/mysqld_multi.log
# 每个实例都设置统一管理密码，方便使用服务脚本停止实例
user = root
pass = 123456
#初始化需要段配置，否则初始化的时候加载不到及段中关于设置独立undo表空间及共享表空间大小
innodb_buffer_pool_size = 4096M
#innodb_buffer_pool_size = 16384M
innodb_undo_log_truncate=ON
innodb_undo_tablespaces = 2
innodb_data_file_path=ibdata1:1G:autoextend
innodb_buffer_pool_size = 4096M
#innodb_buffer_pool_size = 16384M
port = 3307
socket = /data/mydata3307/mysql5.7.18.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 10M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 16M
thread_cache_size = 4
max_connections=1500
character_set_server=utf8
group_concat_max_len=65535
log_bin_trust_function_creators=1
log_queries_not_using_indexes = ON
log_throttle_queries_not_using_indexes = 2
interactive_timeout = 600
wait_timeout = 600
connect_timeout = 10
expire_logs_days = 30
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=mysql
replicate-ignore-db=sys
log_timestamps=SYSTEM
innodb_print_all_deadlocks=1
basedir=/usr/local/mysql5.7.18
datadir=/data/mydata3307
innodb_undo_log_truncate=ON
innodb_undo_tablespaces = 2
innodb_data_file_path=ibdata1:1G:autoextend
core_file
sync_binlog = 0
innodb_flush_log_at_trx_commit = 2
##Master
#log-bin=mysql-bin
log-bin=/data/mydata3307/mysql-bin
#binlog_format=mixed
binlog_format=row
server-id=3307
lower_case_table_names = 1
skip-name-resolve
innodb_file_per_table=1
long_query_time=2
slow_query_log=1
slow_query_log_file=/data/mydata3307/slow-query.log
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
#slave
slave-parallel-type=LOGICAL_CLOCK
#slave-parallel-workers=16
slave-parallel-workers=4
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON
slave_preserve_commit_order=1
log-slave-updates=true
slave_skip_errors='1032,1062'
relay_log=/data/mydata3307/localhost-relay-bin
####gtid######
gtid_mode = ON
enforce_gtid_consistency = ON
master_verify_checksum = 1
slave_sql_verify_checksum = 1
innodb_buffer_pool_size = 2048M
#innodb_buffer_pool_size = 16384M
port = 3308
socket = /data/mydata3308/mysql5.7.18.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 10M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 16M
thread_cache_size = 4
max_connections=1500
character_set_server=utf8
group_concat_max_len=65535
log_bin_trust_function_creators=1
log_queries_not_using_indexes = ON
log_throttle_queries_not_using_indexes = 2
interactive_timeout = 600
wait_timeout = 600
connect_timeout = 10
expire_logs_days = 30
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=mysql
replicate-ignore-db=sys
log_timestamps=SYSTEM
innodb_print_all_deadlocks=1
basedir=/usr/local/mysql5.7.18
datadir=/data/mydata3308
innodb_undo_log_truncate=ON
innodb_undo_tablespaces = 2
innodb_data_file_path=ibdata1:1G:autoextend
core_file
sync_binlog = 0
innodb_flush_log_at_trx_commit = 2
##Master
#log-bin=mysql-bin
log-bin=/data/mydata3308/mysql-bin
#binlog_format=mixed
binlog_format=row
server-id=3308
lower_case_table_names = 1
skip-name-resolve
innodb_file_per_table=1
long_query_time=2
slow_query_log=1
slow_query_log_file=/data/mydata3308/slow-query.log
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
#slave
slave-parallel-type=LOGICAL_CLOCK
#slave-parallel-workers=16
slave-parallel-workers=4
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON
slave_preserve_commit_order=1
log-slave-updates=true
slave_skip_errors='1032,1062'
relay_log=/data/mydata3308/localhost-relay-bin
####gtid######
gtid_mode = ON
enforce_gtid_consistency = ON
master_verify_checksum = 1
slave_sql_verify_checksum = 1
页:
[1]