mysql强制读主库命令_已经运行很久的mysql，搭建主从

1、(主库)修改/etc/my.cnf配置文件

innodb_strict_mode=on

#innodb 共享表空间设置

innodb_file_per_table = 1

innodb_data_home_dir = /var/lib/mysql

innodb_data_file_path = ibdata1:6500M:autoextend

#innodb 日志相关

innodb_log_file_size = 500M

innodb_log_buffer_size = 8M

innodb_log_files_in_group = 4

innodb_log_group_home_dir=/var/lib/mysql

innodb_flush_log_at_trx_commit=1

#innodb 内存相关参数

innodb_buffer_pool_size=2048M

innodb_additional_mem_pool_size = 32M

innodb_thread_concurrency =0

innodb_flush_method = O_DIRECT

expire_logs_days    = 5

log_bin             = /var/lib/mysql/mysql-bin

log_bin_index       = /var/lib/mysql/mysql-bin.index

2、(从库)修改/etc/my.cnf配置文件

port          = 3306

socket        = /var/lib/mysql/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 1M

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

binlog_format=mixed

server-id=50          //从库注意一定要修改此参数

lower_case_table_names=1