MySQL Forums
Forum List  »  Replication

binlog incomplete.Missing some databases's record
Posted by: Harrison Jhon
Date: October 09, 2018 12:24PM

in mysql-audit.log ,we found some records about c_bet.but we couldn't find any record that contain "c_bet" in every each of binlog files.
Could any one help me with this ? I cloudn't find any clue on the internet.
post a message here is my last hope...

here is my.cnf:
[mysqld]
symbolic-links=0
innodb_buffer_pool_size=4G
key_buffer_size=1G
max_connections=3000
max_connect_errors=100
expire_logs_days=30
log-bin = /binlog/mysql-bin
skip-name-resolve
basedir=/usr/local/mysql
datadir=/mysql/data
port = 3306
server_id=117
socket=/tmp/mysql.sock
sql_mode=""
# mysql-audit
plugin-load=AUDIT=libaudit_plugin.so
audit_validate_checksum=ON
audit_json_file=ON
audit_uninstall_plugin=ON
audit_offsets=7800, 7848, 3624, 4776, 456, 360, 0, 32, 64, 160, 536, 7964
#审计日志文件绝对路径
audit_json_log_file=/tmp/mysql-audit-3306.log
#需要审计的命令
audit_record_cmds= drop,alter,update,delete,insert
[mysql]
socket=/tmp/mysql.sock


this is the master ,and on the slave,I run the "show slave status \G;" command,it shows the master-slave replication is ok.

really appreciate if you could help

Options: ReplyQuote


Subject
Views
Written By
Posted
binlog incomplete.Missing some databases's record
617
October 09, 2018 12:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.