This article introduces a case where parameter adjustments made for business needs led to performance anomalies in other business areas. It includes the investigation and analysis processes.
Category: GBase8a for Everyday Use
类似使用手册,普通的各种功能的使用方法,SQL语法,函数的功能介绍,各种工具的常规使用等。一些疑难杂症归类到常见疑问里。
When filtering with a `WHERE` clause on a de-sensitized column in GBase 8a, is the data original or de-sensitized?
GBase 8a cluster supports data masking to ensure the security of sensitive data. Regarding filtering with WHERE clauses, grouping, and other operations on masked data, are these operations performed on the original data or on the masked data?
GBase 8a cluster troubleshooting related commands
When GBase 8a experiences occasional issues during stable operation, most are caused by [reason]. This article introduces the most common troubleshooting commands to pinpoint the fault location.
GDOM New Installation Scheme with PostgreSQL as Repository
GDOM (GBase Database Operation Manager) is the Nanjing General Technology GBase 8a MPP database operation and maintenance management system. Starting from version GDOM 3.7.0, in addition to supporting MySQL 8 as a resource repository, it now also supports PostgreSQL. This article introduces the installation solution for GDOM's automatic deployment of PostgreSQL as a resource repository.
GDOM processing of repository, analysis library, or historical database user or password change plan
GDOM connects to three databases. The real-time database and historical database are GBASE8a standalone by default. The resource database can be PostgreSQL or MySQL. If the IP addresses, usernames, or passwords of these databases change, you will need to make corresponding modifications in GDOM to continue using them normally.
南大通用GDOM 导入已经存在的集群
本文介绍南大通用GDOM工具导入已经存在集群的方法,包括全新安装GDOM后,首次登录的情况。
GVR 同步任务结果三种颜色数字的含义
GBase Visio Rsynctool(缩写为GVR)是南大通用GBase 可视化集群双活同步工具软件。同步任务完成后,根据同步结果用不同的颜色表示,其中绿色为完成,橙色为跳过,红色为错误。
GBase Visio Rsynctool(GVR)的快速部署和配置
GBase Visio Rsynctool(缩写为GVR)是GBase 可视化集群双活同步工具软件。是对2套集群间同步数据工具Rsynctools的可视化封装。本文包括该工具的快速部署方案以及各种配置的介绍。
GBase 8a通过gcadmin recover命令管理同步任务,设置vc优先恢复
gcrecover是GBase 8a集群内置的,用于恢复集群event的服务,部署在每个管理(gcluster)节点上。通过gcadmin recover命令,实现暂停,恢复同步工作,设置或取消某个VC优先恢复等功能。
GBase 8a加载支持不同日期列格式也不同的情况
GBase 8a的加载日期数据时,可以指定日期的格式,比如年月日。如果1份数据里,不同的列日期格式也不一样,比如第一个date列是年月日,第二个date列是月日年,本文介绍在这种情况下的GBase 8a加载方案。