Note
For V4.2.5, this parameter is available starting with V4.2.5 BP5.
Description
enable_gts_standalone specifies whether to enable the GTS service to occupy a group of units. After the GTS service is enabled to occupy a group of units, the performance and stability of the GTS service are improved.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | False |
| Value range |
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
The GTS service of a tenant is provided by the unit that hosts the system log stream. When the GTS service and user log stream are provided by the same unit, the GTS service may be affected by the access pressure and maintenance operations of the user log stream. To prevent the GTS service from affecting the overall availability of the tenant, OceanBase Database provides the GTS service to occupy a group of units.
After the GTS service to occupy a group of units is enabled, the load balancing feature automatically selects a group of units to host the system log stream (the units specified in the unit_list parameter of the log stream maintenance command or the units in the current unit list). The user log stream is automatically distributed to other units.
After the GTS service to occupy a group of units is enabled, ensure that the UNIT_NUM value of all zones of the tenant is greater than or equal to 2 and the enable_rebalance parameter is enabled.
Examples
Enable the GTS service to occupy a group of units.
obclient> ALTER SYSTEM SET enable_gts_standalone = 'True';