proxy_primary_zone_name specifies the name of the primary zone for logical data center (LDC)-based routing in OceanBase Database Proxy (ODP). If this parameter is specified, ODP routes queries only to the specified primary zone.
You can specify multiple zone names separated with semicolons (;) or commas (,). Different separators indicate different routing priorities.
Zones separated with semicolons (
;) are arranged in descending order of priority. In other words, the zone before a semicolon (;) has a higher priority than the zone after the semicolon (;).Zones separated with commas (
,) have the same priority. ODP randomly routes queries to any of the specified zone.
Note
You can configure multiple zones as the primary zone in ODP V4.3.1 and later, and only one zone in versions earlier than V4.3.1.
A zone name must not contain a semicolon (
;) or comma (,), because semicolons and commas are parsed as separators.
| Attribute | Description |
|---|---|
| Parameter type | String |
| Default value | Empty string |
| Value range | N/A |
| Effective upon ODP restart | No |
Examples
Assume that the cluster contains six zones named z1 to z6. Here is an example of configuring the zone priorities as follows: z1 = z2 > z3 = z4 > z5 = z6.
alter proxyconfig set proxy_primary_zone_name='z1,z2;z3,z4;z5,z6'