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.
1. View binlog settings
mysql> show variables like 'binlog_format';
| Vari ...
Posted by rharter on Wed, 20 May 2020 08:33:53 -0700
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
Modify the ...
Posted by UVL on Thu, 02 Apr 2020 09:06:03 -0700
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
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.
MySQL Backup Strategy
MySQL Data Recovery
The premise ...
Posted by buildernaut1 on Mon, 19 Aug 2019 00:11:41 -0700
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:
Posted by hwttdz on Wed, 08 May 2019 07:45:40 -0700
mysql data recovery
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
Posted by mattonline on Sun, 14 Apr 2019 00:18:33 -0700
MySQL Binary Log Format
MySQL Storage Engine Layer Log
MySQL Service Layer Log
Slow check logs
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
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
Original address: http://blog.csdn.net/johnstrive/article/details/47946277
Two main functions of binlog
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