Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to select the high availability database, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

As we all know, with the deepening of information construction, the wide application of information system has greatly improved the business efficiency, and its status has become increasingly prominent. For this reason, once the operation of the information system is interrupted, it will have a serious impact on the business operations of relevant organizations and institutions, and even threaten national security. Among them, as the core of data storage and calculation in the information system, ensuring its continuous operation is very important to the continuous operation of the whole system.

Planned event

In the process of application development and online deployment, it is inevitable to encounter design changes (such as table structure changes, index modifications, etc.), deployment changes (such as modification of storage location, etc.), software upgrades and so on. Because these events can be planned in advance, they are planned events.

Unplanned event

In the process of running the information system or database, it is inevitable to encounter operating environment failures (power outage, network outage, software errors, hardware failures, etc.), manual operation errors and even malicious destruction of the system. Since these situations cannot be planned in advance, they are unplanned events.

If the above events occur, the operation of the database and even the system will be affected as follows:

Direct influence

A, service degradation or interruption

Maintenance operations often take a long time and occupy a lot of system resources, which may lead to slow system response and service degradation; some maintenance operations can not run online, and unplanned power outages and other failures will also destroy the basic environment of database operation, resulting in system downtime and service interruption.

B, data corruption or loss

Failures such as storage corruption will destroy the information system, the running environment of the database or the database itself, which may lead to the damage or loss of some or even all of the data, which will lead to database downgrade or downtime.

Indirect influence

If the system continues to run based on corrupted data, it may cause users to access the wrong data, which in turn leads to the spread of errors and destroys the data consistency of the whole system.

In view of the above factors that affect the continuous operation of information systems or databases, highly available database products must have the following capabilities:

● in order to deal with planned events, the database must provide the following technical support:

Modify the database table structure online

Modify data storage deployment online

3. Online version upgrade capability

In response to unplanned events, ● 's disaster recovery specification for information security technology information systems is divided into six levels:

Disaster recovery level RTO RPO

Level 1 > 2 days 1-7 days

Level 2 > 24 hours 1-7 days

Level 3 > 12 hours hours-1 day

Level 4 hours-2 days hours-1 day

Level 5 minutes-2 days 0-30min

Level 6 minutes 0

The technical and management support measures for different disaster recovery levels are also specified in the "GB20988-2007 Murt Information Security Technology Information system disaster recovery Specification", as shown in the following table:

As can be seen from the above table, to meet the highest level (level 6) disaster recovery needs, the system needs to have the following capabilities:

Local data backup capability

Real-time backup capability of remote database

Real-time automatic fault detection and switching capability

Support for management and use of multiple network channels

To sum up, when selecting highly available database products, users should focus on the following capabilities, efficiency and reliability of database products:

Modify the database table structure online

Modify data storage deployment online

Modify database instance structure online

Online version upgrade capability

Local data backup capability

Real-time backup capability of remote database

Real-time automatic fault detection and switching capability

Support the management and use of multiple network channels.

As a large-scale general database product for enterprise-level management systems and business systems, Wanli open source GreatDB has built a comprehensive business continuous operation guarantee capability, successfully supported the stable operation of enterprise-level core business applications, including the full-service data center of State Grid, the cloud payment system of a commercial bank, and the China Mobile traffic subsystem, and achieved 99.999% high availability. Details are shown in the following table:

To sum up, database product selection itself is a highly technical task, and the high availability of the database not only depends on the ability of database products, but also depends on the effective high availability scheme designed according to the business and the effective operation and maintenance management of the system.

As a domestic database leader, Wanli open source products have a complete, mature, and verified by a large number of applications of high availability, as well as professional technical consulting and operation and maintenance service support capabilities.

After reading the above, do you have any further understanding of how to select the high availability database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.