mysql主從同步隨筆

mysql主從同步隨筆   vim /etc/my.cnf   server-id=1   log-bin=/data/binlog/mysql-bin   binlog-ignore-db=mysql   binlog-ignore-db=test   binlog-ignore-db=information_schema   flush tables with read lock;   show master status;   server-id=2   stop slave;   chage master to   master_host=   master_user=   master_password=   master_port=   master_log-file=   master_log_pos=   start slave;   show slave status;