פקודות לעבודה עם 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

Setting program_name in mysql session_connect_attrs allows you to see the name of the program connected

I am using mysql for quite some time now. I have noticed that looking at client connections using mysql workbench so an interesting column ...