With the popularization of servitization, it is more and more difficult to maintain sessions directly. Nowadays, a token is generally used to represent the login...
Replication Process Setting up an asynchronous replication master database After the Commit is performed, the master database writes Binlog logs to the client and returns...
Mycat Overview What is Mycat? From the definition and classification, it is an open source distributed database system, is a Server to implement the MySQL...
Why care about the Mysql architecture? Benefits Improved availability If a database instance is faulty, services can be provided by other database instances or can...
Schema.xml as one of the important configuration files in Mycat, schema.xml manages the logical library, tables, sharding rules, Datanodes, and DataSource of Mycat. Understand these...
Recently, I encountered slow SQL, simple look, again because MySQL itself optimizer and query plan estimation is not accurate problem. The SQL was executed for...
The project that the blogger is responsible for mainly uses MySQL database of Ali Cloud. Recently, slow SQL alarms frequently appear, and the longest execution...
Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". The following figure shows the logical architecture of...
The project that the blogger is responsible for mainly uses MySQL database of Ali Cloud. Recently, slow SQL alarms frequently appear, and the longest execution...
Hi, I'm Baymax, director of the Backend Research Institute! Today and we talk about an interesting topic: words without saying, look at my good brother...
Generally speaking, MySQL can be divided into Server layer and storage engine two parts. Server layer: includes connectors, analyzers, query caches, optimizers, actuators, and so...