This article will explain the benefits and reasons to choose ApsaraDB for RDS (Relational Database Service) of Alibaba Cloud.
What is ApsaraDB for RDS (Relational Database Service)?
ApsaraDB for RDS (Relational Database Service) is a stable, reliable, and scalable online database service. Based on the Apsara Distributed File System and the high-performance SSD storage of Alibaba Cloud, ApsaraDB for RDS supports MySQL, SQL Server, PostgreSQL, PPAS (highly compatible with Oracle), and MariaDB database engines. It provides a portfolio of solutions for disaster recovery, backup, restoration, monitoring, and migration to facilitate database operations and maintenance.
ApsaraDB for RDS (Relational Database Service) has significant advantages in cost-effectiveness, availability, reliability, ease of use, and performance. Its cost is one-third of the expense to build databases on ECS instances and one-tenth of the expense to build databases on physical servers.
Why Choose ApsaraDB for RDS (Relational Database Service) of Alibaba Cloud
So people may wonder, why should we choose Alibaba Cloud's ApsaraDB for RDS (Relational Database Service), there are many reasons behind this.
ApsaraDB for RDS has customized database engines
Alibaba Cloud customizes database engines based on the community editions of native MySQL and PostgreSQL to provide more advanced features.
AliSQL is an independent MySQL branch that is developed by Alibaba Cloud. AliSQL provides all of the features that are available in the MySQL Community edition. AliSQL also provides some similar features that you can find in the MySQL Enterprise edition. These similar features include enterprise-grade backup and restoration, thread pool, and parallel query. In addition, AliSQL provides Oracle-compatible features, such as the Sequence engine. ApsaraDB RDS for MySQL with AliSQL provides all the basic features of MySQL and a wide range of advanced features such as enterprise-grade security, backup and restoration, monitoring, performance optimization, and read-only instance.
Alibaba Cloud offers two PostgreSQL-compatible database services that run AliPG: ApsaraDB for RDS and ApsaraDB for MyBase. AliPG is a unified database engine that is developed by Alibaba Cloud. Since its commercial rollout in 2015, AliPG has been running stably for years to process a large number of workloads within Alibaba Group and on the cloud.
ApsaraDB for RDS is cost-effective and easy to use
ApsaraDB for RDS (Relational Database Service) features cost-effectiveness, flexible billing, on-demand configuration changes, easy deployment, high compatibility, and simple operations and maintenance (O&M).
The price of ApsaraDB RDS is one third that of databases built based on ECS instances and one-tenth that of databases built based on servers that you purchase.
- Flexible billing
ApsaraDB RDS supports the subscription and pay-as-you-go billing methods. You can flexibly choose a billing method based on your business requirements to reduce costs.
- On-demand configuration changes
You can purchase an RDS (Relational Database Service) instance with low specifications that can meet your business requirements As the database workloads and data storage increase, you can upgrade the instance specifications. If your business scale becomes small again, you can downgrade the instance specifications to reduce costs.
- Easy deployment
You do not need to purchase database server hardware or software. This significantly reduces costs.
You can create an RDS (Relational Database Service) instance of required specifications within a few minutes in the ApsaraDB RDS console by calling an API operation.
- High compatibility
You can use ApsaraDB RDS databases in the same way as databases that run native engines. This relieves the need to acquire new knowledge.
ApsaraDB RDS is compatible with existing programs and tools. You can use Data Transmission Service (DTS) to quickly migrate data to ApsaraDB RDS. You can also use common data import and export tools to migrate data. The data migration does not require much workforce.
- Easy O&M
Alibaba Cloud is responsible for routine maintenance and management tasks of ApsaraDB RDS instances. This includes troubleshooting hardware and software issues and installing database patches.
You can add, delete, restart, back up, and restore RDS instances in the ApsaraDB RDS console or by calling API operations.
ApsaraDB for RDS has high performance
ApsaraDB RDS uses high-end hardware to provide high-performance database instances. These database instances bring benefits such as parameter optimization, SQL optimization, and high-speed access.
- Parameter optimization
The top database experts at Alibaba Cloud have optimized RDS parameters based on many years of experience in production. Database administrators (DBAs) continuously optimize ApsaraDB RDS throughout its lifecycle to ensure that ApsaraDB RDS instances are running with optimal performance.
- SQL optimization
ApsaraDB RDS locks low-efficiency SQL statements and provides recommendations to help you optimize your business code based on your application scenario.
- High-end hardware
All servers that are used by ApsaraDB RDS have been evaluated by a number of parties to ensure optimal performance and stability.
- High-speed access
If an RDS instance is used with an Elastic Compute Service (ECS) instance that resides in the same region, these instances can communicate over an internal network. This shortens response time and reduces Internet traffic consumption
ApsaraDB for RDS has high availability and disaster tolerance
ApsaraDB for RDS supports multiple disaster tolerance plans to protect you from data loss.
- RDS supports automatic and manual backups. You can set the automatic backup frequency or manually create backups at any time. For more information, see Backup and recovery.
- RDS supports data recovery by time or backup set. You can restore data of any point in time within the log retention period to a new instance, verify the data, and then transfer the data to the original instance. For more information, see Backup and recovery.
ApsaraDB for RDS has high security
ApsaraDB for RDS provides a complete set of security measures to guarantee data security.
If DDoS attacks are detected, the security system of RDS enables traffic cleaning first. If traffic cleaning fails or the attacks reach the black hole threshold, blackhole filtering is triggered.
- Access control
IP addresses can access your RDS instance only after you add them to the whitelists of the RDS instance. IP addresses that are not in the whitelists cannot access the RDS instance. Each account can only view and operate its own databases.
- System security
RDS is protected by multiple firewall layers that block various network attacks to guarantee data security.
Direct login to the RDS server is not allowed. Only the ports required by certain database services are open.
The RDS server cannot initiate an external connection. It can only accept access requests.
In a word, there is no doubt that Alibaba Cloud's ApsaraDB for RDS (Relational Database Service) is the best relational database services on the cloud.
If you want to learn more about RSD from the beginning, please check here
MySQL is one of the most popular open-source databases in the world. As a key component of the open-source software bundle LAMP (Linux, Apache, MySQL, and Perl/PHP/Python), MySQL has been widely applied to different scenarios.