Aliyun Product Analysis (4): Aliyun analysis and case study on RDS availability of relational databases __ database

analysis and case of RDS availability of Aliyun relational database

relational database service (relational DB service, RDS) is an open, reliable, flexible and scalable online database service. With multiple security measures and perfect performance monitoring system, and provide a professional database backup, Recovery and optimization program, so that you can focus on application development and business development.

one, two machine hot standby

1, each RDS has two physical nodes for master-slave hot Standby

2, the primary node failure, the second level switch to the standby node

3, service availability of up to 99.95%

4, security protection custom Access IP White list

5, anti-DDoS attacks, SQL injection alarm multiple backup, data reliability up to 99.9999%

second, simple and easy to use

1. Fully compatible MYSQL,SQL server protocol

2. One-key data migration

3, visual Management panel operation

4. Open structured Data ots

Open Structured Data Service (open Table service,ots) is a NoSQL database service built on Aliyun flying Distributed system, which provides storage and real-time access to massive structured data.

Product features OTs to help you easily deal with the storage of massive data and real-time reading and writing on line

5. Mass storage of data

6, support the Internet application for the service of a large amount of end users, such as storage mail, diary, itinerary, user information and so on. It can also be used to store large scale object data, and meet the challenge of data storage brought by mobile Internet and IoT.

7, the table management

Users can create tables, query tables, delete tables, and so on under an instance.

8, the data management

Single-line read-write, multiline read-write, and range-reading of data.

third, the case

1. Schneider Electric

Schneider Electric, as one of the top 500 companies in the world, has grown into a global energy efficiency management expert in its more than 170-year history of continuous pioneering and positive innovation. Schneider Electric has been in China for more than more than 20 years since 1987, when the first joint venture was established in Tianjin. For the storage of massive data and the precision analysis of complex data, it needs to be based on the non relational data, and the elasticity of the hardware expansion is required.

Schneider Electric is based on cloud server, open structured Data Services (OTS), Open Data processing services (ODPS), Development of remote energy Management Systems (REM), for the building, plant, hotel, hospital, telecommunications and other global industry customers to provide flexible expansion, on-demand remote massive energy data collection, storage, Analysis and consulting services. Schneider REM Remote energy management platform utilizes the advantages of Aliyun elasticity calculation, through the smart meter plus gateway model to collect customer energy data, and remote centralized storage in the OTS, using ODPs for computing, to provide the enterprise with energy statistics, energy analysis, energy consumption alarming, power modeling and energy-saving consulting and other remote energy management services , the new Energy Management Service model, which uses energy as service (EaaS), reduces the initial investment of customers, improves the efficiency of energy use and achieves the goal of energy saving and emission reduction.

2, fast enough

Fast enough is the world's leading team file sharing solution Third-party service provider. Provides document collaboration, sharing, and unified management services. Using "Fast enough cloud Library" can build a unified and orderly document knowledge management system, accumulate team intelligence, improve work efficiency. It is urgent to solve the large amount of storage demand so that the server cost is too high, the manual maintenance makes the cost and server stability can not be effectively guaranteed and improved.

It's fast enough. The complete data service and application services are built on the Ali Yunping platform, all Web sites and API services use the Aliyun elasticity calculation, all the user's data will be stored on the Aliyun OSS, the user's index file is stored in the Aliyun ots. It will also launch a service where users can store data on their own OSS platform.

Fast enough Feedback: Aliyun provides a very simple and convenient overall service solution platform, we as a service-oriented cloud storage platform using the Aliyun provided by the basic cloud storage platform, effectively improve the quality of our services, but also greatly reduce the cost of our maintenance, including material and spiritual costs. At the same time, the flexible computation replaces the original hosting host and replaces the MANGODB with OTS, which greatly improves the stability and usability of our overall service.