Data validation is a feature provided by OceanBase Cloud that allows you to compare the differences between source database and target database. This feature enables you to identify data inconsistencies in real-time without interrupting the services.
Validation types
OceanBase Cloud currently offers two validation types: full validation and row count validation. These types cater to most scenarios for data validation.
Full validation: This method involves comparing the entire dataset from both source and target databases. While it provides accurate results, it may take longer to complete. Full validation is suitable for one-time checks of static data.
Row count validation: This method compares the number of rows in tables between source and target databases. It is faster but does not verify the actual data content. Row count validation is ideal for scenarios with large volumes of data where the sensitivity to data consistency is low.
Support for validation tasks
| Validation Task | Full validation | Row count validation |
|---|---|---|
| MySQL -> OB_MySQL | Supported | Supported |
| OB_MySQL -> MySQL | Supported | Supported |
| OB_MySQL -> OB_MySQL | Supported | Supported |
| OB_Oracle -> OB_Oracle | Supported | Supported |
| Oracle -> OB_Oracle | Supported | Supported |
| OB_Oracle -> Oracle | Supported | Supported |
| OB_MySQL -> Kafka | Not supported | Not supported |
| OB_Oracle -> Kafka | Not supported | Not supported |
| TiDB -> OB_MySQL | Supported | Supported |
| PostgreSQL -> OB_MySQL | Supported | Supported |
| PostgreSQL -> OB_Oracle | Supported | Supported |
Billing information
Full validation: Currently available at a limited-time free rate; charges will be announced separately.
Row count validation: Free of charge.