vike681 发表于 2018-9-27 08:59:30

解决 mysql主从失败

CHANGE MASTER TO master_def[,master_def] ...  master_def:
  MASTER_HOST = 'host_name'
  | MASTER_USER = 'user_name'
  | MASTER_PASSWORD = 'password'
  | MASTER_PORT =port_num
  | MASTER_CONNECT_RETRY =count
  | MASTER_LOG_FILE = 'master_log_name'
  | MASTER_LOG_POS =master_log_pos

  |>
  |>  | MASTER_SSL = {0|1}
  | MASTER_SSL_CA = 'ca_file_name'
  | MASTER_SSL_CAPATH = 'ca_directory_name'
  | MASTER_SSL_CERT = 'cert_file_name'
  | MASTER_SSL_KEY = 'key_file_name'
  | MASTER_SSL_CIPHER = 'cipher_list'
  可以更改从属服务器用于与主服务器进行连接和通讯的参数。

页: [1]
查看完整版本: 解决 mysql主从失败