MySQL high availability architecture design
What problems does mysql replication solve
Realize data distribution on different serversLoad balancing of data readingEnhanced data securityAchieve high database availability and failoverRealize online database upgrade
mysql binary log
Service layer log
Binary logSlow check logGeneral log Storage engine tier loginnodb redo loginnodb rollba ...
Posted by haku on Mon, 31 Jan 2022 00:41:02 +0100
Deep understanding of MySQL logs
1.Error LogRecord the Error, Warning, Note and other information during MySQL operation. If there is a system Error or a record has a problem, you can view the Error log.MySQL's error log defaults to hostname Err is stored in the MySQL log directory and can be viewed through the following statementDuring default installation, the error log is u ...
Posted by jassh on Thu, 13 Jan 2022 05:12:04 +0100
Technology sharing | mysqlbinlog skills
Author: Hu ChengqingMember of aikesheng DBA team, good at fault analysis and performance optimization, personal blog: https://www.jianshu.com/u/a95... , welcome to the discussion.Source: original contribution*It is produced by aikesheng open source community. The original content cannot be used without authorization. For reprint, please contact ...
Posted by molave on Sun, 26 Dec 2021 17:35:12 +0100