Mysql replication

MYSQL Replcation, Cheat sheets

start.bat

set path=e:\IntraSell\MySQL\mysql-5.5.28-winx64\bin;%path%

mysqld --defaults-file="e:\IntraSell\MySQL\mysql-5.5.28-winx64\my.ini"
pause 

my.conf

server-id=3

log-bin=
log-slave-updates
slave-skip-errors=all
binlog-format=row

Commands

STOP SLAVE;

Set Replication

 CHANGE MASTER TO 
 MASTER_HOST = 'host_name',
 MASTER_USER = 'user_name',
 MASTER_PASSWORD = 'password',
 MASTER_PORT = port_num,
 MASTER_LOG_FILE = 'master_log_name',
 MASTER_LOG_POS = master_log_pos;

START SLAVE;

Full syntax

CHANGE MASTER TO option [, option] ... [ channel_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 = {0|1}
 | RELAY_LOG_FILE = 'relay_log_name'
 | RELAY_LOG_POS = relay_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_CRL = 'crl_file_name'
 | MASTER_SSL_CRLPATH = 'crl_directory_name'
 | MASTER_SSL_KEY = 'key_file_name'
 | MASTER_SSL_CIPHER = 'cipher_list'
 | MASTER_SSL_VERIFY_SERVER_CERT = {0|1}
 | MASTER_TLS_VERSION = 'protocol_list'
 | MASTER_PUBLIC_KEY_PATH = 'key_file_name'
 | GET_MASTER_PUBLIC_KEY = {0|1}
 | IGNORE_SERVER_IDS = (server_id_list)

channel_option:

   FOR CHANNEL channel

server_id_list:

   [server_id [, server_id] ... ]