During MySQL o&M, it is inevitable to encounter MySQL deadlocks. Once online services become increasingly complex, lock conflicts may occur between various service operations, some...
In order to achieve report effect, their own requirements. Basically is train of thought, train of thought realized other effect also OK. Figure out how...
Cache is an important part of improving application performance. Write an article summarizing the various caches used for dynamic content. The article uses Nginx, Rails,...
Directory Preface Enum Introduction Practice Final Suggestions: Preface How to select the MySQL type when there are too many enumerated fields in the project? Tinyint,...
The first data technology carnival in the real sense, the creators, architects and applications of native database products from different directions gathered together to share...
The second step: install in the location you want to install in the decompression out, the location must remember. Creata database db_name; Create table tb_name...
MySQL's history can be traced back to 1979. Its founder, MichaelWidenius, designed an API while developing a reporting tool. Later, when his client requested that...
While researching HikariCP, a database connection pool, I came across an article on HikariCP's Github Wiki (the link above) that was a great relief to...
Once you use MySQL replication, you are likely to encounter a master/slave switchover. This may be to upgrade the server iteratively, or to convert a...
Reprint address: http://www.jfh.com/jfperiodical/article/1041 why a migration MySQL migration is one of the DBA daily maintenance work. Removal, in its original meaning, is nothing more than...
Introduce a dual node master slave + Keepalived /heartbeat solution. Generally speaking, this architecture is the most convenient for small and medium scale applications. The...
Percona XtraDB Cluster (PXC for short) is a multimaster synchronous replication plug-in based on Galera 2.x library. It is mainly used to solve the problem...
Today we are going to share our exploration and practical experience in the field of AIOps (Intelligent Operations) in recent years. With the explosive growth...
GitHub uses MySQL as the primary storage for all non-Git repository data, and its availability is critical to GitHub's access operations. The GitHub site itself,...
Database, as the core basic component, is the object that needs to be protected. Any careless online operation may cause a serious database failure, resulting...
Indexes are data structures that help MySQL efficiently retrieve data. Indexes are critical, especially as the amount of data in a table increases, and their...