mysql master-slave-demo

config

• grant

GRANT replication slave ON *.* TO'root'@'%' identified by 'root';

• flush privaliges

if needed

• view master info

show master status

• config slave

change master to master_host='mysql',master_user='root',master_port=3306,master_password='root',master_log_file='mysql-bin.000003',master_log_pos=1027

• start slave

start slave

• view slave status

show slave status

java mysql binlog connector demo

• build

cd java-binlog
mvn clean package

• running

java -jar target/mysql-binglog-app.jar