Database hosting method and database hosting platform system

Abstract

The invention discloses a database hosting method and a database hosting platform system. The method comprises the steps of: saving information of all database instances, wherein each database instance comprises a master database and more than one slave databases; monitoring the master database and the slave databases, when the master database fails, selecting one of the slave databases as a new master database, degrading the faulty original master database to a slave database, modifying information of the saved corresponding database instances, and marking the faulty original master databaseas non-liveness; when a slave database fails, modifying information of the saved corresponding database instances, and marking the slave database as non-liveness; and receiving a database resource request sent by an application program, and returning the information of the requested database resource to the application program according to the information of the saved database instances. According to the technical scheme of the invention, the development of the application program can be simplified, and dynamic capacity expansion can be realized under the sudden increase of reading services.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a database hosting method and a database hosting platform system. Background technique [0002] Today, with the rapid development of the Internet, the demand for high concurrent data access on the server side is becoming more and more obvious, but unexpected downtime of the database will always bring adverse effects. For large Internet companies, various projects come one after another, and the demand for hardware resources becomes obvious. Problems such as insufficient machine resources, or low machine utilization rate seriously affect the development of Internet companies. [0003] The usage of the traditional MySQL database is: the database resources are composed of a master library (Master) and one or more slave libraries (Slave), and the application directly accesses the database resources. When the business peak encounters slow SQL (Structured Query Language, Structure...

AI Technical Summary

Problems solved by technology

[0002] Today, with the rapid development of the Internet, the demand for high concurrent data access on the server side is becoming more and more obvious, but unexpected downtime of the database will always bring adverse effects

For large Internet companies, various projects come one after another, and the demand for hardware resources becomes obvious. Problems such as insufficient machine resources, or low machine utilization rate seriously affect the development of Internet companies.

[0003] The usage of the traditional MySQL database is: the database resources are composed of a master library (Master) and one or more slave libraries (Slave), and the application directly accesses the database resources. When the business peak encounters slow SQL (Structured Query Language, Structured Query Language) will affect the downtime of a database host, resulting in abnormal business

For multiple Slave applications, configuration management is troublesome and application development is complicated

[0004] It can be seen that in the existing database usage scheme, since the application directly accesses the database, the development of the application program needs to consider the failure of the master library and the slave library, as well as the distribution of the database, etc., so the development of the application program is complicated.

Images