OceanBase SQL语句REPLICA

描述

该语句用来处理副本的迁移，复制，删除，副本类型转换，角色切换等行为。

该语句仅支持在 sys 租户执行。

语法

alter_system_replica_stmt:
    ALTER SYSTEM replica_action;

replica_action:
      SWITCH REPLICA {LEADER | FOLLOWER}
        { partition_id_desc SERVER [=] 'ip:port' 
          | SERVER [=] 'ip:port' [tenant_name] 
          | ZONE [=] 'zone' [tenant_name]
          }
    | DROP REPLICA partition_id_desc SERVER [=] 'ip:port'
         [ZONE [=] 'zone'] [FORCE]
    | {MOVE | COPY} REPLICA partition_id_desc 
         SOURCE [=] 'ip:port' DESTINATION [=] 'ip:port'
    | REPORT REPLICA  partition_id_desc 
         {ZONE [=] 'zone' | SERVER [=] 'ip:port'}
    | {ALTER | CHANGE | MODIFY} REPLICA 
         partition_id_desc SERVER [=] 'ip:port'
         [SET] REPLICA_TYPE = replica_type

partition_id_desc
    PARTITION_ID [=] 'partition_id%partition_cnt@table_id' 

partition_id | partition_cnt | table_id | task_id:
    INT_VALUE

tenant_name_list:
    tenant_name [, tenant_name ...]

tenant_name:
    TENANT [=] tenant

replica_type:
      {Full | F}
    

参数解释

示例

• 将分区 ID 为 0%0@1100611139403777 的副本从 xxx.xx.xx.xx1 迁移至 xxx.xx.xx.xx2。

  obclient> ALTER SYSTEM MOVE REPLICA PARTITION_ID '0%0@1100611139403777'
  SOURCE 'xxx.xx.xx.xx1:xxxx'
  DESTINATION 'xxx.xx.xx.xx2:xxxx';
  

• 删除分区 ID 为 0%0@1100611139403777 的副本。

  obclient> ALTER SYSTEM DROP REPLICA PARTITION_ID '0%0@1100611139403777'
  SERVER 'xxx.xx.xx.xx1:xxxx';