OceanBase Best Practices

OceanBase Best Practices are based on accumulated experience and practical use cases to help users utilize OceanBase products more effectively and conveniently.

Best Practices

Feedback and Suggestions

1
Feedback and Suggestions
We have outlined a series of topics for the OceanBase Best Practices guide, which will be released and updated over time. However, these topics currently cover only a small part of the content and are not yet comprehensive. We would greatly appreciate your feedback and suggestions to help us improve this guide. You can submit your questions and suggestions by clicking the feedback icon on the right side of the document.

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
- Best practices for migrating PostgreSQL to OceanBase MySQL-compatible mode
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