Solution Overview
As customers' businesses grow and their data volume keeps increasing, there are more and more systems and business logic becomes more and more complicated. Sharding is a must for a conventional online database to meet the challenge.
However, the sharded architecture cannot meet the needs of correlation statistics and real-time analysis.
OceanBase's HTAP architecture uses one set of engine, which supports high concurrent online throughput and provides real-time online analysis capabilities for massive data, empowering enterprises to improve their working efficiency and innovate continuously.
Business Challenges
Heterogeneous storage systems
According to various business needs in different scenarios, an enterprise often needs to deploy different databases, such as Oracle, MySQL, DB2, and PostgreSQL. These different systems are complex to operate and maintain, which brings large investments in resource and human power.
High resource costs
The conventional standalone database cannot be horizontally expanded and has to be split into multiple physical instances. This makes the number of instances as many as tens or even thousands, posing a serious challenge to operation and stability. As the number of instances grows, the cost of software licenses rises accordingly.
Resource fragmentation
The utilization of resources, such as CPU and memory, varies in different scenarios. Sometimes resources are not sufficient, but sometimes a large amount of resources are idle. Resources cannot be "pooled" and cannot be managed in a centralized way, leading to a serious waste of resources.
Solution Architecture
- With OceanBase Migration Service (OMS), data can be quickly migrated to OceanBase Database without any downtime, with minimal or even zero modification.
- Resources are isolated on a per tenant basis and data is maintained independently between business modules. The resources of a tenant can be increased or decreased as needed, which is transparent to applications.
- OceanBase's large cluster mode integrates multiple instances into one cluster for unified management, flexible management and scheduling, significantly improving resource utilization.
- With the powerful leader distribution and read/write routing strategies for clusters, OceanBase has proven experience in managing high concurrency systems, which has been adopted in Ant Group for years.
- OceanBase Database comes with a powerful intelligent control console that automatically detects and analyzes typical issues, which significantly improves O&M efficiency.
Benefits
High Compression Ratio
Using LSM-Tree based self-developed storage engine in combination with data encoding and compression algorithms, OceanBase Database achieves a high compression ratio of more than 70% (compared with traditional databases), significantly reducing storage costs.
High Performance
OceanBase Database uses the shared-nothing architecture and distributes leader replicas across nodes to implement multi-node data write, which makes it easy to handle ultra-high concurrency requirements. In addition, it uses the industry-leading table group technology to optimize the processing of a distributed transaction, achieving an execution efficiency as high as that of a single-node transaction.
High Compatibility
OceanBase Database supports Oracle- and MySQL-based tenants in the same cluster. It is compatible with most features of Oracle and MySQL, such as SQL syntaxes, stored procedures, functions, C APIs, and precompilers, minimizing business migration and modification costs.
Multi-tenant
OceanBase Database realizes kernel-level virtualization and isolates resources and data between tenants. Different tenants can share the same cluster, which significantly improves resource utilization and reduces costs.
High Scalability
An ultra-high-throughput OceanBase cluster can be built with common PC servers. The cluster can be flexibly scaled as needed without sharding, so that cost growth is predictably smooth.