Overview
ApsaraDB for OceanBase has been supporting the Double 11 Shopping Festival for 11 years and is also the only distributed database in the world that has refreshed both TPC-C and TPC-H records. OceanBase Database adopts an independently developed integrated architecture, which encompasses both the scalability of a distributed architecture and the performance advantage of a centralized architecture and supports hybrid transaction/analytical processing (HTAP) with one engine.
Benefits
-
Unparalleled Performance
Empower mission-critical and performance-intensive applications across both OLTP and OLAP scenarios. Experience ultimate performance with 707,351,007 transactions per minute on the TPC-C benchmark and 15,265,305 queries per hour on the TPC-H benchmark with 30,000GB of data.
-
Elastic & Transparent Scalability
Effortlessly scale horizontally, vertically, and at the tenant level to handle unexpected workloads. Achieve seamless, linear performance growth without downtime or application changes, ensuring quick and reliable responses to high-concurrency, performance-intensive workloads.
-
Always-on High Availability
Achieve RPO = 0 and industry-leading RTO < 8 seconds, effectively eliminating downtime, ensuring your mission-critical workload remains always available and reliable, and preventing costly and complex disruptions and data loss.
-
Cost-Effectiveness at Scale
Reduce storage costs by 70%-90% with advanced compression technology. Achieve database consolidation with multi-tenancy, cutting costs and boosting efficiency. Improve resource utilization and lower Total Cost of Ownership (TCO) by over 30% in large-scale scenarios.
Features
Multi-workload, for your Real-Time Analytics
ApsaraDB for OceanBase can be deployed across zones and regions. If a fault occurs, your workloads are switched to a healthy zone based on the specified priority. You can select zones based on your business requirements.
Zone-Disaster Recovery
You can deploy ApsaraDB for OceanBase across three zones in a single region. In this scenario, you can achieve a Recovery Point Objective (RPO) of zero and a Recovery Time Objective (RTO) of less than 30 seconds. Automatic failover is triggered when a fault occurs. This deployment solution helps you ensure service continuity when a hardware fault or zone disaster occurs.
Geo-Disaster Recovery
You can deploy ApsaraDB for OceanBase across five zones in three regions. In this scenario, you can achieve an RPO of zero and an RTO of less than 30 seconds. Automatic failover is triggered when a fault occurs. This deployment solution helps you ensure service continuity when a hardware fault, zone disaster, or geo-disaster occurs.
Multitenancy to Meet Business Requirements at Minimal Cost
ApsaraDB for OceanBase allows you to select the database engine for a cluster.
Oracle
ApsaraDB for OceanBase is compatible with the Oracle syntax and stored procedures. Oracle-based applications can be migrated seamlessly or with minimal modifications.
MySQL
ApsaraDB for OceanBase is compatible with the MySQL 5.6 syntax and client. You can use ApsaraDB for OceanBase the same way as you use MySQL. ApsaraDB for OceanBase provides financial-grade database capabilities such as scalability and high availability.
Financial-grade Features
ApsaraDB for OceanBase provides financial-grade features such as recycle bin and flashback query to ensure service availability and fault tolerance.
Flashback Query
ApsaraDB for OceanBase provides the flashback query feature for DML-related misoperations. This feature allows you to query previous data values or restore a table or row to a previous time point.
Recycle bin
ApsaraDB for OceanBase provides the recycle bin feature for DDL-related misoperations. This feature allows you to restore data in case you perform the DROP TABLE or DROP DATABASE operation.
Execution Plan Evolution
Only verified execution plans can be enabled. When a new plan is available for the target SQL statement due to various reasons such as changes in statistics, the new plan is not immediately enabled. The new plan must be verified by a small volume of data inside the OBServer and must have better performance than previous plans before it can be enabled.
Customer Success Stories
"ApsaraDB for OceanBase provides perfect support for the read and write scenarios of Taobao favorites. The promotions of Taobao have tested the concurrent processing capabilities of ApsaraDB for OceanBase. ApsaraDB for OceanBase meets the business requirements of Taobao favorites in terms of stability, high throughput, excellent performance, and low cost."
Steven Zhong | VP, Hotel and Owner Solutions, IHG Greater China
Taobao.com is one of the world’s largest e-commerce websites. It currently has nearly 500 million registered users and has more than 60 million regular visitors every day. The number of products online per day has exceeded 800 million, and an average of 48,000 products are sold per minute.
"ApsaraDB for OceanBase is tested by the challenges of the 11.11 shopping festival for supporting the transactions, payments, and accounts of Alipay. ApsaraDB for OceanBase helps Alipay deploy a high availability architecture across data centers and regions. ApsaraDB for OceanBase also plays an important role in daily operation, emergency drill, and disaster recovery."
- Cheng Li, CTO, Ant Financial
Alipay is a leading third-party payment platform in China. It is dedicated to providing fast, easy, and safe online payment solutions. During the Double 11 Shopping Festival in 2019, the maximum number of transactions made on Alipay reached 544,000 per second.
"After the business is migrated to OceanBase Database, the required storage space is reduced by 70% with the high data compression ratio of OceanBase Database. The three-zone high availability architecture of OceanBase Cloud ensures business continuity upon failures in any single zone. The large-cluster mode of OceanBase Database greatly improves resource utilization. After the business is migrated to OceanBase Database, , the resource costs of the database are reduced by more than 40% on average. OceanBase Database greatly improves the O&M efficiency of database administrators based on its kernel-based online DDL and intelligent diagnostics features and the cloud console."
Steven Zhong | VP, Hotel and Owner Solutions, IHG Greater China
GCash is a Micro Payment Platform launched by the Philippine telecommunications company Globe Telecom. It is widely known as the Philippine version of Alipay. As of 2019, GCash has 20 million users and more than 63,000 merchant partners across the country.
"Since its migration from MySQL to OceanBase Database in 2019, DANA no longer suffers from capacity and availability issues, being able to fully cope with its rapid business development. OceanBase Database now supports tens of millions of users of DANA. The year 2020 has witnessed zero database failures and zero data loss, as well as an overall business system availability of over 99.99%. The third IDC under construction is built in the public cloud, which truly realizes a tri-IDC hybrid cloud deployment, further improving the disaster recovery capability and service availability. With a comprehensive OceanBase Database training program based on theory and practice, DANA has developed a local team of international OceanBase Database administrators."
Steven Zhong | VP, Hotel and Owner Solutions, IHG Greater China
DANA Wallet is a digital wallet jointly launched by Ant Financial and Indonesia Emtek Group on March 22, 2018 in Indonesia. Known as the Indonesian Alipay, it enables users to safely make cashless and cardless payments. DANA Wallet will provide digital payment and financial services to more than 50 million users of BBM, the second -argest chat tool in Indonesia.
"The native high-availability capability of OceanBase Database helps achieve rapid business recovery from downtime and network exceptions. With the multi-tenancy multi-server architecture of OceanBase Database, excellent capacity isolation is implemented between different businesses. This provides an effective guarantee for large scalability during promotion campaigns and stability for key businesses."
Steven Zhong | VP, Hotel and Owner Solutions, IHG Greater China
Launched in 2009, Easypaisa is the first mobile payment platform in Pakistan. Easypaisa owns the only GSMA mobile currency certificate in the country and has about 20 million users. It is now the unparalleled largest digital wallet in Pakistan.
Related Resources
High-performance database
Outstanding performance during TPC-C benchmark test
All database kernel developers want to take on the challenge of the TPC-C benchmark. However, it is never easy to address all of the challenges that are presented in complex benchmarks like TPC-C. This also happened to be the very first time that ApsaraDB for OceanBase took on the TPC-C benchmark. To beat the TPC-C benchmark test, the research and development team of ApsaraDB for OceanBase prepared for more than a year.
High-availability database
High availability and disaster recovery
The primary requirement for high availability of databases is automatic failover with zero data loss. If automatic failover is enabled, services can be recovered in the shortest time. Recovery Time Objective (RTO) is used to measure the recovery time. Recovery Point Objective (RPO) is the metric for data loss after service recovery. RTO and RPO are important metrics to evaluate a high availability solution.
High-throughput database
Alipay technology during the Double 11
During the Double 11 in 2019, CNY 10 billion (USD 1.4 billion) in transactions were completed in 1 minute and 36 seconds, CNY 30 billion (USD 4.2 billion) in 5 minutes and 25 seconds, and CNY 50 billion (USD 7.1 billion) in less than 13 minutes. The Double 11 has allowed Alibaba Group to lead the way in terms of research and development. Alibaba Group has advanced the level of computing capabilities and related technologies by approximately 20 years.
Tenant
Create an account
When you create an account under a MySQL tenant, you can associate the account with multiple databases. When you create an account under an Oracle tenant, the account has only the privileges on the corresponding schema.
Database
Create a database
You can create different databases for independent tenants to store data.
Scenarios
Data Migration
Data Migration to a Distributed Database
ApsaraDB for OceanBase provides an end-to-end data migration service for enterprises to migrate applications and data to ApsaraDB for OceanBase. This solution aims to bring the benefits of distributed databases to more enterprises.
Assessment of Application Changes
The data migration service of ApsaraDB for OceanBase helps you assess the impact of migration on your databases. For example, you can identify incompatible SQL statements and schemas to prevent risks of project delays.
Innovation
Changing the database of a business system poses significant challenges and risks to data accuracy, performance, and stability. The data migration service of ApsaraDB for OceanBase is integrated with a multi-level data verification scheme that helps you verify the performance and compatibility of databases. You can detect data exceptions within seconds. ApsaraDB for OceanBase also provides traffic capture and playback capabilities.
High Availability and Disaster Recovery
Unattended and Self-Adaptive Disaster Recovery
ApsaraDB for OceanBase provides a customizable solution for high availability and disaster recovery. You can deploy ApsaraDB for OceanBase based on the application scenarios and your business requirements for zones and regions. You can implement financial-grade high availability by using basic hardware.
Flexible High Availability
ApsaraDB for OceanBase can be deployed across zones and regions. It allows you to customize the disaster recovery capability based on your business scenarios. ApsaraDB for OceanBase uses the Paxos protocol to ensure the consistency of data replicas that are deployed across different regions or zones. If a zone or region fails, ApsaraDB for OceanBase switches your workloads to a healthy node where a data replica resides.
High Availability Across Regions and Unit-based Redundancy
If you deploy ApsaraDB for OceanBase across regions, you can deploy the master nodes of different tenants in different regions. With OBProxy, you can modularize your business systems and realize high availability across regions. Among users of ApsaraDB for OceanBase, MYbank and Paytm adopt similar architectures. Module-based distribution and redundancy provide support for capacity scaling and region-level disaster recovery.
Asynchronous Replication
ApsaraDB for OceanBase asynchronously replicates data from the active cluster to the standby cluster. The active and standby clusters are independent of each other. This prevents failures from being transferred to the standby cluster when the active cluster encounters an error.
Scale-out
Similar Experience to Using Standalone Databases
ApsaraDB for OceanBase is a native distributed relational database that can be used in the same way as a standalone relational database. You can improve the computing and storage capacity by increasing the number of nodes. In a distributed system or sharded architecture, global indexes and global consistency are usually compromised. Therefore, it requires extra costs to address these needs. To solve this issue, ApsaraDB for OceanBase provides capabilities such as snapshot isolation levels and multi-version concurrency control (MVCC) by using global timestamps and global indexes.
Distributed Transactions
In ApsaraDB for OceanBase, a table is split into many small partitions and distributed across multiple nodes for storage based on a specific policy. All transactions are executed as distributed transactions. Global timestamps are used to ensure that the distributed transactions in an ApsaraDB for OceanBase cluster meet the requirements of atomicity, consistency, isolation, and durability (ACID) and transaction isolation levels.
Global Indexes
ApsaraDB for OceanBase supports partial and global indexes within a partition. Partial indexes have lower maintenance costs and higher execution efficiency. Global indexes can help avoid partition scans and table scans that are required in traditional sharded architectures. Global uniqueness constraints can help avoid complex architectures introduced by various uniqueness requirements. ApsaraDB for OceanBase optimizes the performance of global indexes by using the two-phase commit mechanism and non-covered queries. The optimization ensures that global indexes can meet the requirements of most core scenarios.
Global Consistency
Transaction Integrity Across Databases
ApsaraDB for OceanBase provides a global consistency solution that does not rely on specific hardware. ApsaraDB for OceanBase provides capabilities such as snapshot isolation levels and multi-version concurrency control (MVCC) to ensure global consistency of snapshot versions.
Traditional architectures for table sharding and database sharding do not support global and unified snapshot management.
Transaction Integrity
ApsaraDB for OceanBase uses Global Timestamp Service (GTS) to ensure consistency of snapshot versions. All transactions obtain snapshot versions from GTS regardless of the source servers. The version numbers of snapshots increase over time. The timestamps of all snapshots are consistent with the real world chronological order. ApsaraDB for OceanBase assigns global timestamps by tenant.
Upgraded Support For You
1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Tickets.
1 on 1 Presale Consultation
24/7 Technical Support
6 Free Tickets per Quarter
