金仓数据库KingbaseES V8R6集群修改data目录

案例说明：
本案例是在部署完成KingbaseES R6集群后，由于业务的需求，集群需要修改data（数据存储）目录的测试。本案例分两种修改方式，第一种是离线修改data目录，即关闭整个集群后，修改数据库存储data目录；第二种是在线修改，在集群正常运行的情况下，修改数据存储data目录，一般可用于生产环境。
数据库版本

集群架构：

案例1：离线修改数据存储data目录
一、查看集群节点状态和配置信息
1、集群节点状态
[kingbase@node3 bin]$ ./repmgr cluster show
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string
----±--------±--------±----------±---------±---------±---------±---------±-----------------------
1 | node248 | primary | * running | | default | 100 | 29 | host=192.168.7.248 user=esrep dbname=esrep port=54321 connect_timeout=10 keepalives=1 keepalives_idle=10 keepalives_interval=1 keepalives_count=2
3 | node243 | standby | running | node248 | default | 110 | 29 | host=192.168.7.243 user=esrep dbname=esrep port=54321 connect_timeout=10 keepalives=1 keepalives_idle=10 keepalives_interval=1 keepalives_count=2
2、集群data目录配置信息
=== 对于R6的集群，data目录的配置非常简单，只在repmgr.conf文件中。===
[kingbase@node3 bin]$ cat …/etc/repmgr.conf |grep -i datadata_directory=‘/home/kingbase/cluster/R6HA/KHA/kingbase/data’

二、停止集群和数据库服务
[kingbase@node3 bin]$ ./sys_monitor.sh stop2021-03-01 12:28:00 Ready to stop all DB …
Service process “node_export” was killed at process 13139
……

三、迁移data目录到指定位置（所有节点）
1、迁移data目录
#创建新的data目录
[kingbase@node3 kingbase]$ mkdir -p /data/kingbase/cluster/v8r6``
#拷贝data目录到指定位置

[kingbase@node3 kingbase]$ cp -var data /data/kingbase/cluster/v8r6
……
‘data/standby.signal’ -> ‘/data/kingbase/cluster/v8r6/data/standby.signal’
‘data/kingbase.auto.conf’ -> ‘/data/kingbase/cluster/v8r6/data/kingbase.auto.conf’
‘data/kingbase.opts’ -> ‘/data/kingbase/cluster/v8r6/data/kingbase.opts’
‘data/backup_label.old’ -> ‘/data/kingbase/cluster/v8r6/data/backup_label.old’
‘data/current_logfiles’ -> ‘/data/kingbase/cluster/v8r6/data/current_logfiles’
2、编辑repmgr.conf文件
=== 在repmgr.conf文件中，指定新的data目录位置。===
[kingbase@node3 bin]$ cat …/etc/repmgr.conf |grep -i datadata_directory=‘/data/kingbase/cluster/v8r6/data’#data_directory=‘/home/kingbase/cluster/R6HA/KHA/kingbase/data’

四、启动集群和数据库服务
[kingbase@node3 bin]$ ./sys_monitor.sh start2021-03-01 12:36:29 Ready to start all DB …2021-03-01 12:36:29 begin to start DB on “[192.168.7.243]”.
waiting for server to start… done
server started
…2021-03-01 12:37:00 repmgrd on “[192.168.7.243]” start success.
ID | Name | Role | Status | Upstream | repmgrd | PID | Paused? | Upstream last seen----±--------±--------±----------±---------±--------±------±--------±-------------------
1 | node248 | primary | * running | | running | 19243 | no | n/a
3 | node243 | standby | running | node248 | running | 10859 | no | 0 second(s) ago 2021-03-01 12:37:06 Done.
五、查看数据库服务进程
=集群启动后，数据库服务已经自动读取到新的data目录配置信息。=
[kingbase@node3 bin]$ ps -ef |grep kingbasekingbase 10172 1 0 12:36 ? 00:00:00 /home/kingbase/cluster/R6HA/KHA/kingbase/bin/kingbase -D /data/kingbase/cluster/v8r6/datakingbase 10184 10172 0 12:36 ? 00:00:00 kingbase: logger kingbase 10185 10172 0 12:36 ? 00:00:00 kingbase: startup recovering 0000001D000000060000000Fkingbase 10186 10172 0 12:36 ? 00:00:00 kingbase: checkpointer kingbase 10187 10172 0 12:36 ? 00:00:00 kingbase: background writer kingbase