Tag：sub-treasury
-
Time：2021-7-4
Write on the front Many small partners leave a message that let me write some real cases in the process of work, what to write? Think about it and write an article about the evolution process of database architecture upgrading from zero to more than ten million users in my previous company. This paper records […]
-
Time：2021-7-3
preface: Let’s talk about springboot integration todaySharding-JDBCRealize the sub database and sub table; I wrote a little story about itDemoThis demo is based on springboot and integratesMybatis, redis, swagger (generate online interface document), PageHelper (paging tool)Of course, sharding JDBC is absolutely integrated; And designedRestFulStyle interface, addedunit testing 。 Here is a brief introduction to the […]
-
Time：2021-6-29
“We’ve used it.”, is our favorite words, a few words behind represents the heavy trust and trust. Starting today, we will pass the“Believe in the power of openness”A series of in-depth case sharing, from the perspective of business, to see the business value of a database for users in various industries.This article will introduce the […]
-
Time：2021-6-26
AboveSharding JDBC middleware for quick start database and table (compulsory course)In this paper, we introducesharding-jdbcWe have also built a simple data fragmentation case, but the actual development scenario is much more complex than this. We will pressSQLDifferent operators that appear in>、<、between and、inAnd so on. Two days ago, a little friend asked a question in private […]
-
Time：2021-6-16
Brief introduction: the author of this paper has carried out a database expansion and database migration for a Gaode taxi order system. 1、 Background In 2020, the author is responsible for a high German taxi bomb outside the order system to expand the database sub table and database migration. The order system is deployed on […]
-
Time：2021-6-9
Thinking of MySQL table A 100 million order table can be divided into five tables, so that each table has only 20 million data, sharing the pressure of the original table. Sub tables need to be divided according to certain conditions. Here, tables can be divided according to regions. A middleware is needed to control […]
-
Time：2021-6-4
background In Xingye’s “journey to the west”, there is a very famous line: “once there was a sincere feeling in front of me, I didn’t cherish it. I didn’t regret it until I lost it. The most painful thing in the world is this. If God could give me a chance to do it again, […]
-
Time：2021-6-4
Recently, pingcap, a domestic enterprise level database company, has just won round D financing of 270 million US dollars, which has caused great repercussions in the database industry. Driven by the wave of new infrastructure construction and localization, the popularity of tidb database, the main product of pingcap, continues to rise. With the rapid popularization […]
-
Time：2021-6-3
1、 Database bottleneck Whether it is Io bottleneck or CPU bottleneck, it will eventually lead to the increase of the number of active connections in the database, and then approach or even reach the threshold of the number of active connections that the database can carry. In terms of business service, there are few or […]
-
Time：2021-6-1
DCE is a network programming framework based on php8. It supports traditional CGI style web programming and command-line tool programming, as well as resident memory style web programming and long connection server programming under spool. It also designs a set of common RCR architecture to deal with all types of network programming, so that your […]
-
Time：2021-6-1
Introduction: in order to eliminate the data island, enterprises often connect the data of each organization to the data lake to provide unified query or analysis. This article will introduce the whole process of data access, the challenges encountered during the process, and the value of delta in data access. background Fluency in the current […]
-
Time：2021-4-17
Theoretical knowledge Sub table – on the surface, it means to divide a table into n small tables, each of which is a complete table. After the sub table, the data is stored in the sub table, the master table is just a shell, and the access data occurs in the sub table one by […]
