Tag：sub-treasury
-
Time：2021-2-3
Glory-Admin Gloriadmin is a background framework based on springboot 2.1.9.release and Vue admin template; Gloriadmin uses role-based rights management. The role tree is a tree with “system administrator” as the root node, and the permission tree is composed of multiple sub permission trees. “System administrator” has all permissions; non system administrator role can view the […]
-
Time：2021-1-31
First of all, it is a great challenge to use Mysql to store 100 billion level data. MySQL single table can indeed store 1 billion level data, but the performance is very poor at this time. A large number of experiments in the project have proved that the capacity of MySQL single table is about […]
-
Time：2021-1-18
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, That is, there are few […]
-
Time：2021-1-7
Write on the front Glacier has experienced a complete e-commerce system development process from zero to hundreds of millions of users. In the process of continuous development and change of business, it has evolved e-commerce system and commodity accurate real-time recommendation platform based on big data. You can refer to the evolution of MySQL database […]
-
Time：2021-1-2
Hello, I’m Xiaofu~ Many of them have just entered the pitJavaI want to learn the technology of sub database and sub table systematically, but I haven’t made up my mind to do it. Now I’m catching up with the company projectsharding-jdbcOn the existingMySQLArchitecture to do the transformation of sub database sub table, so take this […]
-
Time：2020-12-28
Background 1 When the data of the table in the database reaches a certain level, we need to consider the solution. In fact, a single MySQL table can store 1 billion level data, but its performance is relatively poor at this time. It is generally recognized that the best state is that the capacity of […]
-
Time：2020-12-22
As we all know, we don’t need to divide tables and databases until we have ten thousand. I also have no way to implement simple table splitting without using middleware. The table can be divided according to the actual situation. What I want to divide is the motion data of sports wearable devices. A single […]
-
Time：2020-12-5
Hello, everyone. I’m Xiaofu~ There were a lot of new entrants beforeJavaThe fans leave a message, want to learn the technology of sub database and sub table systematically, but I haven’t made up my mind to do it. Now I catch up with the company’s project in usesharding-jdbcFor existingMySQLThe architecture is transformed into sub database […]
-
Time：2020-11-29
List of articles catalog 1、 Introduction to shardingsphere 2、 Sharding JDBC 2.1 sharding JDBC horizontal table splitting 2.2 implementation of JDBC 2.3 sharding JDBC operation common table 2.4 sharding JDBC implements read-write separation 3、 Sharding proxy Before learning, first understand the concept of sub database and sub tablehttps://spiritmark.blog.csdn.net/article/details/109524713 1、 Introduction to shardingsphere In the design […]
-
Time：2020-11-26
History of database development RDBMS Representatives: Oracle (commercial), MySQL (open source).Relational database (RDBMS) is the most widely used database management system. It can not only store data, but also perform complex data operations (left join, subquery, etc.).He has the following shortcomings: Cannot process unstructured data. In essence, it is a stand-alone system, which is difficult […]
-
Time：2020-11-23
With the development of the Internet information industry, the data volume of each company is steadily increasing, and even some companies are growing exponentially. In addition to some companies directly stepping into big data, we can imagine the database pressure of their own companies. After encountering these problems, hard-working programmers like various ways to solve […]
-
Time：2020-11-14
Glory-Admin Gloriyadmin is a background framework based on springboot2.1.9.release and Vue admin template; Gloryadmin uses role-based rights management. The role tree is a tree with “system administrator” as the root node, and the permission tree is composed of multiple sub permission trees. “System administrator” has all permissions; non system administrator role can view the information […]
