What is the ghost of MySQL binlog failing to recover data based on time?

Problem phenomena A customer feedback, when using binlog to do point-based recovery, often fails to correctly restore data (the probability is about 5%~10%). The database environment provides MySQL 5.7.27 version of cascade replication topology (A->B->C), main library A provides write ...

Posted on Thu, 01 Aug 2019 20:37:55 -0700 by dougp23

How to Deal with MySql Deadlock

When MySql deadlocks occur, InnoDB automatically detects transaction deadlocks, rolls back immediately, and returns errors. Rollback usually chooses the transaction with the smallest undo amount. Prior to MySql 5.6, the last deadlock that occurred could be returned by using the SHOW ENGINE INNODB STATUS command. After MySql 5.6, all InnoDB de ...

Posted on Thu, 04 Jul 2019 11:27:07 -0700 by Rowno

Repair of Synchronization Anomalies Caused by MySQL Server Abnormal Power Failure

At noon, taking advantage of the meal time to extract teeth, just ready, the boss called, said that there was an unexpected power outage of a db server, simple communication, the machine up first, wait for a look back, found that the problem is not so simple. The power is off by a master. Look at slave and find that slave has stopped sync ...

Posted on Fri, 12 Apr 2019 00:54:31 -0700 by Ionisis

MySQL duplication, tamping, checking and principle discussion

An introduction R&D response, there is a platform from the library and the main library is not synchronized. Because business read operation is aimed at slave database, data asynchronization will inevitably lead to data inconsistency, and the results of business acquisition will be affected, so this problem must be solved as soon as p ...

Posted on Mon, 01 Apr 2019 23:24:29 -0700 by jsantama

Mysql master replication failed

Mysql master replication failed Mysql master replication failed Fault description Architecture information Node information fault analysis Synchronized slave environment for AIPPRD2 Synchronizing the slave environment of AIPPRD1 Fault description Cause description Because of the aging of the cabinet PDU, the whole cabinet pow ...

Posted on Sat, 23 Mar 2019 09:06:54 -0700 by mapleshilc

Bilog parameter in MySQL: binlog_rows_query_log_events

When using RBR, that is, line format, to parse binlog, it is necessary to reverse to analyze the corresponding original SQL, and the corresponding content is each specific line change. Of course, you can turn on general log, but if all we need is to record the corresponding row changes, instead of recording the normal queries of these select s, ...

Posted on Mon, 11 Feb 2019 03:42:18 -0800 by RabPHP

mysqlbinlog: unknown variable xxx of the my.ini

background Work requires sql, want to install an SQL on your computer, in this record SQL installation version of the installation process of my.ini configuration file pits.) Download and Installation Installation-free download and installation http://blog.csdn.net/u013716535/article/details/78434838 Two, issue After decompression, re ...

Posted on Thu, 07 Feb 2019 19:39:17 -0800 by stpra123