#!/bin/bash
code=/usr1/zcz_dd/workspace/dd_dir
dd_home=/usr1/zcz_dd/workspace/dd_home
dsspath=$dd_home/dss
datapath=$dd_home/data
source $dd_home/dd_env
dbhost=20.20.20.135
database=my_test
dbuser=$(whoami)
password=Huawei@123
dbport1=19544
dbport2=19644
dmsurl="0:20.20.20.135:3611,1:20.20.20.135:3612"
dss_nodes_lists="0:20.20.20.135:16712,1:20.20.20.135:16722"
# 清理工作
ps -ux| grep 'dssserver -D '$dsspath | grep -v grep | awk '{print $2}' | xargs kill -9
ps -ux| grep 'gaussdb' | grep -v grep | awk '{print $2}' | xargs kill -9
ps -ux| grep 'gsql -d' | grep -v grep | awk '{print $2}' | xargs kill -9
rm -rf $dsspath
rm -rf $datapath
mkdir $dsspath
mkdir $datapath
mkdir -p $dsspath/dss0/dssdba/cfg
mkdir -p $dsspath/dss0/dssdba/log
mkdir -p $dsspath/dss1/dssdba/cfg
mkdir -p $dsspath/dss1/dssdba/log
mkdir -p $dsspath/dev
dd if=/dev/zero of=$dsspath/dev/dss-dba bs=2M count=10240 >/dev/null 2>&1
touch $dsspath/dss0/dssdba/cfg/dss_inst.ini
echo "INST_ID=0
_LOG_LEVEL=255
DSS_NODES_LIST=$dss_nodes_lists
DISK_LOCK_FILE_PATH=$dsspath/dss0
LSNR_PATH=$dsspath/dss0
_LOG_MAX_FILE_SIZE=20M
_LOG_BACKUP_FILE_COUNT=128
" >> $dsspath/dss0/dssdba/cfg/dss_inst.ini
touch $dsspath/dss0/dssdba/cfg/dss_vg_conf.ini
echo "data:$dsspath/dev/dss-dba" >> $dsspath/dss0/dssdba/cfg/dss_vg_conf.ini
touch $dsspath/dss1/dssdba/cfg/dss_inst.ini
echo "INST_ID=1
_LOG_LEVEL=255
DSS_NODES_LIST=$dss_nodes_lists
DISK_LOCK_FILE_PATH=$dsspath/dss0
LSNR_PATH=$dsspath/dss1
_LOG_MAX_FILE_SIZE=20M
_LOG_BACKUP_FILE_COUNT=128
" >> $dsspath/dss1/dssdba/cfg/dss_inst.ini
touch $dsspath/dss1/dssdba/cfg/dss_vg_conf.ini
echo "data:$dsspath/dev/dss-dba" >> $dsspath/dss1/dssdba/cfg/dss_vg_conf.ini
dsscmd cv -g data -v $dsspath/dev/dss-dba -s 2048 -D $dsspath/dss0/dssdba
if [ $? -ne 0 ]; then
echo "dsscmd cv failed."
exit 1
fi
dssserver -D $dsspath/dss0/dssdba &
sleep 2
dssserver -D $dsspath/dss1/dssdba &
sleep 2
mkdir -p $datapath
gs_initdb -D $datapath/node1 --nodename=node1 --vgname=+data --enable-dss --dms_url="${dmsurl}" -I 0 --socketpath='UDS:'$dsspath'/dss0/.dss_unix_d_socket'
if [ $? -ne 0 ]; then
echo "gs_initdb db1 cv failed."
exit 1
fi
echo "ss_enable_ssl = off
listen_addresses = '*'
port = $dbport1
log_statement='all'
ss_work_thread_count = 32
shared_buffers = 5GB
segment_buffers = 1GB
" >> $datapath/node1/postgresql.conf
sed '91 ahost all all 0.0.0.0/0 sha256' -i $datapath/node1/pg_hba.conf
gs_initdb -D $datapath/node2 --nodename=node2 --vgname=+data --enable-dss --dms_url="${dmsurl}" -I 1 --socketpath='UDS:'$dsspath'/dss1/.dss_unix_d_socket'
if [ $? -ne 0 ]; then
echo "gs_initdb db2 cv failed."
exit 1
fi
echo "ss_enable_ssl = off
listen_addresses = '*'
port = $dbport2
log_statement='all'
" >> $datapath/node2/postgresql.conf
sed '91 ahost all all 0.0.0.0/0 sha256' -i $datapath/node2/pg_hba.conf
echo "BITMAP_ONLINE = 3
REFORMER_ID = 0" > $CM_CONFIG_PATH
gs_ctl start -D $datapath/node1 & gs_ctl start -D $datapath/node2
gsql -d postgres -p 19544 -c "ALTER ROLE "$dbuser" PASSWORD '$password';"最后修改时间:2024-06-18 10:49:16
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




