Purpose
You can use this statement to start an OceanBase cluster.
This statement is required only when OceanBase Database is started for the first time. This statement can be executed only once on each cluster. If the statement fails, you need to re-create an OceanBase cluster to execute the statement again.
Before you execute this statement, make sure that all the specified OBServer nodes have been started properly.
Syntax
alter_system_bootstrap_stmt_primary:
ALTER SYSTEM BOOTSTRAP region_zone_server_list;
region_zone_server_list:
region_zone_server [, region_zone_server ...]
region_zone_server:
{
REGION [=] region_name
ZONE [=] zone_name [ IDC [=] idc_info ]
SERVER [=] ip_port
}
ip_port:
'STR_VALUE:INT_VALUE'
Parameters
| Parameter | Description |
|---|---|
| region_name | The region where RootService is deployed. The region is specified during multi-region multi-IDC deployment. |
| zone_name | The zone to which the server that runs RootService belongs. |
| ip_port | The IP address and port number of the server that runs RootService. |
| idc_info | The IDC to which the zone belongs. |
Examples
Specify a RootService server list and start the cluster. If the RootService server list contains more than one OBServer nodes, use commas (,) to separate them.
obclient> ALTER SYSTEM BOOTSTRAP ZONE 'zone1' SERVER 'xxx.xxx.xx.xx1:xxxx', ZONE 'zone2' SERVER 'xxx.xxx.xx.xx2:xxxx', ZONE 'zone3' SERVER 'xxx.xxx.xx.xx3:xxxx';