Binlogåºæ¬é
å¶ä¸æ ¼å¼è®¾å®
1.åºæ¬é
å¶
Mysql BInlogæ¥å¿æ ¼å¼å¯ä»¥éè¿mysqlçmy.cnfæ件çå±æ§binlog_formatæå®ãå¦ä»¥ä¸ï¼
binlog_format = MIXED //binlogæ¥å¿æ ¼å¼
log_bin =ç®å½/mysql-bin.log //binlogæ¥å¿å
expire_logs_days = 7 //binlogè¿ææ¸
çæ¶é´
max_binlog_size 100m //binlogæ¯ä¸ªæ¥å¿æ件大å°
2.Binlogæ¥å¿æ ¼å¼éæ©
Mysqlé»è®¤æ¯ä½¿ç¨Statementæ¥å¿æ ¼å¼ï¼æ¨è使ç¨MIXED.
ç±äºä¸äºç¹æ®ä½¿ç¨ï¼å¯ä»¥èè使ç¨ROWEDï¼å¦èªå·±éè¿binlogæ¥å¿æ¥åæ¥æ°æ®çä¿®æ¹ï¼è¿æ ·ä¼èçå¾å¤ç¸å
³æä½ã对äºbinlogæ°æ®å¤çä¼åå¾é常轻æ¾,ç¸å¯¹mixedï¼è§£æä¹ä¼å¾è½»æ¾(å½ç¶åææ¯å¢å çæ¥å¿éæ带æ¥çIOå¼éå¨å®¹å¿çèå´å
å³å¯)ã
3.mysqlbinlogæ ¼å¼éæ©
mysql对äºæ¥å¿æ ¼å¼çéå®åå:å¦ææ¯éç¨ INSERTï¼UPDATEï¼DELETE çç´æ¥æä½è¡¨çæ
åµï¼åæ¥å¿æ ¼å¼æ ¹æ® binlog_format ç设å®èè®°å½,å¦ææ¯éç¨ GRANTï¼REVOKEï¼SET PASSWORD ç管çè¯å¥æ¥åçè¯ï¼é£ä¹æ 论å¦ä½ é½éç¨ SBR 模å¼è®°å½ ãLinux就该è¿ä¹å¦ãä¸èµ·å¦ä¹ linux
4.Mixedæ¥å¿è¯´æï¼
å¨slaveæ¥å¿åæ¥è¿ç¨ä¸ï¼å¯¹äºä½¿ç¨nowè¿æ ·çæ¶é´å½æ°ï¼MIXEDæ¥å¿æ ¼å¼ï¼ä¼å¨æ¥å¿ä¸äº§ç对åºçunix_timestamp()*1000çæ¶é´å符串ï¼slaveå¨å®æåæ¥æ¶ï¼åç¨çæ¯sqlEventåççæ¶é´æ¥ä¿è¯æ°æ®çåç¡®æ§ãå¦å¤å¯¹äºä¸äºåè½æ§å½æ°slaveè½å®æç¸åºçæ°æ®åæ¥ï¼è对äºä¸é¢æå®çä¸äºç±»ä¼¼äºUDFå½æ°ï¼å¯¼è´Slaveæ æ³ç¥æçæ
åµï¼åä¼éç¨ROWæ ¼å¼åå¨è¿äºBinlogï¼ä»¥ä¿è¯äº§ççBinlogå¯ä»¥ä¾Slaveå®ææ°æ®åæ¥ã
温馨提示:答案为网友推荐,仅供参考