Research Of Database Solution For High Concurrency Website

In the early days of the Internet,the content on the website is few.Most of websites only had static content,and just shared the content.To solve the problem of high concurrency and high load of a website was usually building the mirror site.Mirror site technology is widely used as an effective solution in this case.With the development of the Internet,more and more websites use server side script to generate dynamic content,but it is more and more difficult to synchronize and update.With the development of web technology in the Internet industry,Web2.0 applications are popular.The new concept of website construction,which based on the user oriented.Websites had subdivided into function and user community.By this concept a large number of successful new website application had been create,and greatly facilitates people of using them.However,the concept of Web2.0 is a user oriented,which makes the application of a new feature of the web site.Based on the premise that the Internet application presents the architecture complex,large capacity,and large amount of data and complicated with the characteristic of traffic,so the requirements of website applications had also been increased,especially the performance requirements of the database.Because the database is at the end of the whole application and it is the center of information and data resources.Most pressure of high concurrent website depends on the database's performance;the traditional database application has been unable to meet such requirements.In order to meet the needs of high concurrency website application,the database system must be refactoring.Generally,the solution was upgraded hardware and software.The performance of the whole system can be improving via increasing and improving the hardware equipment,and via the parallel extension of hardware and software.This paper will focus on the improvement of database performance via the software.Based on the change of internet industry,as well as the background of this research,this paper designs and implements a set of complete database solution for high concurrent website.By separating the database reading and writing,the database access will distribute to multiple databases.This greatly reduces the problem of single database performance pressure.By the database reading and writing separated,it is necessary to bring the problem of database synchronization update.The solution to this problem is to use the database replication technology.This paper continues to study the database replication technology.There are many solutions to the database replication technology,but the research of this paper based on the transaction log replication.In this scenario,the databases are divided into two parts: master and slave.A master database can be replicated to multiple slave databases,the slave database keeping synchronization with the master database updates,and also provide database access for the entire web site.Finally,because of the separation of the reading and writing,and the database replication technology,the memory database technology is studied.The use of the memory database is to strengthen the overall performance of the database.Therefore,this research provides a complete database solution for high concurrent network applications.