????1??????mysql?????????
??????master(??)???????????仯??????仯???????????slave(??)??
????2??????????????????
?????????????????????????
????????????á?Failover(????л?)/High Availability
????????????
????3????????????????????
?????????????????master-slave?????????
???????????


??????????delete??update??insert????????????????洢????????е????????master???
??????master?в????????slave????????????Щ????????????????
????????????????????????????
??????master???????????????????д???????log?????(binary-log);
??????slave???????slave?????????????????????????????仯????slave???????????????
???????????????????????
??????????????????????
????3.1??????????????Щ
?????????????
??????master???????????????????д???????log?????(binary-log);
????????????????3?????:statement??row??mixed??
????statement????????????????sql???д??binlog?С?
????row?????????????仯д??binlog?С?
????mixed??statement??row?????Mysql?????????дstatement???????????дrow?????binlog??
????3.2??master??????????
??????master??????????????????????(insert??update??delete)?仯???????д??binlog?С?
????binlog dump???
??????slave?????master?????master???????slave????binlog dump????
??????master ?? binlog?????仯?????binlog dump??????slave???????????binlog????????slave??
????3.3??slave??????????
?????????????????????slave?????2??????
????I/O??????????????master??????master???????binlog dump????binlog????????????I/O??????I/O???????binlog????????????д???????relay log??
????SQL???????????I/O???д???relay log?????????relay log???????slave?????????????????
????3.4?????master??slave?????????????
???????SHOW PROCESSLIST??????????
???????????master???????binlog dump????

???????????slave???????I/O??SQL????

????4?????????????????