# oceanbase/oceanbase

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/oceanbase-oceanbase).**

9,980 stars · 1,871 forks · C++ · other

## Links

- GitHub: https://github.com/oceanbase/oceanbase
- Homepage: https://en.oceanbase.com
- awesome-repositories: https://awesome-repositories.com/repository/oceanbase-oceanbase.md

## Topics

`analytics` `cloud-native` `database` `distributed-database` `fulltext` `fulltext-search` `fulltext-support` `hacktoberfest` `htap` `mysql` `mysql-compatibility` `oceanbase` `olap` `oltp` `paxos` `scalable` `vector` `vector-database` `vector-search` `vectors`

## Description

OceanBase is a distributed SQL database designed for high availability and strong consistency across multiple nodes and regions. It functions as a hybrid transactional and analytical processing engine, allowing real-time analytics and transactions to execute on a single data copy. The system also serves as a vector database engine for indexing and querying vector data to power semantic search and recommendation systems.

The platform features native compatibility layers for MySQL and Oracle, enabling the migration of legacy workloads without rewriting SQL code. It utilizes a Paxos-based distributed store for synchronous replication and implements a multi-tenant architecture that isolates CPU, memory, and I/O resources for different tenants within a single cluster.

The system covers a broad range of capabilities, including horizontal storage scaling, distributed transaction management, and hybrid row-columnar storage. It provides tools for cluster orchestration, automated load balancing via log-stream migration, and disaster resilience through multi-zone replication and automated failover.

Deployment and management are supported through a Kubernetes operator and a web monitoring dashboard.

## Tags

### Data & Databases

- [Distributed SQL Databases](https://awesome-repositories.com/f/data-databases/distributed-sql-databases.md) — Functions as a relational database engine designed to scale horizontally while maintaining transactional consistency.
- [Hybrid Transactional Analytical Processing Systems](https://awesome-repositories.com/f/data-databases/hybrid-transactional-analytical-processing-systems.md) — Functions as a hybrid transactional and analytical processing engine, allowing real-time analytics and transactions on a single data copy. ([source](https://cdn.jsdelivr.net/gh/oceanbase/oceanbase@develop/README.md))
- [Hybrid Storage Formats](https://awesome-repositories.com/f/data-databases/columnar-storage-engines/hybrid-storage-formats.md) — Optimizes for both transactions and analytics by storing data in both row and column formats within the same system.
- [Cross-Zone Data Distribution](https://awesome-repositories.com/f/data-databases/cross-zone-data-distribution.md) — Replicates data across multiple logical zones using a consensus protocol to ensure high availability. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))
- [Database Compatibility Layers](https://awesome-repositories.com/f/data-databases/database-compatibility-layers.md) — Provides native compatibility layers for MySQL and Oracle to migrate legacy workloads without rewriting SQL code.
- [Strongly Consistent Data Stores](https://awesome-repositories.com/f/data-databases/database-management-systems/database-architectures/strongly-consistent-data-stores.md) — Maintains strong consistency across distributed replicas using a Paxos-based leader-follower replication model. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))
- [Disaster Recovery Solutions](https://awesome-repositories.com/f/data-databases/disaster-recovery-solutions.md) — Ensures business continuity via synchronous replication and automated failover across geographically distributed infrastructure. ([source](https://en.oceanbase.com/product/opensource))
- [Distributed Consensus Protocols](https://awesome-repositories.com/f/data-databases/distributed-consensus-protocols.md) — Uses the Paxos consensus protocol to maintain strong data consistency across distributed replicas.
- [Distributed Consensus Stores](https://awesome-repositories.com/f/data-databases/distributed-consensus-stores.md) — Uses a Paxos-based distributed store for synchronous replication and high availability across data zones.
- [Distributed Transaction Processing](https://awesome-repositories.com/f/data-databases/distributed-transaction-processing.md) — Maintains ACID consistency across a distributed SQL environment to ensure data integrity for critical workloads. ([source](https://en.oceanbase.com/))
- [Horizontal Database Scaling](https://awesome-repositories.com/f/data-databases/horizontal-database-scaling.md) — Expands a single cluster across thousands of nodes to manage petabytes of data and trillions of records. ([source](https://cdn.jsdelivr.net/gh/oceanbase/oceanbase@develop/README.md))
- [Horizontal Scaling](https://awesome-repositories.com/f/data-databases/horizontal-scaling.md) — Increases read and write capacity by automatically balancing and routing data across new nodes. ([source](https://en.oceanbase.com/))
- [HTAP Databases](https://awesome-repositories.com/f/data-databases/htap-databases.md) — A hybrid system that executes real-time analytics and transactions on a single data copy.
- [Multi-Tenant Data Management](https://awesome-repositories.com/f/data-databases/multi-tenant-data-management.md) — Provides administrative interfaces for creating tenants, managing resource units and isolating data. ([source](https://oceanbase.github.io/ob-operator))
- [Multi-Tenant Resource Isolation](https://awesome-repositories.com/f/data-databases/multi-tenant-resource-isolation.md) — Implements a multi-tenant architecture that isolates CPU, memory, and I/O resources for different tenants within a single cluster.
- [MySQL Compatibility](https://awesome-repositories.com/f/data-databases/mysql-integrations/mysql-compatibility.md) — Supports MySQL compatibility layers to migrate legacy workloads without extensive code rewrites.
- [Real-Time Analytics](https://awesome-repositories.com/f/data-databases/real-time-analytics.md) — Executes complex reporting and live dashboards directly on transactional data with low latency. ([source](https://en.oceanbase.com/))
- [Vector Databases](https://awesome-repositories.com/f/data-databases/vector-databases.md) — Provides a storage engine capable of indexing and querying high-dimensional vector embeddings for semantic search.
- [Vector Search](https://awesome-repositories.com/f/data-databases/vector-search.md) — Indexes and queries high-dimensional vector data to enable semantic search and recommendation systems.
- [Standby Management](https://awesome-repositories.com/f/data-databases/backup-and-recovery/standby-management.md) — Supports creating standby tenants, restoring standbys from backups, and executing primary-standby switchovers. ([source](https://oceanbase.github.io/ob-operator))
- [Columnar Storage Engines](https://awesome-repositories.com/f/data-databases/columnar-storage-engines.md) — Lowers costs and resource usage through a hybrid row-columnar storage engine. ([source](https://en.oceanbase.com/product/opensource))
- [Cluster Request Routing](https://awesome-repositories.com/f/data-databases/connection-managers/cluster-request-routing.md) — Implements mechanisms for directing SQL requests to specific nodes based on data distribution across the cluster. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))
- [Data Compression Algorithms](https://awesome-repositories.com/f/data-databases/data-compression-algorithms.md) — Reduces storage footprint and accelerates queries using dictionary, run-length, and differential compression. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))
- [Replica Recovery](https://awesome-repositories.com/f/data-databases/data-management/backup-recovery-utilities/data-recovery/replica-recovery.md) — Performs single-node or cluster-wide recovery and automated re-synchronization of data to replacement nodes. ([source](https://oceanbase.github.io/ob-operator))
- [Query Routing](https://awesome-repositories.com/f/data-databases/distributed-sql-databases/query-routing.md) — Automatically resolves data distribution and shard locations to route queries to the appropriate server.
- [Traffic Scaling Strategies](https://awesome-repositories.com/f/data-databases/horizontal-database-scaling/resource-scaling-strategies/traffic-scaling-strategies.md) — Implements distributed architecture to maintain predictable performance and data consistency during traffic surges. ([source](https://en.oceanbase.com/product/opensource))
- [Hybrid Search](https://awesome-repositories.com/f/data-databases/hybrid-search.md) — Combines vector similarity with structured metadata and full-text lookups in a single request. ([source](https://en.oceanbase.com/))
- [Hybrid Vector-Keyword Indexing](https://awesome-repositories.com/f/data-databases/hybrid-vector-keyword-indexing.md) — Combines structured data with vector embeddings in a single storage engine to enable semantic search.
- [Log-Stream Balancing](https://awesome-repositories.com/f/data-databases/log-stream-balancing.md) — Scales capacity and redistributes load by splitting and migrating data log streams between cluster nodes.
- [Table-Level Storage Formats](https://awesome-repositories.com/f/data-databases/storage-configuration/table-level-storage-formats.md) — Allows defining row, column, or hybrid storage formats at the table level to apply schema changes without downtime. ([source](https://en.oceanbase.com/))

### DevOps & Infrastructure

- [Multi-Region Replication](https://awesome-repositories.com/f/devops-infrastructure/high-availability-clusters/multi-region-replication.md) — Replicates data across different physical zones in real-time to ensure zero data loss during regional failures.
- [High Availability Services](https://awesome-repositories.com/f/devops-infrastructure/high-availability-services.md) — Maintains continuous service uptime using automated failover and zero data loss across racks and regions. ([source](https://en.oceanbase.com/))
- [Multi-Cloud Deployments](https://awesome-repositories.com/f/devops-infrastructure/cloud-deployment/multi-cloud-deployments.md) — Distributes data across different regions and cloud providers to minimize latency and maintain data sovereignty. ([source](https://en.oceanbase.com/))
- [Database Cluster Orchestration](https://awesome-repositories.com/f/devops-infrastructure/database-cluster-orchestration.md) — Enables bootstrapping clusters, adjusting topology, scaling nodes, and modifying system parameters to maintain cluster health. ([source](https://oceanbase.github.io/ob-operator))
- [High Availability Systems](https://awesome-repositories.com/f/devops-infrastructure/high-availability-systems.md) — Implements architectural patterns to ensure continuous service availability and fault tolerance across distributed nodes. ([source](https://cdn.jsdelivr.net/gh/oceanbase/oceanbase@develop/README.md))
- [Data](https://awesome-repositories.com/f/devops-infrastructure/load-balancing/data.md) — Automatically rebalances data and service loads by splitting, merging, and migrating log streams during scaling. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))

### Security & Cryptography

- [Multi-Tenant Isolation](https://awesome-repositories.com/f/security-cryptography/multi-tenant-isolation.md) — Separates CPU, memory, and I/O resources for each tenant using a native multitenancy architecture. ([source](https://en.oceanbase.com/docs/community-observer-en-10000000000829641))
- [Database Access Controls](https://awesome-repositories.com/f/security-cryptography/granular-access-controls/database-access-controls.md) — Provides end-to-end encryption and granular access controls to protect database assets and meet regulatory requirements. ([source](https://en.oceanbase.com/product/opensource))

### Software Engineering & Architecture

- [Compatibility Layers](https://awesome-repositories.com/f/software-engineering-architecture/compatibility-layers.md) — Provides compatibility layers for Oracle and MySQL dialects to allow legacy applications to run without SQL rewrites.
- [Database Dialect Migration](https://awesome-repositories.com/f/software-engineering-architecture/legacy-migration-strategies/database-dialect-migration.md) — Provides compatibility layers for Oracle and MySQL to transition existing database applications without extensive code rewrites. ([source](https://en.oceanbase.com/product/opensource))

### Part of an Awesome List

- [Kubernetes Operators](https://awesome-repositories.com/f/awesome-lists/devops/kubernetes-operators.md) — Provides a dedicated Kubernetes operator to automate the provisioning and management of database clusters. ([source](https://cdn.jsdelivr.net/gh/oceanbase/oceanbase@develop/README.md))