MySQL replication source, in simple terms, is to configure multiple available replication sources. When a replication source is unavailable (downtime, replication link interruption), it automatically selects a new source according to the weight to continue synchronization. A bit similar to MongoDB's replication mechanism, but there are still some differences. 1.
Keywords are meaningful words in SQL. It is the vocabulary of MySQL built-in rules. These keywords provide great convenience for MySQL grammar, function definition, and parsing grammar. Some keywords (such as SELECT, DELETE, or BIGINT) are reserved and require special handling when used as identifiers such as table names and
problemFrequently receive questions from customers about communication failure errors—Customers are facing intermittent "Got an error reading communication packet" errors. Here is an analysis of the reasons for this error and how to solve the problem. Official explanationFirst, when a communication failure error occurs, the counts of the MySQL state
Recently there is a project to use the multi-source copy function. Some problems were found during use. Research and testing in this area were carried out Multi-source replication Multi-source replication is to copy the data of each primary database to a unified secondary database for summary.Instructions As follows: The
Why upgrade to MySQL8.01) Based on security considerations 2) Based on performance and stability considerations: mgr copy, parallel copy writeset and other functions, performance improvement 3) New functions: Hash join, window function, DDL instant, joson support 4) Too many versions in the original environment , Unified version. The 8.0
MySQL is a write-ahead log method that provides atomicity and durability. For the service layer binlog, it is often used in daily troubleshooting and analysis. Sorted out practical related commands. Hope it helps in work. There are two types of mysqlbinlog related commands, mysql client commands and execution files. Client
Resource group introductionMySQL is a single-process multi-threaded program. MySQL threads include background threads (Master Thread, IO Thread, Purge Thread, etc.), as well as user threads. Before 8.0, the priority of all threads was the same, and the resources of all threads were shared. But after MySQL8.0, due to