mysql 主从设置

参考：
http://blog.miniasp.com/post/2012/07/04/How-to-setup-MySQL-55-One-way-replication-Master-Slave-mode.aspx

http://fghjk.blog.51cto.com/4359709/830794

http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

http://blog.youkuaiyun.com/hguisu/article/details/7325124

http://coding.memory-forest.com/%E5%BB%BA%E7%AB%8B%E4%B8%80%E5%80%8Bmysql%E4%BC%BA%E6%9C%8D%E5%99%A8%E7%9A%84%E5%82%99%E6%8F%B4ms-replication.html

注意点：
1 权限设置

CHANGE MASTER TO MASTER_HOST='0.0.0.1', MASTER_PORT=3306, MASTER_USER='repluser',
  MASTER_PASSWORD='web';

2 如果slaver server开启了slave status，则其他数据库就无法使用了，而且phpmyadmin也登入不了

3 要保证slave server可以连接到master server