GBase8a版本回退操作注意事项

当Gbase8a9.5.3.27.20-patch.1回退至9.5.3.23.2时涉及的版本跨度较大，涉及到gbase系统数据库中的表结构不一致，因此无法无法直接通过gcinstall.py的方式进行。建议按以下步骤进行操作，保证版本顺利回退。

注：本文中管理节点为192.168.59.142,192.168.59.143,192.168.59.144，数据节点为192.168.59.151,192.168.59.152

1.停止集群服务

    cexec all: 'gcluster_services all stop'
    cexec coor: 'gcware_services all stop'

2.创建备份文件解压目录

    mkdir -p /tmp/backup_extract 

3.解压管理节点备份文件 

   tar xvf /home/gbase/gcluster_backup_multi_9.5.3.23.28416dc2_20240326124815_192.168.59.142.tar.bz2 -C /tmp/backup_extract/  

4.将文件复制到相应管理节点

   创建备份目录：
    cexec coor: 'mkdir -p /opt/gbase_workspace/notes/20240326/gcluster'    
    cd  /tmp/backup_extract/opt/*/gcluster/userdata/gcluster/gbase/ 
    管理节点循环执行：
    for ip in 142,143,144     
    do
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gcluster/userdata/gcluster/gbase/user.* /opt/gbase_workspace/notes/20240326/gcluster'
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gcluster/userdata/gcluster/gbase/tables_priv.* /opt/gbase_workspace/notes/20240326/gcluster'
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gcluster/userdata/gcluster/gbase/vcs_priv.* /opt/gbase_workspace/notes/20240326/gcluster'
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gcluster/userdata/gcluster/gbase/db.* /opt/gbase_workspace/notes/20240326/gcluster'
        scp user.* tables_priv.* vcs_priv.* db.*  192.168.59.${ip}:/opt/192.168.59.${ip}/gcluster/userdata/gcluster/gbase/
    done  

5.解压数据节点备份文件 

   从第一个数据节点复制备份文件到管理节点
    scp 192.168.59.151:/home/gbase/gcluster_backup_multi_9.5.3.23.28416dc2_20240326124815_192.168.59.151.tar.bz2 /tmp 
   tar xvf /tmp/gcluster_backup_multi_9.5.3.23.28416dc2_20240326124815_192.168.59.151.tar.bz2 -C /tmp/backup_extract/  

6 将文件复制到相应数据节点

   cexec data: '/opt/gbase_workspace/notes/20240326/gnode         
    cd  /tmp/backup_extract/opt/*/gnode/userdata/gbase/gbase/ 
    数据节点循环执行：
    for ip in 151 152
    do
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gnode/userdata/gbase/gbase/user.* /opt/gbase_workspace/notes/20240326/gnode'
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gnode/userdata/gbase/gbase/tables_priv.* /opt/gbase_workspace/notes/20240326/gnode'
        ssh 192.168.59.${ip} 'cp /opt/192.168.59.${ip}/gnode/userdata/gbase/gbase/db.* /opt/gbase_workspace/notes/20240326/gnode'
        scp user.* tables_priv.* db.*  192.168.59.${ip}:/opt/192.168.59.${ip}/gnode/userdata/gbase/gbase/
    done

7. 启动集群服务

       cexec coor: 'gcware_services all start'
       cexec all: 'gcluster_services all start'