Note
This variable is available starting with V2.1.
Description
ob_tcp_invited_nodes specifies the IP address whitelist for 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 use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of global system variables.Modify variables
The
systenant can directly modify the value of global system variables.MySQL user tenants need to have the
SUPERorALTER SYSTEMprivilege to modify the value of global system variables.Oracle user tenants need to have the
ALTER SYSTEMprivilege to modify the value of global system variables.
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 for a tenant to 127.0.0.1.
obclient> SET GLOBAL ob_tcp_invited_nodes='127.0.0.1';