ROUTE_POLICY|V4.2.2|OceanBase Database Proxy |docs|OceanBase Documentations

OceanBase Database Proxy

V4.2.2

Download PDF

This topic describes the ROUTE_POLICY diagnostic point.

The ROUTE_POLICY diagnostic point records routing information based on the routing strategy. The following table describes the diagnostic information at the ROUTE_POLICY diagnostic point.

Field	Description	Remarks
chosen_route_type	The routing type.	N/A
route_policy	The routing strategy.	The default value is `READONLY_ZONE_FIRST`. You can specify the routing strategy by using the `ob_route_policy` session variable. OBServer nodes have different priorities in different routing strategies.
replica	The address of the logical data center (IDC).	For more information about LDC, see Strategy-based routing.
idc_type	The relationship between the replica location and OceanBase Database Proxy (ODP).	Valid values: SAME_IDC, SAME_REGION, and REMOTE.
zone_type	The type of the zone where the replica resides.	Valid values: READWRITE and READONLY.
role	The role of the replica.	Valid values: LEADER and FOLLOWER.
type	The type of the replica.	The replica can be a full-featured replica, backup replica, or log replica. For more information, see Partition replica type in OceanBase Database documentation.
is_dup_replica	Indicates whether the replica is a replication table.	Valid values: `DUP` and `-`. For more information about replication tables, see Create a table in OceanBase Database documentation.
is_merging	Indicates whether the replica is in a major compaction.	Valid values: UNMERGE (major compaction in progress) and MERGE (major compaction completed). For more information about major compactions, see Major compaction in OceanBase Database documentation.
is_partition_server	Indicates whether the replica is a partitioned table.	Valid values: PARTITION and NONPARTITION.
is_force_congested	Indicates whether to ignore the situation if the replica is in the blocklist.	N/A
proxy_idc_name	The name of the lDC for LDC-based routing in ODP.	For more information about LDC-based routing, see Strategy-based routing. This value is the same as the value of `proxy_idc_name` in ODP.
cluster_primary_zone	The primary zone of the cluster.	For more information about the primary zone, see Traffic distribution in OceanBase Database documentation.
proxy_primary_zone	The primary zone specified in ODP.	The value is the same as that of the ODP parameter proxy_primary_zone_name.
session_consistency	The read consistency level.	The value is the same as that of the ob_read_consistency system variable of OceanBase Database.
trans_consistency	The transaction consistency.	For more information about transaction consistency, see Weak consistency read in OceanBase Database documentation.