Research And Design Of Database Architecture Optimization Of Bilingual Reading Platform Based On MySQL

As an important medium between the "Internet+education" and users,reading platforms play an important role in spreading knowledge.In the current wave of the development of the Internet industry,the number of users of a bilingual reading platform is increasing,the functions are gradually expanding,and the data stored in the database is gradually increasing,which makes the platform need to be upgraded to meet the challenges brought about by the above changes.For platform operators,it is necessary for the platform to provide users with a stable and rapid response in order to serve users better and the further development of the platform itself.From the user’s point of view,the platform currently has the problem of slow access and long loading time.These problems have affected user’s experience.Based on the above issues,this article starts from the database architecture and provides a database architecture optimization solution for the platform to improve user experience.This paper realizes the optimization and design of database query based on analyzing the performance of the system database.First,the use of indexes for the tables in database and SQL statement optimization technology avoid the low-performance method of full table search,and achieves the reduction of the number of rows and query time of the original long-consuming SQL statement query.Second,the database read-write separation architecture is designed to realize a one-master and multipleslave database architecture.Writing data is carried out through the main database,and reading data is shared by multiple slave databases.Realize multiple databases to share the query business pressure,thereby improving the user experience.Third,use Zabbix software to build a monitoring system on the server where the database is located for real-time monitoring,to achieve the visual presentation of multiple indicators of the database and the server,and to alert the system administrator in time when the monitoring indicators are abnormal.Finally,this article uses auto-testing technology to test the performance before and after database optimization.Under different request density and request complexity,the speed of database execution of SQL and the load of the server during the test are obtained.The test results show that the optimization of the database effectively reduces the database access time and greatly improves the user access experience.During the operation of the database,the entire performance monitoring and abnormal alarm of the database can be realized.