binlog incomplete.Missing some databases's record
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