Skip to main content

Posts

Showing posts from November, 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