Add or delete zones

You can add or delete zones by using SQL statements or on OCP.

Add or delete zones by using SQL statements

You can add zones to a cluster to scale out the cluster or delete zones from a cluster to scale in the cluster.

The command for adding or deleting a zone is as follows, where the Zone_Name parameter specifies the name of the target zone:

ALTER SYSTEM {ADD|DELETE} ZONE Zone_Name;

Example 1: The following example statement adds Zone1 to the cluster.

obclient> ALTER SYSTEM ADD ZONE Zone1;

Example 2 : The following example statement deletes Zone1 from the zone.

obclient> ALTER SYSTEM DELETE ZONE Zone1;