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

GeekCon 2025 - Building an Arcade Machine (rhythm machine)

GeekCon is by far the best conference I have ever participated in. If you are not that familiar about GeekCon , so shortly, once every year...