PolarDB is a new-generation Cloud-native database that is developed by Alibaba Cloud. This service decouples computing from storage and uses integrated software and hardware. PolarDB is a secure and reliable database service that provides auto scaling, high performance, and mass storage. PolarDB is fully compatible with MySQL 5.6, MySQL 5.7, and MySQL 8.0.

PolarDB uses an architecture that decouples computing from storage. Data of a cluster is shared across all compute nodes. PolarDB allows you to upgrade or downgrade specifications within minutes, and supports disaster recovery within seconds. PolarDB ensures global data consistency and offers data backup and disaster recovery for free. PolarDB has the benefits of both commercial databases and open source cloud databases. Commercial databases are stable, scalable, and high-performance. Open source cloud databases are easy to use and feature rapid iteration. When SysBench is used to test the data inserting performance of PolarDB for MySQL and open source MySQL, the performance of PolarDB for MySQL is up to six time higher than that of open source MySQL in semi-synchronous replication mode. However, the cost of a PolarDB for MySQL database is only 10% that of a commercial database. PolarDB for MySQL is fully compatible with open source MySQL and ApsaraDB RDS for MySQL. You can migrate data from your MySQL databases to PolarDB for MySQL without modifying the code or configurations of your applications.

  • PolarDB uses a compute-storage decoupled architecture and a distributed storage system. Data is shared across all compute nodes.

    PolarDB decouples computing and storage, which enables flexible scalability to meet your business requirements. All compute nodes share the same data by using a distributed file system. This significantly reduces storage costs.

  • Each cluster consists of one primary node and at least one read-only nodes. This allows PolarDB to provide read/write splitting.

    Cluster Edition PolarDB uses multi-node clusters to provide services. Each PolarDB cluster consists of one primary node that handle both read and write operations and at least one read-only node. PolarDB uses PolarProxy to provide services for external applications that are connected through the cluster endpoints. PolarProxy forwards the requests from the applications to database nodes. The proxy can perform authentication and help ensure data security. It implements automatic read/write splitting by parsing SQL statements, sending write requests to the primary node, and evenly distributing read requests across read-only nodes. The proxy allows applications to access PolarDB by using the same method that is used to access a single-node database.

Benefits

You can use PolarDB in the same way that you use MySQL. Compared with traditional databases, PolarDB has the following advantages:
  • Large storage capacity

    The maximum storage capacity of a cluster is 200 TB. You do not need to purchase instances for database sharding due to the storage limit of a single host. This simplifies application development and reduces the O&M workload.

  • Cost-effectiveness
    • Shared storage: PolarDB decouples computing and storage. When you add read-only nodes to a PolarDB cluster, you are charged only for the computing resources of these nodes. In traditional database solutions, you are charged for both computing and storage resources when you add read-only nodes.
    • Elastic storage: You do not need to specify the storage capacity. The storage capacity is automatically scaled based on the data volume. You are charged on an hourly basis only for the storage that you use.
    • Storage plan: PolarDB provides storage plans that are billed based on the subscription billing method. To store a large volume of data, we recommend that you purchase subscription storage plans. Storage plans are more cost-effective than pay-as-you-go storage. You are offered higher discounts for storage plans with larger storage capacities.
  • High performance

    PolarDB improves online transaction processing (OLTP) performance and supports more than 500,000 read requests per second and more than 150,000 write requests per second.

  • Elastic scaling within minutes

    PolarDB supports rapid scaling for computing resources. This is based on container virtualization, shared storage, and compute-storage decoupling. It requires only 5 minutes to add or remove a node. The storage capability is automatically scaled up. During the scale-up process, your services are not interrupted.

  • Read consistency

    PolarDB uses log sequence numbers (LSNs) for cluster endpoints that have read/write splitting enabled. This ensures global consistency for read operations and prevents the inconsistency that is caused by the replication delay between the primary node and read-only nodes.

  • Millisecond-level latency in physical replication

    PolarDB performs physical replication from the primary node to read-only nodes based on redo logs. The physical replication replaces the logical replication that is based on binary logs. This way, the replication efficiency and stability are improved. No delays occur even if you perform DDL operations on a large table, such as adding indexes or fields.

  • Data backup within seconds

    No more than 30 seconds are required to perform a full backup on a database regardless of the data volume of the database. During the backup, the database is not locked. This minimizes the impact of data backup on your applications. You can specify a point in time to back up the database data based on your business requirements.

Pricing

For more information, see Billable items and Purchase a PolarDB cluster.

Usage notes of PolarDB

You can manage PolarDB clusters in the following ways. For example, you can create clusters, databases, and accounts.

  • Console: PolarDB provides a web-based GUI. This way, you can perform operations in an efficient manner.
  • CLI: You can use Alibaba Cloud CLI to perform all the operations that are available in the console.
  • SDK: You can use SDKs to perform all the operations that are available in the console.
  • API: You can call API operations to perform all the operations that are available in the console.

After a PolarDB cluster is created, you can connect to the PolarDB cluster in the following ways:

  • DMS: You can connect to a PolarDB cluster by using Data Management System (DMS) and develop databases on the web interface of DMS. For more information, see Use DMS to connect to a cluster.
  • Client: You can connect to a PolarDB cluster by using common database clients, such as MySQL-Front and HeidiSQL.