OceanBase enterprise-level open source distributed database

table of Contents

Technical characteristics

Easy to use

Version comparison

Prerequisites


Official website address: https://open.oceanbase.com/

Quick start: https://open.oceanbase.com/quickStart

OceanBase Community Edition is an open source distributed HTAP (Hybrid Transactional/Analytical Processing) database management system with a native distributed architecture, supporting financial-level high availability, transparent horizontal expansion, distributed transactions, multi-tenancy, and syntax compatibility, and other enterprise-level features . The OceanBase core has passed the test of large-scale commercial scenarios, has served many industry customers, and is now continuing to build core technology competitiveness in the future.

Technical characteristics

High availability

Single server failure can be self-healed, supports cross-city multi-computer room disaster recovery, zero data loss, and can meet the 6-level disaster recovery standard of the financial industry (RPO=0, RTO<=30 seconds).

Linear expansion

Transparent expansion, automatic load balancing, application transparent horizontal expansion, cluster size can exceed 1500 nodes, data volume can reach PB level, single table records trillion rows.

MySQL is highly compatible

Compatible with MySQL protocol, syntax and usage habits, the MySQL client tool can directly access OceanBase.

Standard (RPO=0, RTO<=30 seconds).

high performance

Quasi-memory-level data change operation, original coding compression technology, combined with linear horizontal expansion, TPC-C test reached 707 million tpmC.

low cost

Using PC servers and low-end SSDs, high storage compression rate reduces storage costs, high performance reduces computing costs, and multi-tenant mixed units make full use of system resources.

Multi-tenant

Native support for multi-tenant architecture, the same database cluster can provide services for multiple independent businesses, data isolation between tenants, reduce deployment and operation and maintenance costs.

Easy to use

Environmental preparation

Preparations

  • Refer to "Resource Preparation" to ensure that your software and hardware environment meets the requirements
  • Download and install the OBD database deployment tool
  • Download OceanBase database

Deployment and installation

Deploy and Install

  • Download the corresponding configuration file template from GitHub.
  • Add user password information at the top of the configuration file.
  • Modify the IP address in the configuration file.
  • Modify the <devname> variable and <home_path> in the configuration file.

Start OceanBase

Start OceanBase

  • Deploy the cluster
  • Start the cluster
  • View cluster status
  • Connect to the database and start the journey of OceanBase

Version comparison

Community Edition

Open source distributed relational database

icon

Natively distributed

icon

Flexible horizontal expansion

icon

Automatic failure recovery

icon

Multi-tenant management

icon

MySQL syntax compatible

Cloud Service Edition

Purchasing on demand, professional operation and maintenance

icon

Enterprise version full features

icon

Mature infrastructure

icon

Professional operation and maintenance personnel

icon

Flexible procurement model

icon

Rapid deployment, unlimited expansion

icon

Expert advisory services

icon

7 x 24 manual service

Enterprise Edition

Comprehensive upgrade of functions and services

icon

Oracle syntax compatibility

icon

Advanced performance optimization

icon

Graphical cluster management and control platform

icon

Exclusive development tools

icon

High availability enhancement

icon

security audit

icon

Expert service team

icon

7 x 24 after-sales service system

Prerequisites

Before installing the OceanBase database, make sure your machine can connect to the public network. And your software and hardware environment meets the following requirements:

projectdescription
systemRed Hat Enterprise Linux Server 7.x version (kernel Linux 3.10.0 version and above)
CentOS Linux 7.x version (kernel Linux 3.10.0 version and above)
RAMAt least 16G  
recommended 64G and above
Disk typeSSD is recommended
Disk storage spaceAt least 100G
File systemEXT4 戓XFS
Network cardGigabit Internet and above

Note: The following content uses the CentOS Linux 7.x image of the x86 architecture as the environment. Other environments may be slightly different.

This prerequisite is still a bit high, and low cost is still painful for small businesses like Ali.