OceanBase 2.2集群实战第十四篇—— OB集群【副本降级】

原创 gelyon All China Database Union 2021-03-23
2194
最近安排了几个同事准备OBCP考试，有同事问我副本怎么调整，之前我也没实操过，只是了解基本理论，本篇就来实操体验下OB副本的增减操作，即：两地三中心<–>三地五中心。
这里就以官网下载的ob2.2.50试用版ob-deploy.tar包来实操，只需2c8g即可安装部署，之前的文章已介绍过采用手动安装OB2.2集群2c8g试用版，详见2c8g迷你版1-1-1集群安装部署体验
本系列总的专栏：一步一步学习OceanBase系列
本篇实操OB集群副本的降级，从5副本1-1-1-1-1架构降级为3副本1-1-1架构，下一篇实操OB集群副本的升级，从3副本1-1-1架构升级为5副本1-1-1-1-1架构。
OB解决方案架构师梅老师之前有介绍过OB副本数的调整文章，详见：OceanBase 独立部署高级玩法三：副本数调整
本篇 OB 集群资源规划采用的是不同 ZONE 使用同等规格的机器和资源池配置。
本篇操作步骤：
1、手动搭建一个2c8g版的1-1-1-1-1的5副本OB集群，即三地五中心
2、创建两个业务租户，分别是mysql类型租户和oracle类型的租户，并且使用同样规格的资源池配置。
3、分别在两个业务租户下，创建业务表，一个是非分区表test，一个是分区表test_hash(partition 5)，一个是复制表test_full。
4、降级副本前查看集群信息和业务租户下分区副本分布情况，便于副本降级后对比。
5、开始副本降级将5副本的1-1-1-1-1集群改为3副本的1-1-1集群，即三地五中心–>两地三中心
副本数降级步骤：
5.1、租户减副本，修改租户的locality，包括业务租户和sys系统租户。
5.2、业务租户下复制表的副本降级。
5.3、调整资源池，释放租户在目标zone的资源池，包括业务租户和sys租户。
5.4、所有租户副本和资源池调整释放后，最后删除集群observer机器和删除zone。
以下是整个副本降级实操体验：
1、先搭建一个1-1-1-1-1的2c8g版的5副本OB集群

节点信息:2cpu+8g内存
zone1  ob01: 192.168.0.175
zone2  ob02: 192.168.0.119
zone3  ob03: 192.168.0.221
zone4  ob04: 192.168.0.30
zone5  ob05: 192.168.0.58

[admin@yhob-0001 ~]$ cat /etc/system-release
CentOS Linux release 7.6.1810 (Core) 
[admin@yhob-0001 ~]$ 
[admin@yhob-0001 ~]$ free -lm
              total        used        free      shared  buff/cache   available
Mem:           7820        6025         665           8        1130         643
Low:           7820        7155         665
High:             0           0           0
Swap:             0           0           0
[admin@yhob-0001 ~]$ lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                2
On-line CPU(s) list:   0,1
Thread(s) per core:    2
Core(s) per socket:    1
Socket(s):             1
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 85
Model name:            Intel(R) Xeon(R) Gold 6266C CPU @ 3.00GHz
Stepping:              7
CPU MHz:               3000.000
BogoMIPS:              6000.00
Hypervisor vendor:     KVM
Virtualization type:   full
L1d cache:             32K
L1i cache:             32K
L2 cache:              1024K
L3 cache:              30976K
NUMA node0 CPU(s):     0,1
Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl xtopology nonstop_tsc eagerfpu pni pclmulqdq ssse3 fm
a cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp ibrs_enhanced fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat avx512_vnni md_clear spec_ctrl intel_stibp flush_l1d arch_capabilities[admin@yhob-0001 ~]$ 
[admin@yhob-0001 ~]$
[admin@yhob-0001 ~]$ df -h |egrep home\|data
/dev/vdd1        50G   41G   10G  81% /data/1
/dev/vdc1        50G  3.8G   47G   8% /data/log1
/dev/vdb1        50G   14G   37G  28% /home
[admin@yhob-0001 ~]$ 


(1)、分别启动每个zone下的observer，这里不详细介绍，参考之前的文章。
# su - admin
$ cd /home/admin/oceanbase
bin/observer -i eth0 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r '192.168.0.175:2882:2881;192.168.0.119:2882:2881;192.168.0.221:2882:2881;192.168.0.30:2882:2881;192.168.0.58:2882:2881' -c 20210323 -n obdemo -o "syslog_level=WARN,memory_limit=8G,cpu_count=16,system_memory=5G,datafile_size=40G,__min_full_resource_pool_memory=536870912,cache_wash_threshold=1G,row_purge_thread_count=1,net_thread_count=1,enable_syslog_recycle=True,enable_merge_by_turn=FALSE,location_refresh_thread_count=2,max_syslog_file_count=3,major_freeze_duty_time=Disable,__easy_memory_limit=1G,schema_history_expire_time=1d,merge_thread_count=1,writing_throttling_trigger_percentage=70,_max_trx_size=2M,workers_per_cpu_quota=2,enable_separate_sys_clog=0,memory_chunk_cache_size=128M,trace_log_slow_query_watermark=10s,writing_throttling_maximum_duration=1m,switchover_process_thread_count=1,minor_freeze_times=500,stack_size=1536K,disk_io_thread_coun=1,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"
bin/observer -i eth0 -P 2882 -p 2881 -z zone2 -d /home/admin/oceanbase/store/obdemo -r '192.168.0.175:2882:2881;192.168.0.119:2882:2881;192.168.0.221:2882:2881;192.168.0.30:2882:2881;192.168.0.58:2882:2881' -c 20210323 -n obdemo -o "syslog_level=WARN,memory_limit=8G,cpu_count=16,system_memory=5G,datafile_size=40G,__min_full_resource_pool_memory=536870912,cache_wash_threshold=1G,row_purge_thread_count=1,net_thread_count=1,enable_syslog_recycle=True,enable_merge_by_turn=FALSE,location_refresh_thread_count=2,max_syslog_file_count=3,major_freeze_duty_time=Disable,__easy_memory_limit=1G,schema_history_expire_time=1d,merge_thread_count=1,writing_throttling_trigger_percentage=70,_max_trx_size=2M,workers_per_cpu_quota=2,enable_separate_sys_clog=0,memory_chunk_cache_size=128M,trace_log_slow_query_watermark=10s,writing_throttling_maximum_duration=1m,switchover_process_thread_count=1,minor_freeze_times=500,stack_size=1536K,disk_io_thread_coun=1,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"
bin/observer -i eth0 -P 2882 -p 2881 -z zone3 -d /home/admin/oceanbase/store/obdemo -r '192.168.0.175:2882:2881;192.168.0.119:2882:2881;192.168.0.221:2882:2881;192.168.0.30:2882:2881;192.168.0.58:2882:2881' -c 20210323 -n obdemo -o "syslog_level=WARN,memory_limit=8G,cpu_count=16,system_memory=5G,datafile_size=40G,__min_full_resource_pool_memory=536870912,cache_wash_threshold=1G,row_purge_thread_count=1,net_thread_count=1,enable_syslog_recycle=True,enable_merge_by_turn=FALSE,location_refresh_thread_count=2,max_syslog_file_count=3,major_freeze_duty_time=Disable,__easy_memory_limit=1G,schema_history_expire_time=1d,merge_thread_count=1,writing_throttling_trigger_percentage=70,_max_trx_size=2M,workers_per_cpu_quota=2,enable_separate_sys_clog=0,memory_chunk_cache_size=128M,trace_log_slow_query_watermark=10s,writing_throttling_maximum_duration=1m,switchover_process_thread_count=1,minor_freeze_times=500,stack_size=1536K,disk_io_thread_coun=1,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"

bin/observer -i eth0 -P 2882 -p 2881 -z zone4 -d /home/admin/oceanbase/store/obdemo -r '192.168.0.175:2882:2881;192.168.0.119:2882:2881;192.168.0.221:2882:2881;192.168.0.30:2882:2881;192.168.0.58:2882:2881' -c 20210323 -n obdemo -o "syslog_level=WARN,memory_limit=8G,cpu_count=16,system_memory=5G,datafile_size=40G,__min_full_resource_pool_memory=536870912,cache_wash_threshold=1G,row_purge_thread_count=1,net_thread_count=1,enable_syslog_recycle=True,enable_merge_by_turn=FALSE,location_refresh_thread_count=2,max_syslog_file_count=3,major_freeze_duty_time=Disable,__easy_memory_limit=1G,schema_history_expire_time=1d,merge_thread_count=1,writing_throttling_trigger_percentage=70,_max_trx_size=2M,workers_per_cpu_quota=2,enable_separate_sys_clog=0,memory_chunk_cache_size=128M,trace_log_slow_query_watermark=10s,writing_throttling_maximum_duration=1m,switchover_process_thread_count=1,minor_freeze_times=500,stack_size=1536K,disk_io_thread_coun=1,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"
bin/observer -i eth0 -P 2882 -p 2881 -z zone5 -d /home/admin/oceanbase/store/obdemo -r '192.168.0.175:2882:2881;192.168.0.119:2882:2881;192.168.0.221:2882:2881;192.168.0.30:2882:2881;192.168.0.58:2882:2881' -c 20210323 -n obdemo -o "syslog_level=WARN,memory_limit=8G,cpu_count=16,system_memory=5G,datafile_size=40G,__min_full_resource_pool_memory=536870912,cache_wash_threshold=1G,row_purge_thread_count=1,net_thread_count=1,enable_syslog_recycle=True,enable_merge_by_turn=FALSE,location_refresh_thread_count=2,max_syslog_file_count=3,major_freeze_duty_time=Disable,__easy_memory_limit=1G,schema_history_expire_time=1d,merge_thread_count=1,writing_throttling_trigger_percentage=70,_max_trx_size=2M,workers_per_cpu_quota=2,enable_separate_sys_clog=0,memory_chunk_cache_size=128M,trace_log_slow_query_watermark=10s,writing_throttling_maximum_duration=1m,switchover_process_thread_count=1,minor_freeze_times=500,stack_size=1536K,disk_io_thread_coun=1,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"

ps -ef|grep observer
netstat -ntlp |grep observer
df -h |egrep home\|data

(2)、初始化集群
[admin@yhob-0001 oceanbase]$ mysql -h127.1 -uroot -P2881 -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 3221225477
Server version: 5.7.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> set session ob_query_timeout=1000000000;
Query OK, 0 rows affected (0.00 sec)

MySQL [(none)]> alter system bootstrap ZONE 'zone1' SERVER '192.168.0.175:2882', ZONE 'zone2' SERVER '192.168.0.119:2882', ZONE 'zone3' SERVER '192.168.0.221:2882', ZONE 'zone4' SERVER '192.168.0.30:2882', ZONE 'zone5' SERVER '192.168.0.58:2882';
Query OK, 0 rows affected (39.03 sec)

MySQL [(none)]> alter user root identified by 'admin123';
Query OK, 0 rows affected (0.03 sec)

MySQL [(none)]> exit
Bye
[admin@yhob-0001 oceanbase]$ 

(3)、查看集群信息
[admin@ob-docker my]$ obclient -h127.1 -P2883 -uroot@sys#obdemo -padmin123 -c -A oceanbase
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 94
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 11:05:26.537757 |       | config_version           | 1616468726517379 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 11:05:26.537950 |       | lease_info_version       | 1616468726537379 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881784 | 2021-03-23 11:05:15.881784 | zone5 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881648 | 2021-03-23 11:05:15.881648 | zone5 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.882121 | 2021-03-23 11:05:15.882121 | zone5 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881895 | 2021-03-23 11:05:15.881895 | zone5 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.881602 | 2021-03-23 11:05:15.881602 | zone5 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881739 | 2021-03-23 11:05:15.881739 | zone5 | last_merged_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881693 | 2021-03-23 11:05:15.881693 | zone5 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881844 | 2021-03-23 11:05:15.881844 | zone5 | merge_start_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881999 | 2021-03-23 11:05:15.881999 | zone5 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.882059 | 2021-03-23 11:05:15.882059 | zone5 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.881558 | 2021-03-23 11:05:15.881558 | zone5 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881953 | 2021-03-23 11:05:15.881953 | zone5 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.882168 | 2021-03-23 11:05:15.882168 | zone5 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
82 rows in set (0.01 sec)

obclient> source servers.sql
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone  | svr_ip        | svr_port | inner_port | with_rootserver | status | gmt_create                 | start_service_time         | build_version |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone1 | 192.168.0.175 |     2882 |       2881 |               1 | active | 2021-03-23 11:05:05.341939 | 2021-03-23 11:05:17.326593 | 2.2.50_1      |
| zone2 | 192.168.0.119 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.434825 | 2021-03-23 11:05:18.298162 | 2.2.50_1      |
| zone3 | 192.168.0.221 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.586951 | 2021-03-23 11:05:19.281431 | 2.2.50_1      |
| zone4 | 192.168.0.30  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.385910 | 2021-03-23 11:05:18.357579 | 2.2.50_1      |
| zone5 | 192.168.0.58  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.614588 | 2021-03-23 11:05:19.285863 | 2.2.50_1      |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
5 rows in set (0.01 sec)

obclient> source tent.sql
+-----------+-------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys         |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
+-----------+-------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
1 row in set (0.00 sec)



2、创建资源池和租户

除系统sys租户外，新建了两个业务租户，分别是mysql模式和oracle模式的业务租户，并且两个业务租户的资源配置unit规格都是1c1g。

obclient> create resource unit my_unit_1c1g max_cpu=1, min_cpu=1, max_memory='1g', min_memory='1g', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='20g';
Query OK, 0 rows affected (0.02 sec)

obclient> create resource pool mysql_test_pool unit = 'my_unit_1c1g', unit_num = 1;
Query OK, 0 rows affected (0.03 sec)

obclient> create tenant  mysql_test_tent resource_pool_list=('mysql_test_pool'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';
Query OK, 0 rows affected (2.82 sec)

obclient> create resource pool ora_test_pool unit = 'my_unit_1c1g', unit_num = 1;
Query OK, 0 rows affected (0.03 sec)

obclient> create tenant ora_test_tent resource_pool_list=('ora_test_pool'), primary_zone='RANDOM',comment 'oracle tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='oracle';
Query OK, 0 rows affected (2.81 sec)

obclient> 
obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:10.244991 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:52.814897 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.00 sec)
obclient> source pool.sql
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| resource_pool_name | unit_config_name | max_cpu | min_cpu | max_mem_gb | min_mem_gb | unit_id | zone  | observer           | tenant_id | tenant_name     |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       1 | zone1 | 192.168.0.175:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       2 | zone2 | 192.168.0.119:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       3 | zone3 | 192.168.0.221:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       4 | zone4 | 192.168.0.30:2882  |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       5 | zone5 | 192.168.0.58:2882  |         1 | sys             |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1001 | zone1 | 192.168.0.175:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1002 | zone2 | 192.168.0.119:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1003 | zone3 | 192.168.0.221:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1004 | zone4 | 192.168.0.30:2882  |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1005 | zone5 | 192.168.0.58:2882  |      1001 | mysql_test_tent |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1006 | zone1 | 192.168.0.175:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1007 | zone2 | 192.168.0.119:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1008 | zone3 | 192.168.0.221:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1009 | zone4 | 192.168.0.30:2882  |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1010 | zone5 | 192.168.0.58:2882  |      1002 | ora_test_tent   |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
15 rows in set (0.01 sec)

obclient> source unit_config.sql
+----------------+-----------------+---------+---------+------------+------------+------------------+
| unit_config_id | name            | max_cpu | min_cpu | max_mem_gb | min_mem_gb | max_disk_size_gb |
+----------------+-----------------+---------+---------+------------+------------+------------------+
|              1 | sys_unit_config |       5 |     2.5 |          1 |          1 |               40 |
|           1001 | my_unit_1c1g    |       1 |       1 |          1 |          1 |               20 |
+----------------+-----------------+---------+---------+------------+------------+------------------+
2 rows in set (0.00 sec)

obclient> 


3、分别登录两个业务租户，创建业务表，一个是非分区表test，一个是分区表test_hash(partition 5)，一个是复制表test_full。
mysql租户示例如下：
[admin@ob-docker my]$ obclient -h127.1 -P2883 -uroot@mysql_test_tent#obdemo -p -c -A oceanbase
Enter password: 
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 2097156
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> alter user root identified by 'admin123';
Query OK, 0 rows affected (0.07 sec)

obclient> create database testdb;
Query OK, 1 row affected (0.05 sec)

obclient> grant all privileges on testdb.* to aps2@'%' identified by 'aps2#12345';
Query OK, 0 rows affected (0.16 sec)

obclient> show grants for aps2;
+----------------------------------------------+
| Grants for aps2@%                            |
+----------------------------------------------+
| GRANT USAGE ON *.* TO 'aps2'                 |
| GRANT ALL PRIVILEGES ON `testdb`.* TO 'aps2' |
+----------------------------------------------+
2 rows in set (0.04 sec)

obclient> exit
Bye
[admin@ob-docker my]$
[admin@ob-docker my]$ obclient -h127.1 -uaps2@mysql_test_tent#obdemo -P2883 -paps2#12345 -c -A testdb
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 2097172
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> create table test(id int not null,name varchar(20),age int,dt datetime,primary key (id));
Query OK, 0 rows affected (0.26 sec)

obclient> create table test_hash(id int not null,name varchar(20) not null, age int,dt datetime default now(),primary key (id)) partition by hash(id) partitions 5;
Query OK, 0 rows affected (0.25 sec)

obclient> create table test_full (id int not null,name varchar(20) not null, age int,dt datetime default now(),primary key (id)) locality='F,R{all_server}@zone1, F,R{all_server}@zone2, F,R{all_server}@zone3, F,R{all_server}@zone4, F,R{all_server}@zone5' primary_zone='zone1'  duplicate_scope='cluster';
Query OK, 0 rows affected (0.17 sec)

obclient> exit
exit
Bye
[admin@ob-docker my]$

oracle租户示例如下：
[admin@ob-docker my]$ obclient -h127.1 -usys@ora_test_tent#obdemo -P2883 -p -c -A sys
Enter password: 
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 2097173
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> alter user sys identified by admin123;
Query OK, 0 rows affected (0.11 sec)

obclient> create user aps2 identified by aps2#12345;
Query OK, 0 rows affected (0.11 sec)

obclient> grant all privileges on aps2.* to aps2;
Query OK, 0 rows affected (0.12 sec)

obclient> show grants for aps2;
+--------------------------------------------+
| Grants for APS2@%                          |
+--------------------------------------------+
| GRANT USAGE ON *.* TO 'APS2'               |
| GRANT ALL PRIVILEGES ON "APS2".* TO 'APS2' |
+--------------------------------------------+
2 rows in set (0.05 sec)

obclient> 
obclient> exit
Bye
[admin@ob-docker my]$ obclient -h127.1 -uaps2@ora_test_tent#obdemo -P2883 -paps2#12345 -c -A aps2
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 2097174
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> create table test(id int not null,name varchar2(20) not null,age int,dt date not null,primary key(id));
Query OK, 0 rows affected (0.41 sec)

obclient> create table test_hash(id int not null,name varchar2(20) not null,age int,dt date default sysdate,primary key (id)) partition by hash(id) partitions 5;
Query OK, 0 rows affected (0.19 sec)

obclient> create table test_full (id int not null,name varchar2(20) not null,age int,dt date default sysdate,primary key (id)) locality='F,R{all_server}@zone1, F,R{all_server}@zone2, F,R{all_server}@zone3, F,R{all_server}@zone4, F,R{all_server}@zone5' primary_zone='zone1'  duplicate_scope='cluster';
Query OK, 0 rows affected (0.25 sec)

obclient> 
obclient> exit
Bye
[admin@ob-docker my]$ 

到此，准备工作已做完。


4、查看整个集群信息，以及业务租户下表分区副本分布情况，便于后续减副本对比
[admin@ob-docker my]$ obclient -h127.1 -P2883 -uroot@sys#obdemo -padmin123 -c -A oceanbase
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 166
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> select * from __all_cluster\G
*************************** 1. row ***************************
    gmt_create: 2021-03-23 11:05:26.189773
  gmt_modified: 2021-03-23 11:05:26.562395
   cluster_idx: 0
    cluster_id: 20210323
  cluster_name: obdemo
       rs_list: {"Data":{"ObRegion":"obdemo","ObCluster":"obdemo","ObRegionId":20210323,"ObClusterId":20210323,"Type":"PRIMARY","timestamp":1616468726561891,"RsList":[{"address":"192.168.0.175:2882","role":"LEADER","sql_port":2881},{"ad
dress":"192.168.0.30:2882","role":"FOLLOWER","sql_port":2881},{"address":"192.168.0.58:2882","role":"FOLLOWER","sql_port":2881},{"address":"192.168.0.119:2882","role":"FOLLOWER","sql_port":2881},{"address":"192.168.0.221:2882","role":"FOLLOWER","sql_port":2881}],"ReadonlyRsList":[]}}cluster_status: 1
1 row in set (0.00 sec)

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 11:05:26.537757 |       | config_version           | 1616468726517379 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 11:05:26.537950 |       | lease_info_version       | 1616468726537379 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881784 | 2021-03-23 11:05:15.881784 | zone5 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881648 | 2021-03-23 11:05:15.881648 | zone5 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.882121 | 2021-03-23 11:05:15.882121 | zone5 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881895 | 2021-03-23 11:05:15.881895 | zone5 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.881602 | 2021-03-23 11:05:15.881602 | zone5 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881739 | 2021-03-23 11:05:15.881739 | zone5 | last_merged_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881693 | 2021-03-23 11:05:15.881693 | zone5 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881844 | 2021-03-23 11:05:15.881844 | zone5 | merge_start_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881999 | 2021-03-23 11:05:15.881999 | zone5 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.882059 | 2021-03-23 11:05:15.882059 | zone5 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.881558 | 2021-03-23 11:05:15.881558 | zone5 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881953 | 2021-03-23 11:05:15.881953 | zone5 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.882168 | 2021-03-23 11:05:15.882168 | zone5 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
82 rows in set (0.01 sec)

obclient> source servers.sql
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone  | svr_ip        | svr_port | inner_port | with_rootserver | status | gmt_create                 | start_service_time         | build_version |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone1 | 192.168.0.175 |     2882 |       2881 |               1 | active | 2021-03-23 11:05:05.341939 | 2021-03-23 11:05:17.326593 | 2.2.50_1      |
| zone2 | 192.168.0.119 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.434825 | 2021-03-23 11:05:18.298162 | 2.2.50_1      |
| zone3 | 192.168.0.221 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.586951 | 2021-03-23 11:05:19.281431 | 2.2.50_1      |
| zone4 | 192.168.0.30  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.385910 | 2021-03-23 11:05:18.357579 | 2.2.50_1      |
| zone5 | 192.168.0.58  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.614588 | 2021-03-23 11:05:19.285863 | 2.2.50_1      |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
5 rows in set (0.01 sec)

obclient> source server_stat.sql
+-------+--------------------+-----------+----------+--------------+-------------+---------------+----------+----------------------------+----------+--------+
| zone  | observer           | cpu_total | cpu_free | mem_total_gb | mem_free_gb | disk_total_gb | unit_num | start_service_time         | version  | status |
+-------+--------------------+-----------+----------+--------------+-------------+---------------+----------+----------------------------+----------+--------+
| zone1 | 192.168.0.175:2882 |        14 |      9.5 |            3 |           0 |            40 |        3 | 2021-03-23 11:05:17.326593 | 2.2.50_1 | active |
| zone2 | 192.168.0.119:2882 |        14 |      9.5 |            3 |           0 |            40 |        3 | 2021-03-23 11:05:18.298162 | 2.2.50_1 | active |
| zone3 | 192.168.0.221:2882 |        14 |      9.5 |            3 |           0 |            40 |        3 | 2021-03-23 11:05:19.281431 | 2.2.50_1 | active |
| zone4 | 192.168.0.30:2882  |        14 |      9.5 |            3 |           0 |            40 |        3 | 2021-03-23 11:05:18.357579 | 2.2.50_1 | active |
| zone5 | 192.168.0.58:2882  |        14 |      9.5 |            3 |           0 |            40 |        3 | 2021-03-23 11:05:19.285863 | 2.2.50_1 | active |
+-------+--------------------+-----------+----------+--------------+-------------+---------------+----------+----------------------------+----------+--------+
5 rows in set (0.03 sec)

obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:10.244991 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:52.814897 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.00 sec)

obclient> source pool.sql
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| resource_pool_name | unit_config_name | max_cpu | min_cpu | max_mem_gb | min_mem_gb | unit_id | zone  | observer           | tenant_id | tenant_name     |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       1 | zone1 | 192.168.0.175:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       2 | zone2 | 192.168.0.119:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       3 | zone3 | 192.168.0.221:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       4 | zone4 | 192.168.0.30:2882  |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       5 | zone5 | 192.168.0.58:2882  |         1 | sys             |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1001 | zone1 | 192.168.0.175:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1002 | zone2 | 192.168.0.119:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1003 | zone3 | 192.168.0.221:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1004 | zone4 | 192.168.0.30:2882  |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1005 | zone5 | 192.168.0.58:2882  |      1001 | mysql_test_tent |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1006 | zone1 | 192.168.0.175:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1007 | zone2 | 192.168.0.119:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1008 | zone3 | 192.168.0.221:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1009 | zone4 | 192.168.0.30:2882  |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1010 | zone5 | 192.168.0.58:2882  |      1002 | ora_test_tent   |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
15 rows in set (0.01 sec)

obclient> source unit_config.sql
+----------------+-----------------+---------+---------+------------+------------+------------------+
| unit_config_id | name            | max_cpu | min_cpu | max_mem_gb | min_mem_gb | max_disk_size_gb |
+----------------+-----------------+---------+---------+------------+------------+------------------+
|              1 | sys_unit_config |       5 |     2.5 |          1 |          1 |               40 |
|           1001 | my_unit_1c1g    |       1 |       1 |          1 |          1 |               20 |
+----------------+-----------------+---------+---------+------------+------------+------------------+
2 rows in set (0.00 sec)

obclient> source part.sql
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
| tenant_id | tenant_name     | database_name | table_id         | table_Name | tablegroup_id | part_num | partition_Id | zone  | svr_ip        | svr_port | role | data_size_mb |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone4 | 192.168.0.30  |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone5 | 192.168.0.58  |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone4 | 192.168.0.30  |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone5 | 192.168.0.58  |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
70 rows in set (0.51 sec)

obclient> 



5、开始调整副本：从5副本减为3副本，副本的降级，只需要删除副本即可。

(5.1)、首先要做的是租户减副本。
OB集群有业务租户和默认系统sys租户，系统sys租户减副本放到最后。
如果租户 primary_zone 指定了具体的 ZONE 而那个 ZONE 是要被减掉的，则需要先切换 PRIMARY_ZONE。
默认租户的 locality 值是 'FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5'。租户减副本主要是修改 locality 属性。
语句如下：
alter tenant mysql_test_tent locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';
alter tenant ora_test_tent locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';

登录sys系统租户，调整业务租户副本示例如下：
[admin@ob-docker my]$ obclient -h127.1 -P2883 -uroot@sys#obdemo -padmin123 -c -A oceanbase
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 166
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient>
obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:10.244991 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:52.814897 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.00 sec)

obclient> alter tenant mysql_test_tent locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';
Query OK, 0 rows affected (0.14 sec)

obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3             | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3                               | RANDOM                        | 2021-03-23 11:58:33.294385 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | RANDOM                        | 2021-03-23 11:09:52.814897 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.01 sec)

obclient> alter tenant ora_test_tent locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';
Query OK, 0 rows affected (0.10 sec)

obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3             | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3                               | RANDOM                        | 2021-03-23 11:58:55.348423 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3             | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3                               | RANDOM                        | 2021-03-23 11:59:39.071173 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.00 sec)

obclient>


租户减副本的时候 OB 内部在自动的删除目标 ZONE 上的副本。可以查看内部总控服务事件日志。
SELECT DATE_FORMAT(gmt_create, '%b%d %H:%i:%s') gmt_create_ , module, event, name1, value1, name2, value2, rs_svr_ip
FROM __all_rootservice_event_history
WHERE 1 = 1 and module in ('balancer','leader_coordinator') and gmt_create >= '2021-03-23 13:00:00'
ORDER BY gmt_create DESC
LIMIT 1000;


(5.2)、业务租户下复制表的副本降级。
业务租户下的表默认继承租户的多副本属性，但复制表例外，此时查看业务租户分区副本分布，test_full复制表还是5副本。对于复制表需要单独修改locality。

复制表副本降级示例如下：
obclient> source part.sql
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
| tenant_id | tenant_name     | database_name | table_id         | table_Name | tablegroup_id | part_num | partition_Id | zone  | svr_ip        | svr_port | role | data_size_mb |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone4 | 192.168.0.30  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone5 | 192.168.0.58  |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
46 rows in set (0.41 sec)

obclient> 

登录业务租户，修改复制表的副本，语句：
alter table test_full locality='F,R{all_server}@zone1, F,R{all_server}@zone2, F,R{all_server}@zone3';

示例如下：
[admin@ob-docker my]$ obclient -h127.1 -uaps2@mysql_test_tent#obdemo -P2883 -paps2#12345 -c -A testdb
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 2097175
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient>
obclient> show create table test_full\G
*************************** 1. row ***************************
       Table: test_full
Create Table: CREATE TABLE `test_full` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `dt` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.0' REPLICA_NUM = 5 LOCALITY = 'FULL{1},READONLY{ALL_SERVER}@zone1, FULL{1},READONLY{ALL_SERVER}@zone2, FULL{1},READONLY{ALL_SERVER}@zone3, FULL{1},READONLY{ALL_SERVER}@zone4, FULL{1},READONLY{ALL_SERVER}@zone5' PRIMARY_ZONE = 'zone1;zone2,zone3,zone4,zone5' BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10
1 row in set (0.01 sec)

obclient> 
obclient> alter table test_full locality='F,R{all_server}@zone1, F,R{all_server}@zone2, F,R{all_server}@zone3';
Query OK, 0 rows affected (0.12 sec)

obclient> show create table test_full\G
*************************** 1. row ***************************
       Table: test_full
Create Table: CREATE TABLE `test_full` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `dt` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.0' REPLICA_NUM = 3 LOCALITY = 'FULL{1},READONLY{ALL_SERVER}@zone1, FULL{1},READONLY{ALL_SERVER}@zone2, FULL{1},READONLY{ALL_SERVER}@zone3' PRIMARY_ZONE = 'zone1;zone2,zone3' BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10
1 row in set (0.02 sec)

obclient> exit
Bye
[admin@ob-docker my]$ obclient -h127.1 -uaps2@ora_test_tent#obdemo -P2883 -paps2#12345 -c -A aps2
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 167
Server version: 5.6.25 OceanBase 2.2.50 (r1-1c6441e8fb858c80da395f934f67ed305425864e) (Built Mar  6 2020 18:41:01)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient> show create table test_full\G
*************************** 1. row ***************************
       TABLE: TEST_FULL
CREATE TABLE: CREATE TABLE "TEST_FULL" (
  "ID" NUMBER(38) NOT NULL,
  "NAME" VARCHAR2(20) NOT NULL,
  "AGE" NUMBER(38),
  "DT" DATE DEFAULT sysdate,
  CONSTRAINT "TEST_FULL_OBPK_1616470329519050" PRIMARY KEY ("ID")
) COMPRESS FOR ARCHIVE REPLICA_NUM = 5 LOCALITY = 'FULL{1},READONLY{ALL_SERVER}@zone1, FULL{1},READONLY{ALL_SERVER}@zone2, FULL{1},READONLY{ALL_SERVER}@zone3, FULL{1},READONLY{ALL_SERVER}@zone4, FULL{1},READONLY{ALL_SERVER}@zone5' PRIMARY_ZONE = 'zone1;zone2,zone3,zone4,zone5' BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10
1 row in set (0.01 sec)

obclient>
obclient> alter table test_full locality='F,R{all_server}@zone1, F,R{all_server}@zone2, F,R{all_server}@zone3';
Query OK, 0 rows affected (0.07 sec)

obclient> show create table test_full\G
*************************** 1. row ***************************
       TABLE: TEST_FULL
CREATE TABLE: CREATE TABLE "TEST_FULL" (
  "ID" NUMBER(38) NOT NULL,
  "NAME" VARCHAR2(20) NOT NULL,
  "AGE" NUMBER(38),
  "DT" DATE DEFAULT sysdate,
  CONSTRAINT "TEST_FULL_OBPK_1616470329519050" PRIMARY KEY ("ID")
) COMPRESS FOR ARCHIVE REPLICA_NUM = 3 LOCALITY = 'FULL{1},READONLY{ALL_SERVER}@zone1, FULL{1},READONLY{ALL_SERVER}@zone2, FULL{1},READONLY{ALL_SERVER}@zone3' PRIMARY_ZONE = 'zone1;zone2,zone3' BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10
1 row in set (0.02 sec)

obclient> exit
Bye
[admin@ob-docker my]$ 


查看业务租户分区副本分布，此时业务租户下的复制表分区副本为3副本：
obclient> source part.sql
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
| tenant_id | tenant_name     | database_name | table_id         | table_Name | tablegroup_id | part_num | partition_Id | zone  | svr_ip        | svr_port | role | data_size_mb |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453777 | test       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453779 | test_full  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1001 | mysql_test_tent | testdb        | 1100611139453778 | test_hash  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081553 | TEST       |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081555 | TEST_FULL  |            -1 |        1 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            0 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone3 | 192.168.0.221 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            1 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            2 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone2 | 192.168.0.119 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone1 | 192.168.0.175 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            3 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone1 | 192.168.0.175 |     2882 |    1 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone2 | 192.168.0.119 |     2882 |    2 |            0 |
|      1002 | ora_test_tent   | APS2          | 1101710651081556 | TEST_HASH  |            -1 |        5 |            4 | zone3 | 192.168.0.221 |     2882 |    2 |            0 |
+-----------+-----------------+---------------+------------------+------------+---------------+----------+--------------+-------+---------------+----------+------+--------------+
42 rows in set (0.25 sec)

obclient> 


最后调整sys系统租户的副本数：
alter tenant sys locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';

示例如下：
obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list                     | locality                                                                  | primary_zone                  | gmt_modified               |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3;zone4;zone5 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 | zone1;zone2,zone3,zone4,zone5 | 2021-03-23 11:05:15.766319 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3             | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3                               | RANDOM                        | 2021-03-23 11:58:55.348423 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3             | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3                               | RANDOM                        | 2021-03-23 12:00:18.492501 |
+-----------+-----------------+--------------------+-------------------------------+---------------------------------------------------------------------------+-------------------------------+----------------------------+
3 rows in set (0.00 sec)

obclient> alter tenant sys locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3';
Query OK, 0 rows affected (0.05 sec)

obclient> 
obclient> source tent.sql
+-----------+-----------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
| tenant_id | tenant_name     | compatibility_mode | zone_list         | locality                                    | primary_zone      | gmt_modified               |
+-----------+-----------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
|         1 | sys             |                  0 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | zone1;zone2,zone3 | 2021-03-23 12:10:44.883926 |
|      1001 | mysql_test_tent |                  0 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | RANDOM            | 2021-03-23 11:58:55.348423 |
|      1002 | ora_test_tent   |                  1 | zone1;zone2;zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | RANDOM            | 2021-03-23 12:00:18.492501 |
+-----------+-----------------+--------------------+-------------------+---------------------------------------------+-------------------+----------------------------+
3 rows in set (0.01 sec)

obclient> 


到此，其实副本降级基本完成，如果目的是要下线某2个zone，则还需要执行以下两步，对租户的资源池释放、删除集群observer和集群ZONE数目降级，即下线掉2个ZONE。

(5.3)、调整资源池，释放租户在目标 zone 的资源池，包括业务租户和sys租户。
如果是每个zone单独的资源池，释放租户在目标 ZONE 的资源池时，每次只能释放一个。
alter tenant xxxx resource_pool_list=('pool1','pool2');
alter tenant xxxx resource_pool_list=('pool1');

本示例是所有zone使用同等规格的机器和资源池配置。只需要修改资源池zone的分布即可：
alter resource pool mysql_test_pool zone_list = ('zone1','zone2','zone3');
alter resource pool ora_test_pool zone_list = ('zone1','zone2','zone3');
alter resource pool sys_pool zone_list = ('zone1','zone2','zone3');

示例如下：
obclient> source pool.sql
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| resource_pool_name | unit_config_name | max_cpu | min_cpu | max_mem_gb | min_mem_gb | unit_id | zone  | observer           | tenant_id | tenant_name     |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       1 | zone1 | 192.168.0.175:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       2 | zone2 | 192.168.0.119:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       3 | zone3 | 192.168.0.221:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       4 | zone4 | 192.168.0.30:2882  |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       5 | zone5 | 192.168.0.58:2882  |         1 | sys             |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1001 | zone1 | 192.168.0.175:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1002 | zone2 | 192.168.0.119:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1003 | zone3 | 192.168.0.221:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1004 | zone4 | 192.168.0.30:2882  |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1005 | zone5 | 192.168.0.58:2882  |      1001 | mysql_test_tent |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1006 | zone1 | 192.168.0.175:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1007 | zone2 | 192.168.0.119:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1008 | zone3 | 192.168.0.221:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1009 | zone4 | 192.168.0.30:2882  |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1010 | zone5 | 192.168.0.58:2882  |      1002 | ora_test_tent   |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
15 rows in set (0.04 sec)

obclient> alter resource pool mysql_test_pool zone_list = ('zone1','zone2','zone3');
Query OK, 0 rows affected (0.04 sec)

obclient> alter resource pool ora_test_pool zone_list = ('zone1','zone2','zone3');
Query OK, 0 rows affected (0.01 sec)

obclient> alter resource pool sys_pool zone_list = ('zone1','zone2','zone3');
Query OK, 0 rows affected (0.02 sec)

obclient> 
obclient> source pool.sql
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| resource_pool_name | unit_config_name | max_cpu | min_cpu | max_mem_gb | min_mem_gb | unit_id | zone  | observer           | tenant_id | tenant_name     |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       1 | zone1 | 192.168.0.175:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       2 | zone2 | 192.168.0.119:2882 |         1 | sys             |
| sys_pool           | sys_unit_config  |       5 |     2.5 |          1 |          1 |       3 | zone3 | 192.168.0.221:2882 |         1 | sys             |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1001 | zone1 | 192.168.0.175:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1002 | zone2 | 192.168.0.119:2882 |      1001 | mysql_test_tent |
| mysql_test_pool    | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1003 | zone3 | 192.168.0.221:2882 |      1001 | mysql_test_tent |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1006 | zone1 | 192.168.0.175:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1007 | zone2 | 192.168.0.119:2882 |      1002 | ora_test_tent   |
| ora_test_pool      | my_unit_1c1g     |       1 |       1 |          1 |          1 |    1008 | zone3 | 192.168.0.221:2882 |      1002 | ora_test_tent   |
+--------------------+------------------+---------+---------+------------+------------+---------+-------+--------------------+-----------+-----------------+
9 rows in set (0.00 sec)

obclient> 

(5.4)、所有租户副本和资源池调整释放后，最后就是删除集群observer机器和 删除zone 。
删除observer:
alter system delete server '192.168.0.58:2882' zone zone5;
alter system delete server '192.168.0.30:2882' zone zone4;

示例如下：
obclient> source servers.sql
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone  | svr_ip        | svr_port | inner_port | with_rootserver | status | gmt_create                 | start_service_time         | build_version |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone1 | 192.168.0.175 |     2882 |       2881 |               1 | active | 2021-03-23 11:05:05.341939 | 2021-03-23 11:05:17.326593 | 2.2.50_1      |
| zone2 | 192.168.0.119 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.434825 | 2021-03-23 11:05:18.298162 | 2.2.50_1      |
| zone3 | 192.168.0.221 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.586951 | 2021-03-23 11:05:19.281431 | 2.2.50_1      |
| zone4 | 192.168.0.30  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.385910 | 2021-03-23 11:05:18.357579 | 2.2.50_1      |
| zone5 | 192.168.0.58  |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.614588 | 2021-03-23 11:05:19.285863 | 2.2.50_1      |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
5 rows in set (0.01 sec)

obclient>
obclient> alter system delete server '192.168.0.58:2882' zone zone5;
Query OK, 0 rows affected (0.12 sec)

obclient> alter system delete server '192.168.0.30:2882' zone zone4;
Query OK, 0 rows affected (0.13 sec)

obclient> source servers.sql
+-------+---------------+----------+------------+-----------------+----------+----------------------------+----------------------------+---------------+
| zone  | svr_ip        | svr_port | inner_port | with_rootserver | status   | gmt_create                 | start_service_time         | build_version |
+-------+---------------+----------+------------+-----------------+----------+----------------------------+----------------------------+---------------+
| zone1 | 192.168.0.175 |     2882 |       2881 |               1 | active   | 2021-03-23 11:05:05.341939 | 2021-03-23 11:05:17.326593 | 2.2.50_1      |
| zone2 | 192.168.0.119 |     2882 |       2881 |               0 | active   | 2021-03-23 11:05:04.434825 | 2021-03-23 11:05:18.298162 | 2.2.50_1      |
| zone3 | 192.168.0.221 |     2882 |       2881 |               0 | active   | 2021-03-23 11:05:04.586951 | 2021-03-23 11:05:19.281431 | 2.2.50_1      |
| zone4 | 192.168.0.30  |     2882 |       2881 |               0 | deleting | 2021-03-23 11:05:04.385910 | 2021-03-23 11:05:18.357579 | 2.2.50_1      |
| zone5 | 192.168.0.58  |     2882 |       2881 |               0 | deleting | 2021-03-23 11:05:04.614588 | 2021-03-23 11:05:19.285863 | 2.2.50_1      |
+-------+---------------+----------+------------+-----------------+----------+----------------------------+----------------------------+---------------+
5 rows in set (0.01 sec)

obclient>
obclient> source servers.sql
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone  | svr_ip        | svr_port | inner_port | with_rootserver | status | gmt_create                 | start_service_time         | build_version |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
| zone1 | 192.168.0.175 |     2882 |       2881 |               1 | active | 2021-03-23 11:05:05.341939 | 2021-03-23 11:05:17.326593 | 2.2.50_1      |
| zone2 | 192.168.0.119 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.434825 | 2021-03-23 11:05:18.298162 | 2.2.50_1      |
| zone3 | 192.168.0.221 |     2882 |       2881 |               0 | active | 2021-03-23 11:05:04.586951 | 2021-03-23 11:05:19.281431 | 2.2.50_1      |
+-------+---------------+----------+------------+-----------------+--------+----------------------------+----------------------------+---------------+
3 rows in set (0.00 sec)

obclient> 


删除zone:
alter system stop zone 'zone5';
alter system delete zone 'zone5';
alter system stop zone 'zone4';
alter system delete zone 'zone4';

注意：删除zone时，要先stop zone，只有inactive状态下才能delete zone，否则会报ERROR 4633 (HY000): zone status not match
并且每次只能一个一个的停止删除zone，如果停止多个zone会报错
ERROR 4660 (HY000): Can not stop server in multiple zones, there are already servers stopped in zone:cannnot stop zone while other stop task is in progress. wait for a moment


示例如下：
obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881784 | 2021-03-23 11:05:15.881784 | zone5 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881648 | 2021-03-23 11:05:15.881648 | zone5 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.882121 | 2021-03-23 11:05:15.882121 | zone5 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881895 | 2021-03-23 11:05:15.881895 | zone5 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.881602 | 2021-03-23 11:05:15.881602 | zone5 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881739 | 2021-03-23 11:05:15.881739 | zone5 | last_merged_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881693 | 2021-03-23 11:05:15.881693 | zone5 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881844 | 2021-03-23 11:05:15.881844 | zone5 | merge_start_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881999 | 2021-03-23 11:05:15.881999 | zone5 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.882059 | 2021-03-23 11:05:15.882059 | zone5 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.881558 | 2021-03-23 11:05:15.881558 | zone5 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881953 | 2021-03-23 11:05:15.881953 | zone5 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.882168 | 2021-03-23 11:05:15.882168 | zone5 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
82 rows in set (0.01 sec)

obclient> alter system delete zone 'zone5';
ERROR 4633 (HY000): zone status not match
obclient> 
obclient> alter system stop zone 'zone5';
Query OK, 0 rows affected (0.03 sec)

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881784 | 2021-03-23 11:05:15.881784 | zone5 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881648 | 2021-03-23 11:05:15.881648 | zone5 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.882121 | 2021-03-23 11:05:15.882121 | zone5 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881895 | 2021-03-23 11:05:15.881895 | zone5 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.881602 | 2021-03-23 11:05:15.881602 | zone5 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881739 | 2021-03-23 11:05:15.881739 | zone5 | last_merged_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881693 | 2021-03-23 11:05:15.881693 | zone5 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881844 | 2021-03-23 11:05:15.881844 | zone5 | merge_start_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881999 | 2021-03-23 11:05:15.881999 | zone5 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.882059 | 2021-03-23 11:05:15.882059 | zone5 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.881558 | 2021-03-23 13:15:18.668918 | zone5 | status                   |                1 | INACTIVE       |
| 2021-03-23 11:05:15.881953 | 2021-03-23 11:05:15.881953 | zone5 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.882168 | 2021-03-23 11:05:15.882168 | zone5 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
82 rows in set (0.00 sec)

obclient> alter system stop zone 'zone4';
ERROR 4660 (HY000): Can not stop server in multiple zones, there are already servers stopped in zone:cannnot stop zone while other stop task is in progress. wait for a moment
obclient> 
obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881784 | 2021-03-23 11:05:15.881784 | zone5 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881648 | 2021-03-23 11:05:15.881648 | zone5 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.882121 | 2021-03-23 11:05:15.882121 | zone5 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881895 | 2021-03-23 11:05:15.881895 | zone5 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.881602 | 2021-03-23 11:05:15.881602 | zone5 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881739 | 2021-03-23 11:05:15.881739 | zone5 | last_merged_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881693 | 2021-03-23 11:05:15.881693 | zone5 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881844 | 2021-03-23 11:05:15.881844 | zone5 | merge_start_time         | 1616468715881544 |                |
| 2021-03-23 11:05:15.881999 | 2021-03-23 11:05:15.881999 | zone5 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.882059 | 2021-03-23 11:05:15.882059 | zone5 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.881558 | 2021-03-23 13:15:18.668918 | zone5 | status                   |                1 | INACTIVE       |
| 2021-03-23 11:05:15.881953 | 2021-03-23 11:05:15.881953 | zone5 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.882168 | 2021-03-23 11:05:15.882168 | zone5 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
82 rows in set (0.01 sec)

obclient> 
obclient> alter system delete zone 'zone5';
Query OK, 0 rows affected (0.00 sec)

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 11:05:15.880929 | zone4 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
69 rows in set (0.01 sec)

obclient> alter system stop zone 'zone4';
Query OK, 0 rows affected (0.01 sec)

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.881173 | 2021-03-23 11:05:15.881173 | zone4 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.881019 | 2021-03-23 11:05:15.881019 | zone4 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.881467 | 2021-03-23 11:05:15.881467 | zone4 | idc                      |                0 |                |
| 2021-03-23 11:05:15.881263 | 2021-03-23 11:05:15.881263 | zone4 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880974 | 2021-03-23 11:05:15.880974 | zone4 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.881125 | 2021-03-23 11:05:15.881125 | zone4 | last_merged_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881064 | 2021-03-23 11:05:15.881064 | zone4 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.881218 | 2021-03-23 11:05:15.881218 | zone4 | merge_start_time         | 1616468715880916 |                |
| 2021-03-23 11:05:15.881375 | 2021-03-23 11:05:15.881375 | zone4 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.881422 | 2021-03-23 11:05:15.881422 | zone4 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880929 | 2021-03-23 13:16:14.050251 | zone4 | status                   |                1 | INACTIVE       |
| 2021-03-23 11:05:15.881322 | 2021-03-23 11:05:15.881322 | zone4 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.881512 | 2021-03-23 11:05:15.881512 | zone4 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
69 rows in set (0.00 sec)

obclient> alter system delete zone 'zone4';
Query OK, 0 rows affected (0.00 sec)

obclient> select * from __all_zone;
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| gmt_create                 | gmt_modified               | zone  | name                     | value            | info           |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
| 2021-03-23 11:05:15.877798 | 2021-03-23 11:05:15.877798 |       | cluster                  |                0 | obdemo         |
| 2021-03-23 11:05:15.878575 | 2021-03-23 13:13:16.040970 |       | config_version           | 1616476396004182 |                |
| 2021-03-23 11:05:15.878387 | 2021-03-23 11:05:15.878387 |       | frozen_time              |                0 |                |
| 2021-03-23 11:05:15.878316 | 2021-03-23 11:05:15.878316 |       | frozen_version           |                1 |                |
| 2021-03-23 11:05:15.878948 | 2021-03-23 11:05:15.878948 |       | gc_schema_version        |                0 |                |
| 2021-03-23 11:05:15.878437 | 2021-03-23 11:05:15.878437 |       | global_broadcast_version |                1 |                |
| 2021-03-23 11:05:15.878669 | 2021-03-23 11:05:15.878669 |       | is_merge_error           |                0 |                |
| 2021-03-23 11:05:15.878484 | 2021-03-23 11:05:15.878484 |       | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.878621 | 2021-03-23 13:13:16.041136 |       | lease_info_version       | 1616476396040607 |                |
| 2021-03-23 11:05:15.878719 | 2021-03-23 11:05:15.878719 |       | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.878530 | 2021-03-23 11:05:15.878530 |       | privilege_version        |                0 |                |
| 2021-03-23 11:05:15.878858 | 2021-03-23 11:05:15.878858 |       | proposal_frozen_version  |                1 |                |
| 2021-03-23 11:05:15.878903 | 2021-03-23 11:05:15.878903 |       | snapshot_gc_ts           |                0 |                |
| 2021-03-23 11:05:15.878994 | 2021-03-23 11:05:15.878994 |       | storage_format_version   |                3 |                |
| 2021-03-23 11:05:15.878812 | 2021-03-23 11:05:15.878812 |       | time_zone_info_version   |                0 |                |
| 2021-03-23 11:05:15.878236 | 2021-03-23 11:05:15.878236 |       | try_frozen_version       |                1 |                |
| 2021-03-23 11:05:15.878767 | 2021-03-23 11:05:15.878767 |       | warm_up_start_time       |                0 |                |
| 2021-03-23 11:05:15.879309 | 2021-03-23 11:05:15.879309 | zone1 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879151 | 2021-03-23 11:05:15.879151 | zone1 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.879604 | 2021-03-23 11:05:15.879604 | zone1 | idc                      |                0 |                |
| 2021-03-23 11:05:15.879408 | 2021-03-23 11:05:15.879408 | zone1 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879101 | 2021-03-23 11:05:15.879101 | zone1 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879249 | 2021-03-23 11:05:15.879249 | zone1 | last_merged_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879198 | 2021-03-23 11:05:15.879198 | zone1 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879361 | 2021-03-23 11:05:15.879361 | zone1 | merge_start_time         | 1616468715879028 |                |
| 2021-03-23 11:05:15.879499 | 2021-03-23 11:05:15.879499 | zone1 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.879545 | 2021-03-23 11:05:15.879545 | zone1 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879043 | 2021-03-23 11:05:15.879043 | zone1 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.879453 | 2021-03-23 11:05:15.879453 | zone1 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.879651 | 2021-03-23 11:05:15.879651 | zone1 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.879929 | 2021-03-23 11:05:15.879929 | zone2 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.879792 | 2021-03-23 11:05:15.879792 | zone2 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880216 | 2021-03-23 11:05:15.880216 | zone2 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880020 | 2021-03-23 11:05:15.880020 | zone2 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.879744 | 2021-03-23 11:05:15.879744 | zone2 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.879884 | 2021-03-23 11:05:15.879884 | zone2 | last_merged_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.879839 | 2021-03-23 11:05:15.879839 | zone2 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.879974 | 2021-03-23 11:05:15.879974 | zone2 | merge_start_time         | 1616468715879684 |                |
| 2021-03-23 11:05:15.880124 | 2021-03-23 11:05:15.880124 | zone2 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880171 | 2021-03-23 11:05:15.880171 | zone2 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.879698 | 2021-03-23 11:05:15.879698 | zone2 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880064 | 2021-03-23 11:05:15.880064 | zone2 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880261 | 2021-03-23 11:05:15.880261 | zone2 | zone_type                |                0 | ReadWrite      |
| 2021-03-23 11:05:15.880563 | 2021-03-23 11:05:15.880563 | zone3 | all_merged_version       |                1 |                |
| 2021-03-23 11:05:15.880427 | 2021-03-23 11:05:15.880427 | zone3 | broadcast_version        |                1 |                |
| 2021-03-23 11:05:15.880837 | 2021-03-23 11:05:15.880837 | zone3 | idc                      |                0 |                |
| 2021-03-23 11:05:15.880653 | 2021-03-23 11:05:15.880653 | zone3 | is_merge_timeout         |                0 |                |
| 2021-03-23 11:05:15.880381 | 2021-03-23 11:05:15.880381 | zone3 | is_merging               |                0 |                |
| 2021-03-23 11:05:15.880518 | 2021-03-23 11:05:15.880518 | zone3 | last_merged_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880473 | 2021-03-23 11:05:15.880473 | zone3 | last_merged_version      |                1 |                |
| 2021-03-23 11:05:15.880608 | 2021-03-23 11:05:15.880608 | zone3 | merge_start_time         | 1616468715880313 |                |
| 2021-03-23 11:05:15.880743 | 2021-03-23 11:05:15.880743 | zone3 | merge_status             |                0 | IDLE           |
| 2021-03-23 11:05:15.880788 | 2021-03-23 11:05:15.880788 | zone3 | region                   |                0 | default_region |
| 2021-03-23 11:05:15.880329 | 2021-03-23 11:05:15.880329 | zone3 | status                   |                2 | ACTIVE         |
| 2021-03-23 11:05:15.880698 | 2021-03-23 11:05:15.880698 | zone3 | suspend_merging          |                0 |                |
| 2021-03-23 11:05:15.880883 | 2021-03-23 11:05:15.880883 | zone3 | zone_type                |                0 | ReadWrite      |
+----------------------------+----------------------------+-------+--------------------------+------------------+----------------+
56 rows in set (0.00 sec)

obclient> 

到此，ob集群从5副本1-1-1-1-1架构降级为3副本1-1-1架构已完成。

下一篇实操OB集群副本的升级，从3副本1-1-1架构升级为5副本1-1-1-1-1架构。

一步一步学习oceanbase系列
oceanbase
最后修改时间：2021-04-09 15:37:50
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
文章被以下合辑收录

一步一步学习OceanBase系列（共28篇）
一步一步学习OceanBase系列
OceanBase 2.2集群实战第十四篇—— OB集群【副本降级】

文章被以下合辑收录

评论
