Links to the original text: segmentfault.com/a/1190000020116271
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 con ...
Posted on Fri, 06 Sep 2019 01:25:52 -0400 by spiceydog
This article is the fifth in a series of articles on database optimization: "Database optimization - backup and recovery"
See more articles
Database optimization: http://blog.csdn.net/leyounger/article/details/70157087
Backup and Recovery
1. Backup/Recovery Strategy
For a DBA, it is very important to customi ...
Posted on Fri, 28 Jun 2019 16:11:31 -0400 by Sera
Abstract: By creating a new slave library by backing up the file and running the binlog to the specified gtid location, the data can be restored to the specified time point.
First, the introduction of gtid characteristics:
GTID(global transaction identifier) is MySQL 5.6 The new feature, which can uniquely identify a transaction, consists ...
Posted on Sat, 15 Jun 2019 21:22:44 -0400 by froggie81
For reprint, please indicate the source: http://blog.csdn.net/l1028386804/article/details/60326337
I. Use scenarios
MySQL database is fully automated at 0:00 a.m. per day
At 9 a.m. one day, Zhang San accidentally drop ped a database.
We need full data files and incremental binlog files for data recovery
2. Main Ideas and Principles
Find o ...
Posted on Wed, 10 Apr 2019 22:30:31 -0400 by ignace
MySQL binlog The log file records all the modification operations of the database tables. This article briefly collates MySQL binlog related knowledge, and how to use binlog to restore or flash back database data.
Bilog in STATEMENT format
To open binlog, you need to pass in when you start MySQL-- log-bin Parameters. Or you can set log_bin to o ...
Posted on Sun, 03 Feb 2019 14:00:17 -0500 by Michdd