When the database meets cloud computing network billion cloud solution

The database meets cloud computing network billion cloud solution

[Date: 2016-07-21]

Source: Zhongguancun Online

[Font: Big Small]

There is a long-standing need for data management. In 1950, the Remington Rand Corporation launched a tape drive on the "Univac I" computer, which can enter hundreds of records per second. In the 60 's, the computer began to be widely quoted in data management, the traditional file system can not meet the needs of people, the unified management and sharing of data database management system emerged. Today, data is no longer simple to store and manage, and cloud-based databases are deriving more and more gameplay and application scenarios.

Database meets cloud computing network billion cloud solution (image from Itproportal)

Database can be said to be a long-term storage in the computer, organized, shared, unified management of the is a data structure to store and manage the computer software system. When there are several databases in a system that are completely separate from each other, the system contains a "database collection".

According to the development of data model, it can be divided into three stages: first generation network, hierarchical database system, second generation relational database system, third generation database system with object-oriented model as main feature. With the rapid growth of structured and unstructured data, each industry is storing capacity for these deltas and discovering new scenarios beyond traditional databases.

In the era of cloud computing, the traditional IT architecture is undergoing a transformational period. IDC, a market research agency, said IT infrastructure deployment spending increased 24.6% to $32.8 billion in the 2015 cloud environment. At the same time, companies are actively seeking convenient, efficient, low-cost solutions to advance the cloud strategy.

With cloud databases, businesses can deliver on-demand, on-demand scalability, high availability, and storage consolidation. By deploying databases to the cloud, you can support and ensure cloud business applications as part of your SaaS deployment by simplifying the available information across network-connected business processes. For suppliers, they can host databases in the public cloud, and cloud providers can help customers with their database expansion through a range of capabilities.

Network billion hing Cloud database MySQL and tdsql features

Cloud Database (CDB) is a relational database cloud service provided by network billion cloud, based on Pci-e SSD, supporting MySQL, SQL Server, Tdsql (compatible mariadb) engine. CDB has a variety of storage media types, including hardware acceleration capabilities for enterprise-class solid-state drives (SSDs) and related controllers based on high-speed pciexpress architectures, designed for high-performance OLTP applications, QPS up to 37000 high-IO versions, and low-cost general SSD storage media. Large cost-effective capacity.

It is understood that CDB provides the master-slave data in real-time hot standby, to ensure online data security, multi-backup mechanism to save multiple days of data, improve the data reliability in the event of disaster. Meanwhile, it also supports real-time dual-machine hot standby, non-destructive recovery in 3rd, cold standby data dump on 5th, auto-detection of outage and automatic fault migration. Through multi-dimensional monitoring and custom resource threshold alarms, users can query analysis reports and SQL full run reports. In terms of the cost, the user can choose the accurate to the second granularity according to the business situation the quantity billing mode, or the annual subscription mode.

Specifically, CDB is fully compatible with the MySQL protocol and is suitable for a relational database-oriented scenario where the cloud database operations team is fully responsible for MySQL installation, deployment, version update, and troubleshooting, without customer action. Master and slave switch, fault processing and data migration, is also transparent to the user, the IP port remains unchanged.

High IO version features

CDB for MySQL supports mounting read-only instances, supporting a master multi-slave architecture, and the ability to load-balance the RO group to simplify the process of pressure distribution between slave machines. The use of the process provides command-line and web two ways to manage the cloud database, and supports batch database management, permission settings, and SQL import. In addition, it supports extranet access and VPC networks, which connect cloud databases to IDC, private cloud, or other computing resources for hybrid cloud environments.

As for the cloud Database Tdsql, is located in the OLTP scenario high security enterprise-level cloud database, compatible with MySQL syntax, with thread pool, audit, remote disaster recovery and other advanced features, in a number of projects through the Silver Supervisor, security supervision of reliability, information safety inspection, with cloud database scalability, Simplicity and cost-effectiveness.

Tdsql Distributed cluster architecture

The Tdsql is based on high security, high availability, and strong consistency of main and standby data, which supports more than 90% of the billing business of Hing Cloud Network. The service provides 99.99999% data reliability, as well as a variety of value-added security capabilities such as anti-theft, anti-injection, tamper-proofing, and audit traceability. In terms of usability, Tdsql adopts cluster or distributed cluster deployment, which has redundancy disaster-tolerant feature, and single-machine failure will not affect the stability of the whole cluster. Has (highly available scheduling scheme) to support cross-room, dual-line network deployment, to avoid network failure resulting in the entire system is not available.

  Network billion Xingyun in SQL Server, etc. also have layout

In addition to MySQL and Tdsql, net billion cloud certainly will not forget SQL Server. CDB for SQL Server will help users deploy versions of SQL Server (R2 and 2012) that already contain genuine licensing, providing scenarios for deploying backup, recovery, monitoring, migration, and more.

CDB for SQL Server scenario schema

Xing Yun Network said, CDB for SQL Server default provides a primary one mirror configuration, with log and physical file backup, can be 30 minutes through the backup automatically recover the host, the availability of up to 99.95%; PCI-E SSD Configuration Storage maximizes SQL Server read and write performance, 30% higher than self-built performance in the same environment, provides a variety of monitoring and alerting, performance optimization analysis, flexible on-demand purchase, compared to the purchase of server self-built, cost-effective.

In addition, the service enables developers to configure and deploy SQL Server Management Studio, which can be used and managed by the visual management interface to reduce the management system. NET architecture, the time and cost of the Visual Studio Team system, provides a variety of value-added services.

When it comes to open source databases, POSTGRESQL,CDB is compatible with this. NET billion Xingyun will be responsible for the vast majority of complex and time-consuming management tasks, such as PostgreSQL software installation, storage management, highly available replication, and data backup for disaster recovery.

In the process, the network billion cloud provides PostgreSQL's key operational indicators, including CPU utilization, storage capacity usage, I/O activity and other performance monitoring data, users can be viewed in the central administration, and at no additional cost, quickly locate and solve the problem. Custom indicator alarm thresholds, which do not require monitoring at all times, can be used to keep an eye out for anomalies via email or SMS.

When the user's data serious problem, can quickly recover to a normal point in time, to deal with upgrade failure or disaster recovery, etc., NET billion Xingyun PostgreSQL default save 7th two copies, and in the early morning to achieve full backup, every five minutes backup log file Xlog, The user can restore a DB instance to a state of any one second within 7 days, up to the first five minutes, with the fallback feature.

In addition, in order to meet the continuous development of the business data storage needs, network billion cloud support maximum storage to 6TB, the maximum memory 480GB specification model, users can through the network billion Hing Cloud Management Center, to achieve a key upgrade to the target specifications. The upgraded instance inherits the IP and all configuration of the original instance, and during the upgrade process, only 1 seconds of Flash is generated during the switchover process, without long downtime, the business resiliency needs can be met at any time.

It is worth mentioning that the network billion Xingyun also has a MySQL-based high-performance physical host data storage Service "Blackstone database", providing a complete monitoring, operation and maintenance services for the context-oriented database scenario. Not only that, net billion Xingyun also in MongoDB, HBase, dcdb and other fields have layout.

Blackstone database application in the game industry product architecture

Distributed Cloud Database (DCDB for tdsql) product architecture

Among them, NoSQL is fully compatible with MONGODB protocol, suitable for the scenario of document type or distributed NoSQL database; The cloud database hbase is fully compatible with the HBase protocol, which is suitable for large-scale, massive data storage and distributed computing scenarios; DCDB for Tdsql compatible with MySQL protocol and syntax, support automatic horizontal split high-performance distributed database-that is, the business is displayed as a complete logical table, the data is evenly split into multiple shards, each shard by default with a master and standby architecture, providing disaster preparedness, recovery, monitoring, non-stop expansion and other complete solutions, For terabytes or petabytes of massive data scenarios.

When the database meets cloud computing network billion cloud solution