Centos6,mysql 5.5 Configuring master \ Slave Data Synchronization Backup

2. Database A as the primary service, database B as a synchronous library (note: Both sides of the database library must be one, or there will be constant error information out, change, change, is not successful)
6. 1. Configure Master
8. Vi/etc/my.cnf
10. [Mysqld]
12. server-id=1
14. log-bin=Log Path
16. binlog-do-db=xxxx//means to back up only xxxx This library, you can configure multiple libraries
18. binlog-ignore-db=yyy//indicates ignoring YYY library
20. Note: If BINLOG-DO-DB,BINLOG-IGNORE-DB does not add the default backup of all libraries
24. Restart database service mysqld restart
28. Login to Database mysql-uroot-p123456
32. Create a backup account, preferably with slave, reload,super, permissions
34. Grant Peplication slave,reload,super on * * to ' backup ' @ ' percent ' identfiend by ' 1234 ' with GRANT option;
36. Note: This must be available with GRANT option, which indicates that backup has operational permissions
38. Flush privileges;
42. Show grant for ' backup ' @ '% '; View User
46. Show master status;
50. If the IP address changes:
52. Change Master to master_host=' xxx ',master_user=' backup ',master_password=' 1234 ',Master _port=' 3306 ',master_log_file=' master-log.000001 ',master_log_pos=4, master_connect_  retry=10;
56. 2, configuration slave
58. Vi/etc/my.cnf
60. Server-id=2
62. Change Master to master_host=' xxx ',master_user=' backup ',master_password=' 1234 ',Master _port=' 3306 ',master_log_file=' master-log.000001 ',master_log_pos=4, master_connect_  retry=10;
64. Note: Log name, user name, password must be with Master one to
68. show slave status\g;
70. See if the information is correct
74. Slave start;
76. With show slave status\g;
80. Just make sure:
82. slave_io_running=Yes
84. slave_sql_running=Yes
88. It's done.
92. I've got 2 questions.
94. The first one:
96. slave_io_running=connecting
98. slave_sql_running=Yes
102. Last_io_error:error Connecting Master ...
106. Looking for long time, the original user name password is wrong, it is a waste of time
110. The second one: (A little dizzy)
114. slave_io_running=No
116. slave_sql_running=Yes
118. Last_io_error: means that both the library and the table one to the synchronization did not find the corresponding libraries and tables
122. And then:
124. Slave stop;
128. Reset slave; Reset Slave
132. Change Master to master_host=' xxx ',master_user=' backup ',master_password=' 1234 ',Master _port=' 3306 ',master_log_file=' master-log.000001 ',master_log_pos=4, master_connect_  retry=10;
134. Again, no way, finally see
136. slave_io_running=Yes
138. slave_sql_running=Yes
140. Last_io_error: Empty
144. The DBA's job is really a careful person to play

Centos6,mysql 5.5 Configuring master \ Slave Data Synchronization Backup