KingbaseES V8R6集群部署案例---指定数据库字符集脚本部署

案例说明：
KingbaseES V8R6集群通过脚本部署，默认字符集是utf-8，可以通过修改部署配置参数支持其他类型的字符集。适用版本： KingbaseES V8R6

一、部署故障案例
1、在执行部署脚本时出现以下故障：

2、查看install.conf配置

3、查看系统字符集

[kingbase@node101 r6_install]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

从以上内容可以获悉，部署时指定的字符集‘gbk’和目前系统的字符集‘utf8’不兼容，导致部署失败。

二、配置系统字符集
1、修改字符集配置文件

[kingbase@node101 r6_install]$ cat /etc/locale.conf
LANG="zh_CN.gbk"

2、重启系统后查看字符集

如下所示，系统字符集为gbk：

[root@node101 ~]# locale
LANG=zh_CN.gbk
LC_CTYPE="zh_CN.gbk"
LC_NUMERIC="zh_CN.gbk"
LC_TIME="zh_CN.gbk"
LC_COLLATE="zh_CN.gbk"
LC_MONETARY="zh_CN.gbk"
LC_MESSAGES="zh_CN.gbk"
LC_PAPER="zh_CN.gbk"
LC_NAME="zh_CN.gbk"
LC_ADDRESS="zh_CN.gbk"
LC_TELEPHONE="zh_CN.gbk"
LC_MEASUREMENT="zh_CN.gbk"
LC_IDENTIFICATION="zh_CN.gbk"
LC_ALL=

三、部署集群
1、配置install.conf

[kingbase@node101 r6_install]$ cat install.conf
[install]
......
db_encoding="gbk"                   # Cararcter set encoding to use in the new database.Specify a tring constant,or an integer encoding number, default value provided by locale command.
db_collate=""                    # Collation order(LC_COLLATE) to use in the new database,This affects the sort order applied to strings, default value provided by locale command.
db_ctype=""
......

2、执行脚本部署

[kingbase@node101 r6_install]$ sh cluster_install.sh
[CONFIG_CHECK] will deploy the cluster of DG
[CONFIG_CHECK] checking db_encoding:gbk exists on 192.168.1.101 ....OK
[CONFIG_CHECK] checking db_encoding:gbk exists on 192.168.1.102 ....OK
[CONFIG_CHECK] checking db_encoding:gbk ...
[CONFIG_CHECK] checking db_encoding:gbk,utf-8 should be set as utf8  ...OK
[CONFIG_CHECK] comparing gbk  with gbk   ...
[CONFIG_CHECK] comparing gbk  with gbk   ...OK
[CONFIG_CHECK] comparing gbk  with gbk   ...
[CONFIG_CHECK] comparing gbk  with gbk   ...OK
........
2023-08-16 11:56:29 repmgrd on "[192.168.1.102]" start success.
 ID | Name  | Role    | Status    | Upstream | repmgrd | PID   | Paused? | Upstream last seen
----+-------+---------+-----------+----------+---------+-------+---------+--------------------
 1  | node1 | primary | * running |          | running | 10374 | no      | n/a
 2  | node2 | standby |   running | node1    | running | 8825  | no      | 1 second(s) ago
[2023-08-16 11:56:30] [NOTICE] redirecting logging output to "/home/kingbase/cluster/R6HA/ha/kingbase/log/kbha.log"
 
[2023-08-16 11:56:32] [NOTICE] redirecting logging output to "/home/kingbase/cluster/R6HA/ha/kingbase/log/kbha.log"
 
2023-08-16 11:56:34 Done.
[INSTALL] start up the whole cluster ... OK

3、查看数据库字符集

test=# show server_encoding ;
 server_encoding
-----------------
 GBK
(1 row)
 
test=# \l+
 
                                                             List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges |  Size  | Tablespace  |            Description
-----------+--------+----------+-------------+-------------+-------------------+--------+-------------+------------------------------------
 esrep     | system | GBK      | zh_CN.gbk | zh_CN.gbk |                   | 13 MB | sys_default |
 kingbase  | system | GBK      | zh_CN.gbk | zh_CN.gbk |                   | 13 MB | sys_default | default administrative connection database
 security  | system | GBK      | zh_CN.gbk | zh_CN.gbk |                   | 13 MB | sys_default |
 template0 | system | GBK      | zh_CN.gbk | zh_CN.gbk | =c/system        +| 13 MB | sys_default | unmodifiable empty database
           |        |          |           |           | system=CTc/system |       |             |
 template1 | system | GBK      | zh_CN.gbk | zh_CN.gbk | =c/system        +| 13 MB | sys_default | default template for new databases
           |        |          |           |           | system=CTc/system |       |             |
 test      | system | GBK      | zh_CN.gbk | zh_CN.gbk |                   | 13 MB | sys_default | default administrative connection database
(6 rows)

四、总结
KingbaseES V8R6集群部署支持utf-8、gbk等字符集，在通过脚本部署时，注意配置文件只当的字符集需要和系统的字符集匹配。
完整的脚本部署集群参考：https://www.cnblogs.com/tiany1224/p/16304701.html