OceanBase Database Proxy

OceanBase Database Proxy (ODP), also called OBProxy, is a dedicated proxy server for OceanBase Database. In OceanBase Database, user data is stored as multiple replicas on various OBServer nodes. After receiving an SQL request from a user, ODP forwards the SQL request to the optimal OBServer node and then returns the execution result to the user. Core features of ODP include connection management, optimal routing, high-performance forwarding, easy O&M, high availability, and proprietary protocol.

Download

Build a Business System

Deploy ODP

Use ODP

Perform O&M on ODP

1
Deploy ODP
You can use an RPM package to install ODP.
For more information, see "Deploy ODP by using obd".

Dive Deep into ODP

Routing Feature
Learn more about the routing feature of ODP
Documents
Security and Protocols
Learn more about the security and protocols of ODP
Documents
High Availability Mechanism
Learn more about the high availability mechanism of ODP
Documents

OceanBase Database Proxy

V4.2.0Community Edition

What is ODP?
Installation and deployment
- Deploy ODP by using OBD
- Deploy ODP by using OCP
- Deploy ODP by using the CLI
- Deployment modes
Basic operations
Configuration parameter
- Parameter description
- Dynamically modifiable parameters
- Parameters that are not dynamically modifiable
- Internal and inherited parameters
- In-memory parameters
Connection management
- Principles
- Session status synchronization
- Client session
- Server session
Data routing
- Factors affecting data routing
- Routing strategies
- ODP routing
- Intra-tenant routing
- Read/Write separation
- Follower latency threshold
High availability mechanism
- Overview
- High availability of ODP services
- High availability of OceanBase Database
- High availability testing
Security and protocols
Operation and maintenance
- Troubleshooting
  - Troubleshooting logic
  - Monitoring logs
- Performance analysis
- Show Trace