ob_org_cluster_id specifies the session-level CLUSTER_ID of the OceanBase cluster. This value will be persisted to the transaction log.
Generally, you do not need to set the ob_org_cluster_id variable. The default value is used when OceanBase Database generates clogs. OceanBase Migration Service (OMS) uses ob_org_cluster_id for data filtering. For more information about OMS data filtering, see the topic "Create a project to migrate data from a MySQL database to a MySQL tenant of OceanBase Database" in the OMS documentation.
For example, if the OBCDC component of OMS sets cluster_id_black_list to 2147473648, and the session-level variable is specified as SET ob_org_cluster_id=2147473648; for data writes to the OBServer, then OBCDC will filter the received data whose cluster_id is 2147473648.
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 0 |
| Value range | [0, 4294967295] |
| Applicable scope | Session |
| Involved in serialization? | Yes |