大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说mac 开启mysql bin-log,希望您对编程的造诣更进一步.
vim /usr/local/etc/my.cnf 添加以下配置
expire_logs_days = 5 定期清理
log-bin = /usr/local/var/mysql/mysql_bin_log/mysql-bin #开启binlog,指定文件闻之
server_id = 1 #配置mysql replication需要定义，不能和canal的slaveId重复
binlog_format=MIXEDD
代码100分
mysql.server restart // 重启mysql
show variables like "%log_bin% 查看是否开启
show master status; 查看日志状态
flush logs; 刷新日志，刷新之后会新建一个新的Binlog日志
reset master 清空目录下所有日志文件
查看日志文件：mysqlbinlog --base64-output=DECODE-ROWS -v mysql-bin.000001
代码100分/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#200423 16:43:25 server id 1 end_log_pos 123 CRC32 0xb303c132 Start: binlog v 4, server v 5.7.29-log created 200423 16:43:25 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
# at 123
#200423 16:43:25 server id 1 end_log_pos 154 CRC32 0x21d20383 Previous-GTIDs
# [empty]
# at 154
#200423 16:45:11 server id 1 end_log_pos 219 CRC32 0xfb334efd Anonymous_GTID last_committed=0 sequence_number=1 rbr_only=no
SET @@SESSION.GTID_NEXT= "ANONYMOUS"/*!*/;
# at 219
#200423 16:45:11 server id 1 end_log_pos 295 CRC32 0xb8e6b396 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1587631511/*!*/;
SET @@session.pseudo_thread_id=4/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1436549152/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 295
#200423 16:45:11 server id 1 end_log_pos 626 CRC32 0xa15900c0 Query thread_id=4 exec_time=0 error_code=0
use `chunyu`/*!*/;
SET TIMESTAMP=1587631511/*!*/;
UPDATE `article_article` SET `created_time` = "2020-04-23 08:17:20.953805", `last_modified` = "2020-04-23 08:45:11.324532", `user_id` = 1, `title` = "1", `content` = "999999", `status` = 1, `comment_count` = 0, `star_count` = 0 WHERE `article_article`.`id` = 2
/*!*/;
# at 626
#200423 16:45:11 server id 1 end_log_pos 657 CRC32 0xeb7a6863 Xid = 14
COMMIT/*!*/;
SET @@SESSION.GTID_NEXT= "AUTOMATIC" /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/8854.html
