晓风
发布于

OushuDB数据库基本用法-启动/停止

启动/停止 OushuDB

切换到 gpadmin 用户

[root@MiWiFi-R3-srv ~]# su - gpadmin
Last login: Mon Apr 11 22:16:24 CST 2022 on pts/0

设置 OushuDB 环境变量

[gpadmin@MiWiFi-R3-srv ~]$ source /usr/local/hawq/greenplum_path.sh

方式一:集群操作

启动

启动整个 OushuDB 集群

[gpadmin@MiWiFi-R3-srv ~]$ hawq start cluster
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221221.log
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'cluster']
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the nodes in hawq cluster
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Starting master node 'localhost'
20221221:23:58:38:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start master service
20221221:23:58:56:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Master started successfully
20221221:23:58:56:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the segments in hawq cluster
20221221:23:58:56:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segments in list: ['localhost']
20221221:23:58:56:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segment service
20221221:23:58:56:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
.........
20221221:23:59:05:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 segments
20221221:23:59:05:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments started successfully
20221221:23:59:05:002874 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-HAWQ cluster started successfully

重启

重启整个 OushuDB 集群

[gpadmin@MiWiFi-R3-srv ~]$ hawq restart cluster
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:13:50:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'cluster']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:14:03:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:14:03:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq cluster
20221222:00:14:04:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-There are 0 connections to the database
20221222:00:14:04:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20221222:00:14:04:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master host=localhost
20221222:00:14:04:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq master
20221222:00:14:05:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master stopped successfully
20221222:00:14:05:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq segment
20221222:00:14:05:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop segments in list: ['localhost']
20221222:00:14:07:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
....
20221222:00:14:11:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 segments
20221222:00:14:11:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments stopped successfully
20221222:00:14:11:003213 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Cluster stopped successfully
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221222.log
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'cluster']
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the nodes in hawq cluster
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Starting master node 'localhost'
20221222:00:14:11:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start master service
20221222:00:14:12:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Master started successfully
20221222:00:14:12:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the segments in hawq cluster
20221222:00:14:12:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segments in list: ['localhost']
20221222:00:14:12:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segment service
20221222:00:14:12:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
...
20221222:00:14:15:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 segments
20221222:00:14:15:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments started successfully
20221222:00:14:15:003404 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-HAWQ cluster started successfully

停止

停止整个 OushuDB 集群

[gpadmin@MiWiFi-R3-srv ~]$ hawq stop cluster
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:15:17:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'cluster']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:15:20:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:15:20:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq cluster
20221222:00:15:21:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-There are 0 connections to the database
20221222:00:15:21:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20221222:00:15:21:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master host=localhost
20221222:00:15:21:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq master
20221222:00:15:22:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master stopped successfully
20221222:00:15:22:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq segment
20221222:00:15:22:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop segments in list: ['localhost']
20221222:00:15:23:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
...
20221222:00:15:26:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 segments
20221222:00:15:26:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments stopped successfully
20221222:00:15:26:003586 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Cluster stopped successfully

方式二:分别操作 OushuDB master 和 segment

因为 OushuDB master 和 segment 是解耦合的,分别操作 master 和 segment 是可行的。

启动

分别启动 OushuDB master 和 segment

启动 master

[gpadmin@MiWiFi-R3-srv ~]$ hawq start master
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221222.log
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'master']
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:17:50:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start master service
20221222:00:17:52:003785 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Master started successfully

启动 segment

[gpadmin@MiWiFi-R3-srv ~]$ hawq start segment
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221222.log
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'segment']
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:19:16:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segment service
20221222:00:19:18:003860 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Segment started successfully

重启

重启 master

[gpadmin@MiWiFi-R3-srv ~]$ hawq restart master
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:20:57:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:20:59:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:21:00:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-There are 0 connections to the database
20221222:00:21:00:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20221222:00:21:00:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master host=localhost
20221222:00:21:00:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq master
20221222:00:21:01:003958 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master stopped successfully
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221222.log
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'master']
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:21:01:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start master service
20221222:00:21:02:004036 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Master started successfully

重启 segment

[gpadmin@MiWiFi-R3-srv ~]$ hawq restart segment
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:21:55:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'segment']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:21:57:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:21:58:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq segment
20221222:00:22:00:004107 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Segment stopped successfully
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221222.log
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'segment']
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:22:00:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segment service
20221222:00:22:02:004186 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Segment started successfully

停止

停止 master

[gpadmin@MiWiFi-R3-srv ~]$ hawq stop master
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:23:01:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:23:03:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:23:04:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-There are 0 connections to the database
20221222:00:23:04:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20221222:00:23:04:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master host=localhost
20221222:00:23:04:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq master
20221222:00:23:05:004277 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master stopped successfully

停止 segment

[gpadmin@MiWiFi-R3-srv ~]$ hawq stop segment
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221222.log
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221222:00:23:41:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'segment']

Continue with HAWQ service stop Yy|Nn (default=N):
> y
20221222:00:23:42:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221222:00:23:42:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[WARNING]:-Failed to connect to database, cannot get hawq_acl_type
20221222:00:23:43:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq segment
20221222:00:23:44:004368 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Segment stopped successfully

启动/停止 HDFS

启动

[gpadmin@MiWiFi-R3-srv ~]$ start-dfs.sh

停止

[gpadmin@MiWiFi-R3-srv ~]$ stop-dfs.sh

启动/停止 magma

方式一:集群带 magma 操作

启动

[gpadmin@MiWiFi-R3-srv ~]$ hawq start cluster -a --with_magma
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq start'
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_start_20221223.log
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start hawq with args: ['start', 'cluster']
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Gathering information and validating the environment...
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the nodes in hawq cluster
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Starting master node 'localhost'
20221223:03:32:06:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start master service
20221223:03:32:08:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Master started successfully
20221223:03:32:08:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start all the segments in hawq cluster
20221223:03:32:08:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segments in list: ['localhost']
20221223:03:32:08:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start segment service
20221223:03:32:08:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
...
20221223:03:32:11:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 segments
20221223:03:32:11:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments started successfully
20221223:03:32:11:004007 hawq_start:MiWiFi-R3-srv:gpadmin-[INFO]:-HAWQ cluster started successfully
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'magma start'
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/magma_start_20221223.log
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: nodes_file is set
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_data_directory is set
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_log_directory is set
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_address_port is set
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start magma service on all nodes
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-mkdir -p /home/gpadmin/hawqAdminLogs; source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=start --listen=localhost:6666 --datadirs=file:///data/workspace/oushudb-data/magma_segment --logdir=/data/workspace/oushudb-data/magma_log --replica=3 --range=2 --datadir_capacity=3 >> /home/gpadmin/hawqAdminLogs/magma_start_20221223.log 2>&1
20221223:03:32:11:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start magma node on host: localhost
20221223:03:32:13:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 magma nodes

20221223:03:32:13:004161 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Magma service start successfully

停止

[gpadmin@MiWiFi-R3-srv ~]$ hawq stop cluster -a --with_magma
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'hawq stop'
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20221223.log
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'cluster']
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-No standby host configured
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq cluster
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-There are 0 connections to the database
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master host=localhost
20221223:03:33:54:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq master
20221223:03:33:56:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Master stopped successfully
20221223:03:33:56:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop hawq segment
20221223:03:33:56:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Stop segments in list: ['localhost']
20221223:03:33:57:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Total segment number is: 1
...
20221223:03:34:00:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 segments
20221223:03:34:00:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Segments stopped successfully
20221223:03:34:00:004355 hawq_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Cluster stopped successfully
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'magma stop'
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/magma_stop_20221223.log
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: nodes_file is set
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_data_directory is set
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_log_directory is set
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_address_port is set
20221223:03:34:00:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop all magma nodes
20221223:03:34:01:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=stop --stopmode=fast --logdir=/data/workspace/oushudb-data/magma_log >> /home/gpadmin/hawqAdminLogs/magma_stop_20221223.log 2>&1
20221223:03:34:07:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 magma nodes
20221223:03:34:07:004636 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Magma service stop successfully

方式二:单独操作 magma

启动

[gpadmin@MiWiFi-R3-srv ~]$ magma start cluster
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'magma start'
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/magma_start_20221223.log
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: nodes_file is set
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_data_directory is set
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_log_directory is set
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_address_port is set
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start magma service on all nodes
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-mkdir -p /home/gpadmin/hawqAdminLogs; source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=start --listen=localhost:6666 --datadirs=file:///data/workspace/oushudb-data/magma_segment --logdir=/data/workspace/oushudb-data/magma_log --replica=3 --range=2 --datadir_capacity=3 >> /home/gpadmin/hawqAdminLogs/magma_start_20221223.log 2>&1
20221223:03:24:29:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Start magma node on host: localhost
20221223:03:24:31:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 magma nodes
..
20221223:03:24:36:002883 magma_start:MiWiFi-R3-srv:gpadmin-[INFO]:-Magma service start successfully

重启

[gpadmin@MiWiFi-R3-srv ~]$ magma restart cluster
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'magma restart'
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/magma_restart_20221223.log
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: nodes_file is set
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_data_directory is set
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_log_directory is set
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_address_port is set
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-stop all magma nodes
20221223:03:27:18:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=stop --stopmode=fast --logdir=/data/workspace/oushudb-data/magma_log >> /home/gpadmin/hawqAdminLogs/magma_restart_20221223.log 2>&1
20221223:03:27:25:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 magma nodes
20221223:03:27:25:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-start magma service on all nodes
20221223:03:27:25:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-mkdir -p /home/gpadmin/hawqAdminLogs; source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=start --listen=localhost:6666 --datadirs=file:///data/workspace/oushudb-data/magma_segment --logdir=/data/workspace/oushudb-data/magma_log --replica=3 --range=2 --datadir_capacity=3 >> /home/gpadmin/hawqAdminLogs/magma_restart_20221223.log 2>&1
20221223:03:27:25:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Start magma node on host: localhost
20221223:03:27:27:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-start 1 of 1 magma nodes

20221223:03:27:28:003053 magma_restart:MiWiFi-R3-srv:gpadmin-[INFO]:-Magma service restart successfully

停止

[gpadmin@MiWiFi-R3-srv ~]$ magma stop cluster
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Prepare to do 'magma stop'
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-You can find log in:
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/magma_stop_20221223.log
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-GPHOME is set to:
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-/usr/local/hawq/.
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: nodes_file is set
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_data_directory is set
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_log_directory is set
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Check: node_address_port is set
20221223:03:27:42:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop all magma nodes
20221223:03:27:43:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-source /usr/local/hawq/./greenplum_path.sh; /usr/local/hawq/./bin/magma_ctl --ctl=stop --stopmode=fast --logdir=/data/workspace/oushudb-data/magma_log >> /home/gpadmin/hawqAdminLogs/magma_stop_20221223.log 2>&1
20221223:03:27:50:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-stop 1 of 1 magma nodes
20221223:03:27:50:003290 magma_stop:MiWiFi-R3-srv:gpadmin-[INFO]:-Magma service stop successfully
评论
    test