Two methods of Mysql using binlog to recover data to solve the problem of misoperation

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 ...

Posted by UVL on Thu, 02 Apr 2020 09:06:03 -0700

Smart use of Event s to discover problems

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 ...

Posted by Steven_belfast on Fri, 03 Jan 2020 07:11:01 -0800

Delete the database without running away - Explain MySQL data recovery in detail

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 ...

Posted by buildernaut1 on Mon, 19 Aug 2019 00:11:41 -0700

Deep parsing MySQL binlog

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 ...

Posted by hwttdz on Wed, 08 May 2019 07:45:40 -0700

mySQL Data Recovery

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 ...

Posted by mattonline on Sun, 14 Apr 2019 00:18:33 -0700

MySQL Binary Log Format

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 ...

Posted by attock on Thu, 11 Apr 2019 11:51:31 -0700

MySQL mysqlbinlog access mysql-bin log error

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 ...

Posted by Toshiba23 on Wed, 10 Apr 2019 10:00:32 -0700

Brief Introduction and Simple Operation of MYSQL Bilog

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%'; +---------------------------------+------- ...

Posted by smithveg on Mon, 08 Apr 2019 17:48:32 -0700