The master database records the data update event in the binary log, binlog, before each transaction is updated. The sync_binlog parameter on the primary library...
1. Overview The previous article introduced the principles of redo log writing. This article mainly describes how to recover redo logs from disk. Data recovery...
This article describes didi's practical path of building NewSQL on top of distributed Nosql storage Fusion. This section describes the features, application scenarios, and design...
In the business of jingdong Home order Center system, whether it is the order production of external merchants or the dependence of internal upstream and...
First of all, mysql is mainly composed of two parts: server layer and storage layer. The Server layer consists of connectors, query caches, analyzers, optimizers,...
At the 5th China International Big Data Conference held on October 18-19, 2018, Giant Sequoia database, a final-grade distributed database vendor, won the title of...
Unless the single table data will continue to grow in the future, do not consider splitting at first. Splitting will introduce various complexity of logic,...
Above is a simple query statement that the database executes and returns name. It seems simple enough, but the internal implementation process is unknown to...
Parsing the string input from the client, such as identifying an update statement and other statements, identifies table_name as a table name and ID as...
4. The execution of complex SQL, stored procedures, triggers, indexes are better than mysql, after all, it is multi-process mode, while mysql is thread mode,...
What about this statement? There's too much knowledge involved. To answer these two questions, you need to know something first. The default storage engine for...
Abstract: "Cloud Weekly" 91 issue: 2016 Ali Security Summit key information fresh open, can not miss the headlines of the first Alibaba online technology summit:...
Index is similar to the bibliographic index of university library, which can improve the efficiency of data retrieval and reduce the IO cost of database....
The MySQL character encoding set has two utF-8 encoding implementations: UTF8 and UTF8MB4. Using UTF8 will cause errors in storing emojis and complex Chinese and...
Abstract: During double 11, please take care of programmers! Tencent video address https://v.qq.com/x/page/n0785jzewgq.html youku video address https://v.youku.com/v_show/id_XM
Note that the memory temporarily used during mysql execution is managed in the connection object and will be released only when the connection is disconnected....
We've looked at replication and extensibility before, so let's look at usability. In the final analysis, high availability means "less downtime". Our common availability is...