MySQL related knowledge is very important for us programmers, from simple add, delete, change and check, to the stored procedure and other complex operations, we...
Internet software systems have been evolving to adapt to more complex business scenarios, higher performance requirements, etc., due to increasing demand, users, etc. There are...
Recently, there has been a hot word "the new generation of migrant workers", among which there is a special group of "front-end engineers", which was...
This compression mainly refers to the MySQL bin-log compression, and the compression algorithm used is LZ4. When network bandwidth is the bottleneck, message compression can...
In a typical database query scenario for Mongodb, index plays a very important role. Without index, Mongodb needs to scan the entire collection to find...
Recently, there has been a hot word "the new generation of migrant workers", among which there is a special group of "front-end engineers", which was...
While we've discussed indexing in several articles, this article will begin with a brief overview of the concept of indexing. The database version is 8.0.2...
The scene of weak network weak network and the conventional Internet is still not the same, the conventional Internet to the limit challenge, has been...
In this paper, we will discuss with you the design and practice of multi-version migration support of data synchronization platform ES, high availability of data...
"This is the 14th day of my participation in the August More Text Challenge. For details, see: August More Text Challenge" 1. Optimization Philosophy 1.1...
Prerequisites The mysql active/standby mode has been set up. Mysql Master/slave mode STATEMENT mode (SBR) Each SQL STATEMENT that modifies data is recorded in the...
This article discusses how Innodb transaction isolation is implemented. The default isolation level is repeatable read. Mainly talk about the overall context, after the context...