Monday, November 19, 2012

פקודות לעבודה עם master-slave של mysql - replication

CHANGE MASTER TO
MASTER_HOST='xxx.xxx.xxx.xxx',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='slavepass',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=0;


SHOW BINLOG EVENTS IN 'mysql-bin.000001' LIMIT 10;

STOP SLAVE;

START SLAVE;

SHOW SLAVE STATUS\G

And of course, a link to the master Moshe Kaplan Blog about MySQL repliaction

No comments:

Post a Comment