Application of Database Read and Write Separation and Table Partition in Liquefied Gas Information Management System

With the expansion of LPG information management system business and the increase in orders year by year, In addition to satisfying the normal functional requirements of users, the LPG information management system also needs to consider the high concurrent requests of the database and the response performance of accessing the order form during peak periods. This paper proposes a design scheme based on database read-write separation and table partitioning in order to solve the response delay of high concurrency and query large data volume order tables and relieve the load pressure of the database server. Experimental results show that read-write separation can greatly improve the responsiveness of the system; table partitioning can greatly shorten the query time for data. And this solution can effectively achieve high availability.