GaussDB-集群数据库变为只读模式ReadOnly（实验）`ERROR: cannot execute CREATE TABLE in a read-only transaction`

最新推荐文章于 2024-01-03 12:49:23 发布

MM不要山

最新推荐文章于 2024-01-03 12:49:23 发布

阅读量6.3k

点赞数 1

文章标签：数据库

本文链接：https://blog.csdn.net/m0_46400195/article/details/127996194

版权

为了验证实验，先把集群的磁盘占用率改为50%

[omm@gaussdb01 ~]$ gs_guc reload -Z cmserver -N all -I all -c "datastorage_threshold_value_check=50"
The gs_guc run with the following arguments: [gs_guc -Z cmserver -N all -I all -c datastorage_threshold_value_check=50 reload ].
Begin to perform the total nodes: 3.
Popen count is 3, Popen success count is 3, Popen failure count is 0.
Begin to perform gs_guc for cm_servers.
Command count is 3, Command success count is 3, Command failure count is 0.

Total instances: 3. Failed instances: 0.
ALL: Success to perform gs_guc!

在这里插入图片描述
查询现在磁盘占用率

[root@gaussdb01 cm_server]# cat  /data/cluster/data/cm/cm_server/cm_server.conf | grep datastorage_threshold_value_check
datastorage_threshold_value_check = 50

在这里插入图片描述

1、查看集群状态

[omm@gaussdb01 ~]$ cm_ctl query -Cvipd

2、创建用户

新建用户
openGauss=# create user lily password 'qwe123QWE';
CREATE ROLE
给用户授权
openGauss=# grant all privileges to lily;
ALTER ROLE
给lily用户对数据库有登录权限
openGauss=# grant connect on database test1 to lily;
GRANT

2、创建表空间和数据库

使用新建用户进行数据库登录
[omm@gaussdb01 ~]$ gsql -d test1 -U lily -W'qwe123QWE' -p 30100 -r
gsql ((GaussDB Kernel V500R002C10 build 04860477) compiled at 2022-10-28 20:04:35 commit 3892 last mr 8894 release)
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for he

最低0.47元/天解锁文章