is a next-generation relational database that is developed by Alibaba Cloud. PolarDB has three independent engines. This ensures that PolarDB is fully compatible with MySQL and PostgreSQL. It also ensures that PolarDB databases are compatible with the Oracle syntax. A PolarDB cluster supports a maximum storage space of 100 TB and contains a maximum of 16 nodes. PolarDB is suitable for the diverse database application scenarios of enterprises.
PolarDB uses an architecture that allows you to decouple and separate computing and storage. In this case, all compute nodes share the same physical storage. PolarDB allows you to upgrade or downgrade instance specifications within minutes, and to perform fault recovery within seconds. PolarDB ensures global data consistency. It also provides data backup and disaster recovery services free of charge. PolarDB has the benefits of both commercial databases and open source cloud databases. Commercial databases are stable and scalable and have high performance. Open source cloud databases are easy to use and feature rapid iteration.
- Computing and storage decoupling, shared distributed storage
PolarDB decouples computing from storage. This meets your business requirements for auto-scaling. All compute nodes share the same underlying storage PolarStore by using the distributed file system PolarFileSystem. This significantly reduces your storage costs.
- One primary node and multiple read-only nodes, read/write splitting
PolarDB Cluster Edition uses a multi-node cluster architecture. Each PolarDB cluster consists of one primary node (read and write) and at least one read-only node. PolarDB uses the internal proxy layer (PolarProxy) to provide external services for the applications that are connected to cluster endpoints. The proxy forwards the requests from the applications to database nodes. You can use the proxy to implement authentication, data protection, and automatic read/write splitting. The proxy parses SQL statements, sends write requests to the primary node, and evenly distributes read requests to multiple read-only nodes. The proxy allows applications to access PolarDB by using the same method that is used to access a single-node database.
- Large storage capacity
Each cluster provides a maximum storage capacity of 100 TB. You do not need to purchase instances for database sharding due to the storage limit of a single host. This simplifies the development of applications and reduces the workload of operations and maintenance (O&M).
- Shared storage: PolarDB decouples computing from storage. You are charged for only the computing resources when you add read-only nodes to a PolarDB cluster. However, you are charged for both computing and storage resources when you add read-only nodes if you use traditional databases.
- Elastic storage: You do not need to manually specify the storage capacity. The storage capacity is automatically scaled based on the data volume. You need to pay for only the used database storage space on an hourly basis.
- Storage plan: PolarDB provides subscription storage plans. We recommend that you use subscription storage plans if you need to store a large volume of data. Storage plans are more cost-effective than the pay-as-you-go billing method. You are offered higher discounts for storage plans that have larger storage capacities.
- High performance
PolarDB significantly 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. This is implemented based on container virtualization technologies, shared distributed storage, and the architecture where computing is decoupled from storage. The storage capacity is automatically scaled out online. This does not interrupt your services.
- Read consistency
Log sequence numbers (LSNs) are applied to cluster endpoints. This ensures global consistency for read operations and avoids inconsistency that is caused by the replication delay between the primary node and read-only nodes.
- Millisecond-level delay 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 and improves the efficiency and stability of the replication. No delay occurs even if you perform data definition language (DDL) operations on a large table, such as adding indexes or fields.
- Rapid backup
It takes only 30 seconds to perform full database backup regardless of the amount of data. During the backup, the database is not locked. This minimizes the impact of data backup on your applications. Data backup is available 24/7.
Pricing of PolarDB
Usage notes of PolarDB
You can manage PolarDB clusters in the following ways. For example, you can create clusters, databases, and accounts.
- Console: This provides a visualized web interface and simplifies management operations.
- CLI: You can use the command-line interface (CLI) to perform all the operations that are available in the console.
- SDK: You can use the SDK 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:
- Data Management (DMS): You can use DMS to connect to a PolarDB cluster and develop databases on the web interface.
- Client: You can connect to a PolarDB cluster by using general database client tools, such as MySQL-Front and pgAdmin.
Before you purchase and use PolarDB, we recommend that you learn about the following terms:
- Cluster: PolarDB Cluster Edition uses a cluster architecture. A cluster of consists of one primary node and a maximum of 15 read-only nodes.
- Region: A region is a physical area where a data center is deployed. In most cases, PolarDB clusters are deployed in the same region as Elastic Compute Service (ECS) instances to ensure optimal access performance.
- Zone: A zone is a physical area in a region. This area has an independent power supply and network. Zones in the same region have no substantial differences.
- Specification: A specification specifies the resources that are configured for each node, such as 2 CPU cores and 8 GB memory.
- ECS: ECS instances serve as cloud servers. If your PolarDB clusters are deployed in the same region as the ECS instances and you access the PolarDB clusters through an internal network, the PolarDB clusters provide optimal performance. In a typical service access architecture, ECS instances are used in combination with PolarDB clusters.
- ApsaraDB for Redis: ApsaraDB for Redis is a database service that supports in-memory storage and persistent storage. If a large number of service access requests exist, you can use ECS instances, PolarDB clusters, and ApsaraDB for Redis instances in combination to handle more read requests and reduce response time.
- ApsaraDB for MongoDB: ApsaraDB for MongoDB provides stable, reliable, and scalable database services that comply with the MongoDB protocol. If data structures are diverse, you can store structured data in PolarDB and unstructured data in ApsaraDB for MongoDB to meet various storage requirements of your services.
- DTS: You can use Data Transmission Service (DTS) to migrate on-premises databases to PolarDB clusters on the cloud.
- OSS: Object Storage Service (OSS) is a secure, cost-effective, and reliable cloud storage service that allows you to store a large amount of data.