配置mysql主从复制时,在从机上需要进行CHANGE MASTER TO操作,以确定需要同步的主机IP,用户名,密码,binlog文件,binlog位置等信息。
CHANGE MASTER TO option [, option] ...
option:
MASTER_BIND = ‘interface_name‘
MASTER_HOST = ‘host_name‘
MASTER_USER = ‘user_name‘
MASTER_PASSWORD = ‘password‘
MASTER_PORT = port_num
MASTER_CONNECT_RETRY = interval
MASTER_RETRY_COUNT = count
MASTER_DELAY = interval
MASTER_HEARTBEAT_PERIOD = interval
MASTER_LOG_FILE = ‘master_log_name‘
MASTER_LOG_POS = master_log_pos
MASTER_AUTO_POSITION = {01}
RELAY_LOG_FILE = ‘relay_log_name‘
RELAY_LOG_POS = relay_log_pos
MASTER_SSL = {01}
MASTER_SSL_CA = ‘ca_file_name‘
MASTER_SSL_CAPATH = ‘ca_directory_name‘
MASTER_SSL_CERT = ‘cert_file_name‘