默認情況下,MySQL的復制功能是異步的。master把binlog發送給slave時,這個復制動作就已經完成,master不會驗證slave是否接收完畢(類似于Oracle DataGuard Maximum Performance)。異步復制同時意味著在把數據從一個mysqld實例拷貝到另一個mysqld時有一個延
13.4 mysql用戶管理創建用戶:grant all on *.* to 'user1' identified by 'passwd';或指定來源ip:grant all on *.* to 'user1'@'ip' identified by 'passwd';mysql>?grant?all?on?*.*?to?'user1'?iden