Programmer Group

Today, a question suddenly comes to mind. Is the DELETE, DROP, TRUNCATE command the same as the binlog in ROW format? It's not the same to remember vaguely, but it's not sure; so let's take a look at the experiment. MySQL:5.6.20MySQL:5.7.22 1. View binlog settings mysql> show variables like 'binlog_format'; +---------------+-------+ | Vari ...

Not finished yet... To be edited To ensure that there is no other parameter configuration impact, a CentOS7 virtual machine with minimized installation is reinstalled 1. Install mysql5.6 database https://my.oschina.net/sgmder/blog/1631045 2. Configure mysql, enable binlog, and change binlog mode to Row Level mode vi /etc/my.cnf  Modify the ...

Welcome to my In-depth Understanding MySQL Principle 32, as follows: With a previous understanding of Events, we can use them to do some work.After learning these commonly used Events, I used C to write a tool for parsing Events. I called it'infobin', which means extracting information from a binary log.As far as I know, there are some friends ...

In our daily work, there will always be some erroneous deletion of database tables and data caused by hand shaking, wrong writing conditions, wrong table names, wrong connection with production database. Then, if the data can not be recovered, what DBA is needed. Related articles MySQL Backup Strategy MySQL Data Recovery 1 Preface The premise ...

1. overview Bilog is a binary log maintained by Mysql sever layer, which is completely different from redo/undo log in innodb engine. It is mainly used to record SQL statements that update mysql data or potentially update, and stored on disk in the form of "transaction". The main functions are: Replicat ...

mysql data recovery Author: xluren mysql does not open mysqlbinlog by default. Log in to mysql and execute the following commands. The results are as follows: mysql> show binlog events; Empty set (0.00 sec) mysql> The return result is empty So to modify the configuration file, open this option [mysqld] datad ...

MySQL Binary Log Format Log classification MySQL Storage Engine Layer Log innodb Redo log Rollback Log MySQL Service Layer Log Binary logs Slow check logs General log Introduction to Binary Logs All modification events to the MySQL database, including DDL and DML operations, were recorded. The binlog only logs successful execution ...

problem mysqlbinlog -v -v --base64-output=DECODE-ROWS mysql-bin.000166 | less ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 111, event_type: 35 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE ...

Original address: http://blog.csdn.net/johnstrive/article/details/47946277 Two main functions of binlog High availability Data recovery. How to Open Bilog Configure in my.cnf: log_bin=/home/data/ mysql/binlog/mysql-bin Check if it's open mysql> show variables like '%log_bin%'; +---------------------------------+------- ...