Tag：sub-treasury
-
Time：2020-3-19
Preface Mybatis multi data source configuration. Recently, in the construction of the project, a new business module needs to be expanded on the original system, and the database is specially divided into databases, so as to reduce the complexity. This article directly uses a simple code example to configure mybatis multi data source. Get ready […]
-
Time：2020-3-14
Good article: http://blog.itpub.net/2673616 Question: (1) What does database data caching mean? (2) Join must be a database instance. How to understand a database instance? Does it refer to a database process? How to realize cross library join? (3) Are multiple database instances on the same physical machine sharing CPU and disk? (4) After sub library, […]
-
Time：2020-2-13
Preface In the previous blog “spring boot practice and thinking”, I mentioned the separation of master-slave and read-write when comparing the application scenarios of ORM framework with different specifications. This essay will make a more in-depth discussion on this and the sub database and sub table. 1. informal discussion Before I get to the point, […]
-
Time：2020-2-2
If you need to learn how to communicate, please join us in the communication group. The group is full of developers for 1-7 years. If you want to discuss PHP, swoole technology or have other questions, you can also ask. You can get swoole or PHP advanced information private chat management Click here to join […]
-
Time：2020-1-15
The first part of sub database and sub table 1. overview 1.1. What are sub databases and sub tables 1.2. Method of sub warehouse and sub table 1.2.1. Vertical table 1.2.2. Vertical sub warehouse 1.2.3. Horizontal sub warehouse 1.2.4. Horizontal sub table Summary of 1.2.5 1.3. Problems caused by sub database and sub table 1.3.1. […]
-
Time：2020-1-12
Why do we need to divide databases and tables? With the rapid development of information technology in recent years, paperless office in all walks of life has produced a large number of data, and more and more data has been stored in the database. When usedMySQLWhen a single table exceeds 20 million data in a […]
-
Time：2020-1-1
This paper mainly focuses on small and medium-sized applications or websites, focusing on the optimization of SQL statements in daily program development. The so-called “big data” and “high concurrency” are only for small and medium-sized applications. Please ignore the professional database operation and maintenance God. The following practices are some coping strategies for the relatively […]
-
Time：2019-12-8
Interview questions How to deal with ID PK after sub database and sub table? Psychological analysis of interviewers In fact, this is a problem you must face after the sub database and sub table. How to generate the ID? Because if you divide a table into several tables and each table is accumulated from 1, […]
-
Time：2019-10-17
Preface When the business volume is growing, the single table data is more than tens of millions, or even hundreds of millions, and the query in a table is really time-consuming. In the distributed system, sub table and sub database is also a common way to solve this kind of bottleneck. Today, choose springboot + […]
-
Time：2019-8-11
A previous article has talked about the master-slave cluster of database cluster, that is, the separation of read and write, and also mentioned thatRead-write separation is actually sharing the pressure of access, but the pressure of storage is not solved. The pressure of storage is to say that as the system evolves and the demand […]
-
Time：2019-5-21
Preface In addition to using middleware to distribute requests, another common method of database sub-table is to distribute database sub-tables at the client level. By properly wrapping client code, database access operation code of database sub-table can be easily written. The sub-database and sub-table schemes in this paper are based on MyBatis framework, but they […]
