Open, Ultra Fast, Cost Efficient, Distributed SQL Database

OceanBase Best Practices

All Versions

Deploy
- Configuration guide for read-write splitting in AP scenarios
- Best practices for read-write splitting
Configure
- Recommended configurations in OLTP scenarios
- Recommended configurations in complex OLTP scenarios
- Recommended configurations in HTAP scenarios
- Recommended configurations in OLAP scenarios
- Recommended configurations for OBKV
Migrate
- Data transfer solutions in OceanBase Database
- Overview on data migration
- Best practices for importing data files to OceanBase Database
- Best practice for migrating data from other databases to OceanBase Database
- Massive data migration strategy
- Best practices for migrating data from MyCat to OceanBase Database
Route
- ODP routing best practices
Table Design
- Best practices for table design and index optimization
- Best practices for creating indexes on large tables
- Best practices for database development
Develop
- Best practices for connecting Java applications to OceanBase Database
- Best practices for integrating Spark Catalog with OceanBase Database
- Best practices for achieving optimal performance in batch DML using JDBC and OBServer
- Best practices for bulk data cleanup in OceanBase Database
- Best practices for PDML processing in OceanBase Database
- Best practices for hot tables in OceanBase Database
- Best practices for auto-increment columns and sequences in OceanBase Database
Manage
- Best practices for resource throttling
- Best practices for data load balancing
- Best practices for security certification
- Best practices for access control
- Best practices for data encryption
Diagnose
- Best practices for log interpretation in common scenarios
- Best practices for end-to-end tracing
- Best practices for using obdiag to collect performance information
- Best practices for using obdiag to collect diagnostic information of parallel and slow SQL statements
- Best practices for troubleshooting OceanBase Database performance issues
Performance Tuning
- Best practices for handling slow queries
- Best practices for collecting statistics to generate an efficient execution plan
- Best practices for updating hotspot rows
- Best practices for large object storage performance
- Best practices for semi-structured storage performance
- Best practices for OceanBase materialized views
Cloud Database
- Best practices for achieving high availability through cross-cloud active-active deployment
- High availability through primary and standby databases across clouds
- High host CPU usage
- Best practices for read/write splitting in OceanBase Cloud

Download PDF