GaussDB安裝

環(huán)境準(zhǔn)備

1、關(guān)閉防火墻

systemctl stop firewalld

2、關(guān)閉selinux

臨時(shí)禁用：setenforce 0

永久關(guān)閉：

vi /etc/selinux/config
SELINUX=disabled

reboot

3、修改系統(tǒng)環(huán)境字符集

echo $LANG

export LANG=en_US.UTF-8

永久修改

vi /etc/profile

添加 export LANG=en_US.UTF-8

source /etc/profile

4、設(shè)置時(shí)區(qū)和時(shí)間

cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

5、關(guān)閉交換區(qū)

swapoff -a

6、修改hosts

ip hostname

7、安裝或升級(jí)Python3.7.9 強(qiáng)依賴，不知道更高版本行不行

安裝過程

1、解壓安裝腳本

tar -xvf GaussDBInstaller_Vx.x.x.x.tar.gz

2、解壓安裝包到安裝腳本的pkgDir目錄下

tar -xvf GaussDB_X86_Kylinv10_Centralized_2.23.01.220_20230609012225.tar.gz -C /root/GaussDBInstaller/GaussDBInstaller/pkgDir/

3、配置install_cluster.conf

vi /root/GaussDBInstaller/GaussDBInstaller/

4、復(fù)制安裝模式j(luò)son文件到 GaussDBInstaller 根目錄下（本次為集中部署）,修改配置文件

cp jsonFileSample/3_nodes_centralized.json ./install_cluster.json

vi install_cluster.json

{
    "rdsAdminUser": "rdsAdmin",        #管理員賬號(hào)
    "rdsAdminPasswd": "xxx",
    "rdsMetricUser": "metricUser",
    "rdsMetricPasswd": "xxx",
    "rdsReplUser": "repUser",
    "rdsReplPasswd": "xxx",
    "rdsBackupUser": "backupUser",
    "rdsBackupPasswd": "xxx",
    "dbPort":"30100",                #DB端口
    "dbUser": "root",                #給用戶分配的最高權(quán)限賬戶
    "dbUserPasswd": "xxx",
    "clusterMode": "ha",
    "params": {
        "enable_thread_pool": "off"
    },
    "cnParams": {},
    "dnParams": {},
    "cmParams": {},
    "clusterConf": {
        "clusterName": "GaussDB",
                "gtmFree": 1,
                "encoding": "utf8",
                "shardingNum": 1,
                "replicaNum": 1,
                "solution": "hws",
                "shards": [
                        [{
                        "rack": "kylinv10sp3",
                        "az": "AZ1",
                        "ip": "xxx",
            "dataIp": "xxx",
            "virtualIp":"xxx"
                        }
                ]],
                "cm": [
                        {
                        "rack": "kylinv10sp3",
                        "az": "AZ1",
                        "ip": "xxx",
            "dataIp": "xxx",
            "virtualIp":"xxx"
                        }
                ]
    }
}

5、安裝

python3 gaussdb_install.py --action main

6、非必須的配置，允許自定義創(chuàng)建函數(shù)，切換 omm用戶執(zhí)行

gs_guc reload -Z coordinator -Z datanode -N all -I all -c "behavior_compat_options='skip_insert_gs_source,forbid_package_function_with_prefix,enable_bpcharlikebpchar_compare,enable_crosstype_integer_operator'";

7、卸載重裝

ldconfig

userdel omm
rm -rf /home/omm

rm -rf /opt/gaussdb

chown root:root /root/Gaussxxxx

查看集群狀態(tài)執(zhí)行命令

source ~/gauss_env_file
cm_ctl query -Cvipd

查看集群狀態(tài)
cm_ctl query -Cv

查看集群狀態(tài)（包括實(shí)例目錄）
cm_ctl query -Cvd

查看集群不均衡的實(shí)例
cm_ctl query -Cvs

啟動(dòng)集群
cm_ctl start

停止集群
cm_ctl stop

cm_ctl stop -mi

主備切換
cm_ctl switchover -n 1 -D /srv/BigData/mppdb/data1/slave2

均衡整個(gè)集群
cm_ctl switchover -a

posted @ 2024-08-06 17:56 小清澈閱讀(675) 評(píng)論(0) 收藏舉報(bào)

刷新頁(yè)面返回頂部

小清澈

思考，改變自己

GaussDB安裝

公告