All Products
Search
Document Center

ApsaraDB for MyBase:Mechanisms and benefits

Last Updated:Jul 24, 2023

This topic describes the mechanisms and benefits of ApsaraDB for MyBase.

An ApsaraDB for MyBase dedicated cluster consists of multiple hosts. If your hosts use local SSDs, you are charged only for the hosts. You can deploy database instances on the hosts based on your business requirements. You can also specify an overcommit ratio for specific resources to maximize resource utilization and improve cost-effectiveness. You can deploy multiple hosts in an ApsaraDB for MyBase dedicated cluster. A dedicated cluster is a dedicated cloud resource pool. In a resource pool, you can deploy databases that run the MySQL, SQL Server, and PostgreSQL engines. You can also manage your databases in a centralized manner. ApsaraDB for MyBase can help you make full use of your host resources. If specific hosts in a dedicated cluster are idle and other hosts have excessive workloads, you can configure the system to migrate databases from the hosts that have excessive workloads to the idle hosts. This way, loads are balanced among all hosts.

The following section provides a comparison between ApsaraDB for MyBase databases and self-managed databases.

Advantages of ApsaraDB for MyBase databases compared with self-managed databases

In addition to the same features as MySQL, SQL Server, and PostgreSQL databases, ApsaraDB for MyBase databases provide more benefits compared with self-managed databases. For more information, see Advantages of ApsaraDB for MyBase over self-managed databases.

Advantages of ApsaraDB for MyBase hosts

ApsaraDB for MyBase provides the same features as self-managed databases and PaaS databases such as ApsaraDB RDS. In addition, ApsaraDB for MyBase provides powerful host capabilities.

More flexible resource scheduling

You can flexibly schedule database instances among the hosts in a dedicated cluster to maximize the host resource usage. When you create a dedicated cluster, you can set the resource allocation policy to Balanced Allocation or Compact Allocation. The system automatically deploys new database instances in the cluster based on the policy that you specify. After the dedicated cluster runs for a period of time, you can reallocate resources based on your business requirements. For example, you can migrate a database instance from a host to another host in the dedicated cluster or migrate all database instances that are deployed on a host to other hosts.

More permissions

ApsaraDB for MyBase supports more database permissions and OS permissions while ensuring the security of your databases. ApsaraDB for MyBase allows you to run system commands and read and write files to meet your O&M requirements. You can use a bastion host or webshell to connect to a host. This ensures the security of your hosts.

Higher cost-effectiveness

ApsaraDB for MyBase provides improved user experience and helps you reduce costs. Compared with self-managed databases, ApsaraDB for MyBase can help you reduce monthly costs by approximately 50%.

Advanced enterprise-class database services

ApsaraDB for MyBase works with the in-house AliSQL and Tair engines to provide enterprise-class database capabilities such as high stability, high performance, and high availability. ApsaraDB for MyBase also provides backup, restoration, and audit features to achieve faster, more stable, and more secure database capabilities.