Tag：sub-treasury
-
Configuring multiple data sources with spring boot
After business development, some query type requests need to be switched to standby data sources. At this time, multi data source configuration needs to be used. The company’s projects do not use master-slave, but need to query the PostgreSQL Library (the business library is mysql, so it is not a simple master-slave, and the statements […]
-
Some experience of building high concurrency system
Some experience summary on how to build high concurrency system is for reference only. Welcome to exchange. preface infrastructure database framework application standard summary preface It has been a while since I left hungry. During the period of hungry, I began to take over the development and maintenance of Waybill system in 2017, from the […]
-
Java practice: teach you how to divide databases and tables
Summary:Through a practical case, this paper explains how to horizontally divide the order data into database and table according to the date, so as to realize the distributed query and operation of the data. This article is shared from Huawei cloud community《Summary of Java practical experience in database sub database and table [bloom! Database]》, author: […]
-
The interviewer asked me about MySQL tuning. I really am
interviewer：How do you tune MySQL? candidate : Wow, this is a big proposition… I think for developers, the focus of MySQL tuning is generally on “development specification”, “database index” or solving online slow queries. candidate : the internal parameter tuning of MySQL is done by professional DBAs. interviewer: after talking so much, you just want […]
-
Springcloud microservice practice — building an enterprise level development framework (XXVII): integrating multiple data sources + Seata distributed transactions + separation of reading and writing + sub database and sub table
read write separation: in order to ensure the stability of database products, many databases have dual computer hot standby function. That is, the first database server is a production server that provides external addition, deletion and modification services; The second database server is mainly used for reading. at present, there are many ways to […]
-
Mysql database and table
1、 Vertical split 1. Vertical sub Library:In the development of distributed system, it is basically divided according to modules, and each business module establishes a database characteristic:Business differentiation is high, which is convenient for maintenance and management; Each module is maintained independently, which can share the maintenance cost of the system and improve the availability. […]
-
The sod framework, which is much simpler than the entityframework, dynamically creates tables
See a blog post todayHow does the entityframework core map dynamic models?, the article talks about how to dynamically create a table with EF, such as dynamically creating a table according to time. This scenario often appears in the logging function of the application system. The implementation of the original text with EF is very […]
-
NR database sub database
The NR database we downloaded is very large. After the update in September 2017, the FASTA files of all NR have reached 72g. Therefore, if we do not distinguish the NR database by category during NR comparison, it will consume our computing resources and time. Therefore, it is best to divide the downloaded NR database […]
-
Table splitting method for relationship setting between laravel models
In the actual development, it is often used to divide the database into tables. For example, the user table is divided into 100 pieces. At this time, the sub table needs to be set to query the data. For example, the settable method is provided in laravel’s model class: /** * Set the table associated […]
-
Shardingjdbc realizes horizontal sub database and horizontal sub table
Shardingjdbc is a lightweight Java framework and an enhanced version of JDBC After completing the database and table division, use sharding JDBC to read the data Shardingjdbc is used to simplify the database operation after database and table splitting Differences between horizontal sub warehouse / sub table and vertical sub warehouse / sub table 6ebdf2b10a93ab01ff35df9f55002ea.jpg […]
-
SQL database and table
historical background MySqlPerformance bottleneck 1. The amount of table data is too large 2. SqlThe query is too complex 3. SqlNo index 4. Low performance of database server Solution Alibaba Development Manual: the number of rows in a single table exceeds 500W or the capacity of a single table exceeds 2G Database sub database sub table Sub database and […]
-
Some records of MySQL sub database and sub table
1、 Split by business dimensionFor example, a system may include user, commodity and order business. Because these three dimensions are unbalanced in access and data reading and writing, in order to avoid mutual influence and improve performance, it can be divided into user system, commodity system and order system according to business dimension. 2、 Data […]