OceanBase Dedicated
OceanBase Database
Solutions
Multi-Scenario General OLTP
Real-time Analytics
Database Consolidation
Multi-cloud Architecture
Cold Data Archiving
Database Scaling
Database Active <span>Geo-redundancy</span>
Customers
GCash
DANA
Alipay
Easypaisa
Haidilao
POP MART
Kwai
Ctrip
ICBC
China Mobile Jiangsu
Sinopec
White Paper
Blog
Training and Certification
GitHub
Documentation
Databases
OceanBase Database
OceanBase Cloud
Tools
OceanBase Cloud Platform
OceanBase Developer Center
OceanBase Migration Service
OceanBase Loader and Dumper
OceanBase Deployer
Connectors and Middleware
OceanBase Database Proxy
OceanBase Connector/C
OceanBase Connector/J
OceanBase Connector/ODBC
编组
OceanBase Cloud
Release Notes
2024.06.24
2024.04.18
Product Introduction
Overview
Management mode and scenarios
Features
Supported database versions
Get Started
Create a cluster instance
Create a tenant
Create an account for a database user
Connect to an OceanBase database
Develop
Connect to database
Overview
Connect using AWS PrivateLink
Connect using Google Cloud Private Service Connect
Connect using a public IP address
Develop applications in MySQL mode
Connect to OceanBase Database
Obtain the connection parameters
Overview
Connect to OceanBase Database with client
Connect to an OceanBase Database tenant by using the mysql client
Connect to an OceanBase Database tenant by using OBClient
Connect to an OceanBase Database tenant by using ODC
Connect to OceanBase Database with drive
Create a sample Python application
Create a sample Java application
Create a sample C application
Create a sample Go application
Connect to an OceanBase database by using SpringBoot
Connect to an OceanBase database by using SpringBatch
Connect to an OceanBase database by using SpringJDBC
Connect to an OceanBase database by using SpringJPA
Connect to an OceanBase database by using Hibernate
Connect to an OceanBase database by using MyBatis
Use database connection pool
Configuration of a database connection pool
Example of configuring a Tomcat connection pool
Example of configuring a C3P0 connection pool
Example of configuring a Proxool connection pool
Example of configuring a HiKariCP connection pool
Example of configuring a DBCP connection pool
Example of configuring a CommonPool connection pool
Example of configuring a JDBC connection pool
Plan database objects
Create a database
Create a table
Create indexes
Write data
Insert data
Update data
Delete data
Replace data
Read data
About queries
Single-table queries
Conditional queries
ORDER BY queries
GROUP BY queries
Use the LIMIT clause in queries
Join tables
INNER JOIN queries
FULL JOIN queries
LEFT JOIN queries
RIGHT JOIN queries
Subqueries
Use operators and functions in queries
Use arithmetic operators in queries
Use numerical functions in queries
Use string concatenation operators in queries
Use string functions in queries
Use datetime functions in queries
Use type conversion functions in queries
Use aggregate functions in queries
Use NULL-related functions in queries
Use the CASE conditional operator in queries
Use the SELECT FOR UPDATE statement to lock query results
Execution plan
View an execution plan
Understand an execution plan
Use SQL hints in queries
Variables of query timeout
Manage transactions
Overview
Start a transaction
Savepoints
Mark a savepoint
Roll back a transaction to a savepoint
Release a savepoint
Commit a transaction
Roll back a transaction
Develop applications in Oracle mode
Connect to OceanBase Database
Obtain connection parameters
Connection methods
Create a sample Python application
Connect to OceanBase Database with drive
Create a sample Java application
Create a sample C application
Use database connection pool
Database connection pool configuration
Configure a DBCP connection pool
Configure a CommonPool connection pool
Plan database objects
Create a table
Create an index
Write data
Insert data
Update data
Delete data
Replace data
Read data
About queries
Single-table queries
Conditional queries
ORDER BY queries
GROUP BY queries
Use Row_Limiting_Clause in queries
Join tables
INNER JOIN queries
FULL JOIN queries
LEFT JOIN queries
RIGHT JOIN queries
Subqueries
Use operators and functions in queries
Use arithmetic operators in queries
Use numerical functions in queries
Use string concatenation operators in queries
Use string functions in queries
Use datetime functions in queries
Use type conversion functions in queries
Use aggregate functions in queries
Use NULL-related functions in queries
Use CASE functions in queries
Use the SELECT FOR UPDATE statement to lock query results
Execution plan
View execution plans of queries
Understand an execution plan
Use SQL hints in queries
About query timeout variables
Manage transactions
Overview
Start a transaction
Savepoints
Mark a savepoint
Roll back a transaction to a savepoint
Commit a transaction
Roll back a transaction
Instance Management
Manage cluster instances
View the instance list
Instance workspace
Stop and restart instances
Manage parameters
Parameters for cluster instances
Manage major compactions
Initiate major compactions
View compaction records
Update time for compactions
Manage analytical cluster instances
Backup and Restore
Overview
Backup strategies
Manually initiate a backup task
Data backup
Initiate a restore task
Restore data from a backup
Manage tenants
Create a tenant
Modify tenant specifications
Modify tenant names
Delete a tenant
Tenant workspace
Create an account
Create a database (MySQL mode)
Manage databases (MySQL mode)
Manage accounts
Manage tenant parameters
Import data
Supported File Formats and Encoding Formats for Data Import
Sample data introduction
Parameters for tenants
Switch primary zone
Account privileges
Tenant specification limitations
Change instance configurations
Release an instance
Scale your instances
Enable storage auto-scaling
View history of configuration changes
Backup and Restore
Overview
Overview (GCP)
Backup strategies
Manually initiate a backup task
Data backup
Initiate a restore task
Restore data from a backup
Monitoring and Alerting
Performance monitoring
Monitor performance of instances
Overview
View metrics of database performance
View metrics of host performance
Create custom monitoring dashboard
Monitor performance of tenants
Overview
View monitoring details under Performance and SQL
View monitoring details under Transaction
View monitoring details under Storage and Cache
Create custom monitoring dashboard
Alert management
Overview
Manage alert rules
Create alert rules
View alert rules
Edit alert rules
Delete alert rules
View alert history
Manage alert contacts
Monitoring metrics for alerts
Diagnostics and Optimization
Overview
Session management
SQL audit
SQL Diagnostics
Top SQL
Slow SQL
Suspicious SQL
High-risk SQL
View SQL details
Binlog Service
Overview
Activate and manage the Binlog service
Security
Search for historical events
Configure the allowlist of IP addresses
SSL link encryption
Modify login password
Manage AccessKey pairs
Multi-factor authentication (MFA) for OB Cloud accounts
Modify time zone
KMS key management
Migrations
Overview
Assess Compatibility
Overview
Perform online assessment
Perform offline assessment
Manage compatibility assessment tasks
View a compatibility assessment task
View and download a compatibility assessment report
Stop a compatibility assessment task
Delete a compatibility assessment task
Obtain files for upload
Configure PrivateLink
Add an IP address to an allowlist
Create a database user and grant privileges to the user
Migrate Data
Overview
Migrate data from a MySQL database to a MySQL tenant of OceanBase Database
Migrate data from a MySQL tenant of OceanBase Database to a MySQL database
Migrate data between OceanBase databases
Migrate data from an Oracle database to an Oracle tenant of OceanBase Database
Migrate data from an Oracle tenant of OceanBase Database to an Oracle database
Manage data migration tasks
View details of a data migration task
Rename a data migration task
View and modify migration objects
Start and stop a data migration task
Clone a data migration task
Delete a data migration task
Features
DML filtering
DDL synchronization
Use SQL conditions to filter data
Rename a migration object
Set an incremental synchronization timestamp
Instructions on schema migration
Configure AWS PrivateLink
Add an IP address to an allowlist
User privileges
Supported DDL statements for synchronization and their limitations
DDL synchronization from Aurora MySQL DB clusters to MySQL tenants of OceanBase Database
DDL synchronization from MySQL tenants of OceanBase Database to Aurora MySQL DB clusters
DDL synchronization between MySQL tenants of OceanBase Database
Supported DDL operations for synchronization from an Oracle database to an Oracle tenant of OceanBase Database
Synchronize DDL operations from an Oracle tenant of OceanBase Database to an Oracle database
Supported DDL operations for synchronization between Oracle tenants of OceanBase Database
Assess Performance
Overview
Preliminary steps
Create a full performance assessment task
Create an SQL file parsing task
Create an SQL file replay task
Manage performance assessment tasks
View the details of a performance assessment task
View a performance assessment report
Retry and stop a performance assessment task
Delete a performance assessment task
How to retrieve database instances
Create S3 access keys
User privileges for workload replay
SQL Console
Overview
Access SQL Console
SQL editing and execution
PL compilation
Result set editing
Execution analysis
Database object management
Create a table
Create a view
Create a function
Create a stored procedure
Create a sequence
Create a trigger
Create a type
Create a sequence
Create a synonym
Session variable management
Functional keys in SQL Console
Organization and Project Management
Overview
Manage organization access
Manage project access
Manage members
Role permissions
Billing
Overview
View billing details
View payment details
Invoice
View orders
Integrations
Flink
Canal
Maxwell
SeaTunnel
Debezium
Navicat
DBeaver
Bytebase
Liquibase
Prometheus
Superset
Quick BI
Tableau
Power BI
C
Java
Python
PHP
Go
DolphinScheduler
Linkis
Informatica Cloud
Kafka
References
Open API References
Overview
Service access point
Using API
Open API List
Cluster management
DescribeInstances
DescribeInstance
ModifyInstanceName
DescribeNodeOptions
DescribeOasSQLText
StopCluster
StartCluster
Tenant management
DescribeTenants
DescribeTenant
CreateTenants
DeleteTenants
ModifyTenantName
ModifyTenant
CreateConstraints
CreateCpuConstraints
CreateMemConstraints
ModifyCpuConstraints
ModifyMemConstraints
CreateTenantSecurityIpGroup
DescribeTenantSecurityIpGroups
ModifyTenantSecurityIpGroup
DeleteTenantSecurityIpGroup
Tenant user management
CreateTenantUser
DescribeTenantUsers
DeleteTenantUsers
ModifyTenantUserPassword
Database management
CreateDatabase
DescribeDatabases
DeleteDatabases
Monitoring management
DescribeNodeMetrics
DescribeTenantMetrics
DescribeMetricsData
Diagnostic management
DescribeOasTopSQLList
DescribeOasAnomalySQLList
DescribeOasSlowSQLList
System references
Download OBClient
Download OBClient
Download OceanBase Connector/J
Download the ODC client
Download OceanBase Connector/ODBC
Download OBClient Libs
ODC
Introduction to ODC
ODC tutorials
Tips on the SQL Console
Create a connection
Export data
Import data
Debug a stored procedure
View the performance of an SQL statement
ODC homepage
Connect to a database
Create a connection
Manage private connections
Public resource management
Overview
Quick start
Resource permissions
Manage public connections
Manage resource groups
Manage roles
Manage users
Automatic authorization rules
Task process management
Manage operation records
Data desensitization management
System settings
Use the workspace
Overview
SQL window
Anonymous block window
Command-line window
Stored scripts
Snippet
Use tools
Data export and import
Overview
Export and import formats
Batch export and import
Single table export and import
Data mocking
Partitioning plan
Database changes
Shadow table synchronization
SQL plan
Recycle bin
View operation records
FAQ
Task management
Overview
Import tasks
Export tasks
Data mocking tasks
Database change tasks
Partitioning plan task
Permission application tasks
Shadow table synchronization tasks
SQL plan task
Session management
Database objects
Table objects
Create a table
Create a table
Table list
Manage table attributes
Manage table data
View objects
Overview
Create a view
Manage views
Function objects
Overview
Create a function
Manage functions
Stored procedure objects
Overview
Create a stored procedure
Manage stored procedures
Sequence objects
Overview
Create a sequence
Manage sequences
Package objects
Overview
Create a program package
Manage program packages
Trigger objects
Overview
Create a trigger
Manage triggers
Type objects
Overview
Create a type
Manage types
Synonym objects
Overview
Create a synonym
Manage synonyms
Help center
FAQ
How to reset your password
How to disable multi-factor authentication (MFA)
OceanBase Cloud Services Agreement
Download PDF
2024.06.24
2024.04.18
Overview
Management mode and scenarios
Features
Supported database versions
Create a cluster instance
Create a tenant
Create an account for a database user
Connect to an OceanBase database
Overview
Connect using AWS PrivateLink
Connect using Google Cloud Private Service Connect
Connect using a public IP address
View the instance list
Instance workspace
Stop and restart instances
Manage parameters
Parameters for cluster instances
Create a tenant
Modify tenant specifications
Modify tenant names
Delete a tenant
Tenant workspace
Create an account
Create a database (MySQL mode)
Manage databases (MySQL mode)
Manage accounts
Manage tenant parameters
Import data
Supported File Formats and Encoding Formats for Data Import
Sample data introduction
Parameters for tenants
Switch primary zone
Account privileges
Tenant specification limitations
Release an instance
Scale your instances
Enable storage auto-scaling
View history of configuration changes
Overview
Overview (GCP)
Backup strategies
Manually initiate a backup task
Data backup
Initiate a restore task
Restore data from a backup
Overview
View alert history
Manage alert contacts
Monitoring metrics for alerts
Overview
Session management
SQL audit
Top SQL
Slow SQL
Suspicious SQL
High-risk SQL
View SQL details
Overview
Activate and manage the Binlog service
Search for historical events
Configure the allowlist of IP addresses
SSL link encryption
Modify login password
Manage AccessKey pairs
Multi-factor authentication (MFA) for OB Cloud accounts
Modify time zone
KMS key management
Overview
Overview
Perform online assessment
Perform offline assessment
Obtain files for upload
Configure PrivateLink
Add an IP address to an allowlist
Create a database user and grant privileges to the user
Overview
Migrate data from a MySQL database to a MySQL tenant of OceanBase Database
Migrate data from a MySQL tenant of OceanBase Database to a MySQL database
Migrate data between OceanBase databases
Migrate data from an Oracle database to an Oracle tenant of OceanBase Database
Migrate data from an Oracle tenant of OceanBase Database to an Oracle database
Configure AWS PrivateLink
Add an IP address to an allowlist
User privileges
Overview
Preliminary steps
Create a full performance assessment task
Create an SQL file parsing task
Create an SQL file replay task
Create S3 access keys
User privileges for workload replay
Overview
Access SQL Console
SQL editing and execution
PL compilation
Result set editing
Execution analysis
Create a table
Document Feedback
Documentation Center
OceanBase Cloud
OceanBase Cloud
master
Manage databases (MySQL mode)
Last Updated:
Updated
share
share
Preview