Note
This variable is available starting with V2.1.
Description
ob_tcp_invited_nodes specifies the IP address whitelist of a tenant. It supports the use of the percent sign (%), underscore (_), and IP addresses (separated by commas). It supports IP list matching, mask matching, and fuzzy matching.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a Global system variable.Modify variables
The
systenant can directly modify the value of a Global system variable.A MySQL user tenant can modify the value of a Global system variable only if it has the
SUPERorALTER SYSTEMprivilege.An Oracle user tenant can modify the value of a Global system variable only if it has the
ALTER SYSTEMprivilege.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | 127.0.0.1,::1 |
| Value range | The length of the string is less than 65536
NoteStarting from V4.2.1 BP1, the value range is adjusted from "the length of the string is less than 4096" to "the length of the string is less than 65536". |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the IP address whitelist of a tenant to 127.0.0.1.
obclient> SET GLOBAL ob_tcp_invited_nodes='127.0.0.1';