Delete databases without running away: Explain MySQL data recovery in detail

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

Database optimization - backup and recovery

abstract 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

MySQL Data Recovery Based on gtid and xtrabackup

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

MySQL: A Case of Incremental Data Recovery in Database

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 notes

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