首页 > 数据库 >Gbase8s数据库保姆级安装部署(RHAC和SSC) 三

Gbase8s数据库保姆级安装部署(RHAC和SSC) 三

时间:2024-04-03 12:29:21浏览次数:28  
标签:00 Gbase8s -- gbasedbt 192.168 RHAC home gbase SSC

一、RHAC集群的安装部署

(一)RHAC集群的介绍和环境检查

1.RHAC和HAC集群的比较

        RHAC集群是gbase8s数据库双机同步的一种方式,其和HAC集群在安装部署上的步骤大部分是相同的(环境准备、软件安装、实例初始化、数据同步),而且其和HAC集群的同步方式也是一样的,只有在主机和备机加入集群的步骤存在着细微的差异,主要体现在参数上。

       除此之外,RHAC和HAC的差异主要表现为应用场景、数据同步的时效性和其节点数量:

  • 应用场景:
    • HAC:主要针对的同城灾备,距离相对较近,对网络的要求相对较高
    • RHAC:主要针对的异地灾备,距离相对较远,对网络要求较低
  • 同步时效性
    • HAC:其同步可以分为三个级别,完全同步、半同步(指日志发送到备机但是没有应用而向主机发送收到指令)、异步
    • RHAC:其同步级别只能为异步,可以指定间隔时间(间隔多长时间进行同步)
  • 节点数量:
    • HAC:节点数量为2
    • RHAC:节点数量可以高于2

2.操作系统的版本

  • 节点1
--节点1
[root@node01 ~]# uname -a
Linux node01 3.10.0-1160.71.1.el7.x86_64 #1 SMP Tue Jun 28 15:37:28 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
--节点2
[root@node02 ~]# uname -a
Linux node02 3.10.0-1160.71.1.el7.x86_64 #1 SMP Tue Jun 28 15:37:28 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

3.数据库的相关信息

RHAC集群安装之前,需要主机和备机已经安装了数据库软件,其中主机还要已经初始化成功实例,数据库的信息(包括准备安装的备机)如下:

服务器名称IP数据库版本实例名称端口数据库安装路径数据存放路径
node01192.168.6.63.5.1node39099/opt/GBASE/gbase/home/gbasedbt/node_dbs
node02192.168.6.73.5.1node49099/opt/GBASE/gbase/home/gbasedbt/node_dbs

4.数据库状态和信息查看

  • 192.168.6.6上查看node3数据库
--从这可以看出node3实例正在启动,数据库正常
[gbasedbt@node01 ~]$ onstat -g dis
Your evaluation license will expire on 2025-03-31 00:00:00
On-Line -- Up 00:02:41 -- 1123008 Kbytes
There are 2 servers found
Server        : node3
Server Number : 234
Server Type   : IDS
Server Status : Up
Server Version: GBase Database Server Version 12.10.FC4G1TL
Shared Memory : 0x44000000
GBASEDBTDIR   : /opt/GBASE/gbase
ONCONFIG      : /opt/GBASE/gbase/etc/onconfig.node3
SQLHOSTS      : /opt/GBASE/gbase/etc/sqlhosts.node3
Host          : node01

Server        : node1
Server Number : 28
Server Type   : IDS
Server Status : Down
Server Version: GBase Database Server Version 12.10.FC4G1TL
Shared Memory : 0x44000000
GBASEDBTDIR   : /opt/GBASE/gbase
ONCONFIG      : /opt/GBASE/gbase/etc/onconfig.node1
SQLHOSTS      : /opt/GBASE/gbase/etc/sqlhosts.node1
Host          : node01
  • 192.168.6.6上查看node4数据库
--从这可以看出,没有node4的数据库实例
[gbasedbt@node02 ~]$ onstat -g dis
Your evaluation license will expire on 2025-03-31 00:00:00
shared memory not initialized for GBASEDBTSERVER 'node2'
There are 1 servers found
Server        : node2
Server Number : 28
Server Type   : IDS
Server Status : Down
Server Version: GBase Database Server Version 12.10.FC4G1TL
Shared Memory : 0x44000000
GBASEDBTDIR   : /opt/GBASE/gbase
ONCONFIG      : /opt/GBASE/gbase/etc/onconfig.node2
SQLHOSTS      : /opt/GBASE/gbase/etc/sqlhosts.node2
Host          : node02

(二)部署的准备工作

1.关闭防火墙或者开放端口

  • 192.168.6.6上执行
--防火墙,主机和备机都要执行
systemctl stop firewalld && echo '防火墙关闭成功' || echo '防火墙关闭失败'
systemctl disable firewalld && echo '防火墙开机自起关闭' || echo '防火墙开机关闭失败'
--防火墙如果不关闭,也可以开启相应端口,主机和备机都要执行
firewall-cmd --add-port=9000-9900/tcp --permanent
firewall-cmd --add-port=9000-9900/udp --permanent
firewall-cmd --reload
firewall-cmd --list-ports
--SELINUX位置的调整,主机和备机都要执行
sed -i 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
  • 192.168.6.7上执行
--防火墙,主机和备机都要执行
systemctl stop firewalld && echo '防火墙关闭成功' || echo '防火墙关闭失败'
systemctl disable firewalld && echo '防火墙开机自起关闭' || echo '防火墙开机关闭失败'
--防火墙如果不关闭,也可以开启相应端口,主机和备机都要执行
firewall-cmd --add-port=9000-9900/tcp --permanent
firewall-cmd --add-port=9000-9900/udp --permanent
firewall-cmd --reload
firewall-cmd --list-ports
--SELINUX位置的调整,主机和备机都要执行
sed -i 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config

2.数据库主备双机互信

  • 192.168.6.6上执行
--使用root用户执行以下命令
echo '+ +' >>/etc/hosts.equiv
echo '192.168.6.7' >>/etc/hosts.equiv
echo '192.168.6.6 root' >>/root/.rhosts
echo '192.168.6.7 root' >>/root/.rhosts
echo '192.168.6.6 gbasedbt' >>/root/.rhosts
echo '192.168.6.7 gbasedbt' >>/root/.rhosts
--gbasedbt用户
echo '192.168.6.6 gbasedbt' >>/home/gbasedbt/.rhosts 
echo '192.168.6.7 gbasedbt' >>/home/gbasedbt/.rhosts
  • 192.168.6.7上执行
--服务器192.168.6.7上
--使用root用户执行以下命令
echo '+ +' >>/etc/hosts.equiv
echo '192.168.6.6' >>/etc/hosts.equiv
echo '192.168.6.6 root' >>/root/.rhosts
echo '192.168.6.7 root' >>/root/.rhosts
echo '192.168.6.6 gbasedbt' >>/root/.rhosts
echo '192.168.6.7 gbasedbt' >>/root/.rhosts
--gbasedbt用户
echo '192.168.6.6 gbasedbt' >>/home/gbasedbt/.rhosts 
echo '192.168.6.7 gbasedbt' >>/home/gbasedbt/.rhosts

3.环境变量

  • 192.168.6.6上查看环境变量
--一般环境变量文件的命名方式为profile.实例名称
[gbasedbt@node01 ~]$ cat /home/gbasedbt/profile.node3
export GBASEDBTSERVER=node3
export GBASEDBTDIR=/opt/GBASE/gbase
export GBASEDBTSQLHOSTS=/opt/GBASE/gbase/etc/sqlhosts.node3
export ONCONFIG=onconfig.node3
export PATH=/opt/GBASE/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
export GL_USEGLU=1
export GL_DATE="%Y-%m-%d"
export GL_DATETIME="%Y-%m-%d %H:%M:%S"
  • 192.168.6.6上将环境变量文件传输到192.168.6.7并按照其实例名命名为porfile.node4
scp /home/gbasedbt/profile.node3 192.168.6.7:/home/gbasedbt/profile.node4
  • 192.168.6.7上更改环境变量文件/home/gbasedbt/profile.node4
[gbasedbt@node02 ~]$ cat /home/gbasedbt/profile.node4
export GBASEDBTSERVER=node3
export GBASEDBTDIR=/opt/GBASE/gbase
export GBASEDBTSQLHOSTS=/opt/GBASE/gbase/etc/sqlhosts.node3
export ONCONFIG=onconfig.node3
export PATH=/opt/GBASE/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
export GL_USEGLU=1
export GL_DATE="%Y-%m-%d"
export GL_DATETIME="%Y-%m-%d %H:%M:%S"

[gbasedbt@node02 ~]$ sed -i 's/node3/node4/g' /home/gbasedbt/profile.node4

[gbasedbt@node02 ~]$ cat /home/gbasedbt/profile.node4
export GBASEDBTSERVER=node4
export GBASEDBTDIR=/opt/GBASE/gbase
export GBASEDBTSQLHOSTS=/opt/GBASE/gbase/etc/sqlhosts.node4
export ONCONFIG=onconfig.node4
export PATH=/opt/GBASE/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
export GL_USEGLU=1
export GL_DATE="%Y-%m-%d"
export GL_DATETIME="%Y-%m-%d %H:%M:%S"

  • 192.168.6.7上加入生效node4环境变量的信息
echo 'source /home/gbasedbt/profile.node4' >> /home/gbasedbt/.bash_profile

4.sqlhosts连接文件的设置

  • 192.168.6.6查看实例node3的sqlhosts连接配置文件
[gbasedbt@node01 ~]$ onstat -g dis |grep sqlhosts|grep node3|awk '{print $NF}'
Your evaluation license will expire on 2025-03-31 00:00:00
/opt/GBASE/gbase/etc/sqlhosts.node3
  • 192.168.6.6加入备机192.168.6.7的连接信息
[gbasedbt@node01 ~]$ cat /opt/GBASE/gbase/etc/sqlhosts.node3
node3 onsoctcp 192.168.6.6 9099

[gbasedbt@node01 ~]$ echo 'node4 onsoctcp 192.168.6.7 9099'>>/opt/GBASE/gbase/etc/sqlhosts.node3

[gbasedbt@node01 ~]$ cat /opt/GBASE/gbase/etc/sqlhosts.node3
node3 onsoctcp 192.168.6.6 9099
node4 onsoctcp 192.168.6.7 9099
  • 192.168.6.6将sqlhosts.node3文件传输到备机上并命名为sqlhosts.node4
[gbasedbt@node01 ~]$ scp /opt/GBASE/gbase/etc/sqlhosts.node3 192.168.6.7:/opt/GBASE/gbase/etc/sqlhosts.node4

5.数据库参数文件onconfig的配置

  • 192.168.6.6查看onconfig文件的位置
[gbasedbt@node01 ~]$ onstat -g dis |grep onconfig|grep node3|awk '{print $NF}'
Your evaluation license will expire on 2025-03-31 00:00:00
/opt/GBASE/gbase/etc/onconfig.node3
  • 192.168.6.6更改参数文件内容
--192.168.6.6上进行改动参数文件
[gbasedbt@node01 ~]$ sed -i 's/DRAUTO.*/DRAUTO                   2/g' /opt/GBASE/gbase/etc/onconfig.node3
[gbasedbt@node01 ~]$ sed -i 's/LOG_INDEX_BUILDS.*/LOG_INDEX_BUILDS   1/g' /opt/GBASE/gbase/etc/onconfig.node3
  • 将192.168.6.6的onconfig文件传输到192.168.6.7上
[gbasedbt@node01 ~]$ scp /opt/GBASE/gbase/etc/onconfig.node3 192.168.6.7:/opt/GBASE/gbase/etc/onconfig.node4
  • 192.168.6.7更改传输过来的文件内容
[gbasedbt@node02 etc]$ sed -i 's/^DBSERVERNAME.*/DBSERVERNAME node4/g' /opt/GBASE/gbase/etc/onconfig.node4

6.同步数据文件

  • 192.168.6.6查看数据文件文件夹和所有的数据文件
[gbasedbt@node01 ~]$ onstat -d|grep /home|awk '{print "touch " $NF}'
Your evaluation license will expire on 2025-03-31 00:00:00
touch /home/gbasedbt/node_dbs/rootdbs
touch /home/gbasedbt/node_dbs/llogdbs
touch /home/gbasedbt/node_dbs/plogdbs
touch /home/gbasedbt/node_dbs/sbspace1
touch /home/gbasedbt/node_dbs/tmpdbs1
touch /home/gbasedbt/node_dbs/datadbs1_1
  • 备机192.168.6.6执行创建文件夹和创建文件
[gbasedbt@node02 etc]$ mkdir /home/gbasedbt/node_dbs/
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/rootdbs
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/llogdbs
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/plogdbs
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/sbspace1
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/tmpdbs1
[gbasedbt@node02 etc]$ touch /home/gbasedbt/node_dbs/datadbs1_1
  • 更改权限
[gbasedbt@node02 etc]$ chown -R gbasedbt:gbasedbt /home/gbasedbt/node_dbs
[gbasedbt@node02 etc]$ chmod 755 /home/gbasedbt/node_dbs
[gbasedbt@node02 etc]$ chmod 660 /home/gbasedbt/node_dbs/*

(三)集群的部署

1.主机重启后注册并制定备机为RHAC集群的备机

  • 主机重启数据库使更改参数生效
[gbasedbt@node01 ~]$ onmode -ky
Your evaluation license will expire on 2025-03-31 00:00:00
[gbasedbt@node01 ~]$ oninit -vy
Your evaluation license will expire on 2025-03-31 00:00:00
Reading configuration file '/opt/GBASE/gbase/etc/onconfig.node3'...succeeded
  • 主机注册并制定RSS备机
[gbasedbt@node01 ~]$ onmode -d add RSS node4
Your evaluation license will expire on 2025-03-31 00:00:00

2.主机192.168.6.6数据同步到备机

  • 192.168.6.6上执行,ssh到192.168.6.7上,source环境变量
[gbasedbt@node01 ~]$ ontape -s -L 0 -t STDIO | ssh 192.168.6.7 "source /home/gbasedbt/profile.node4 && ontape -p -t STDIO "
Your evaluation license will expire on 2025-03-31 00:00:00
[email protected]'s password:
Your evaluation license will expire on 2025-03-31 00:00:00
Your evaluation license will expire on 2025-03-31 00:00:00
[gbasedbt@node01 ~]$

3.备机加入集群

  • 192.168.6.7通过命令加入集群
[gbasedbt@node02 etc]$ onmode -d RSS node3
Your evaluation license will expire on 2025-03-31 00:00:00
  • 192.168.6.7通过日志确定何时加入成功,onstat -m出现以下内容时初始化成功
[gbasedbt@node02 etc]$ onstat -m
Your evaluation license will expire on 2025-03-31 00:00:00
Read-Only (RSS) -- Up 00:00:47 -- 1635008 Kbytes

Message Log File: /opt/GBASE/gbase/tmp/online_node3.log
04/01/24 22:44:02  DR: new type = RSS
04/01/24 22:44:02  RSS Server node3 - state is now connected
04/01/24 22:44:03  Logical Recovery Started.
04/01/24 22:44:03  96 recovery worker threads will be started.
04/01/24 22:44:03  Dynamically allocated new virtual shared memory segment (size 128000KB)
04/01/24 22:44:03  Memory sizes:resident:50768 KB, virtual:1200240 KB, no SHMTOTAL limit
04/01/24 22:44:03  Dynamically allocated new virtual shared memory segment (size 128000KB)
04/01/24 22:44:03  Memory sizes:resident:50768 KB, virtual:1328240 KB, no SHMTOTAL limit
04/01/24 22:44:03  Dynamically allocated new virtual shared memory segment (size 128000KB)
04/01/24 22:44:03  Memory sizes:resident:50768 KB, virtual:1456240 KB, no SHMTOTAL limit
04/01/24 22:44:03  Dynamically allocated new virtual shared memory segment (size 128000KB)
04/01/24 22:44:03  Memory sizes:resident:50768 KB, virtual:1584240 KB, no SHMTOTAL limit
04/01/24 22:44:04  Start Logical Recovery - Start Log 7, End Log ?
04/01/24 22:44:04  Starting Log Position - 7 0x1218018
04/01/24 22:44:04  Clearing the physical and logical logs has started
04/01/24 22:44:05  Cleared 575 MB of the physical and logical logs in 1 seconds
04/01/24 22:44:05  B-tree scanners disabled.
04/01/24 22:44:06  DR: RSS secondary server operational
04/01/24 22:44:07  Started processing open transactions on secondary during startup
04/01/24 22:44:07  Finished processing open transactions on secondary during startup.

4.数据库状态查看

  • 192.168.6.6
[gbasedbt@node01 ~]$ onstat -g dri
Your evaluation license will expire on 2025-03-31 00:00:00
On-Line -- Up 00:13:46 -- 1123008 Kbytes

Data Replication at 0x4c13d028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  standard       off                                       -1 / -1         NA

  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       2
  DRLOSTFOUND  /opt/GBASE/gbase/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0
  • 192.168.6.7
[gbasedbt@node02 etc]$ onstat -g  dri
Your evaluation license will expire on 2025-03-31 00:00:00
Read-Only (RSS) -- Up 00:03:56 -- 1635008 Kbytes

Data Replication at 0x4c13d028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  RSS Secondary  on           node3                        -1 / -1         N

  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       2
  DRLOSTFOUND  /opt/GBASE/gbase/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0

5.集群复制查看

  • 192.168.6.6查看如下,显示的集群备机
[gbasedbt@node01 ~]$ onstat -g cluster
Your evaluation license will expire on 2025-03-31 00:00:00
On-Line -- Up 00:14:15 -- 1123008 Kbytes

Primary Server:node3
Current Log Page:7,4638
Index page logging status: Enabled
Index page logging was enabled at: 2024/04/01 22:34:08


Server ACKed Log    Applied Log  Supports     Status
       (log, page)  (log, page)  Updates
node2  0,0          0,0          No           ASYNC(RSS),Disconnected,Defined
node4  7,4638       7,4638       No           ASYNC(RSS),Connected,Active
  • 192.168.6.7
[gbasedbt@node02 etc]$ onstat -g cluster
Your evaluation license will expire on 2025-03-31 00:00:00
Read-Only (RSS) -- Up 00:06:05 -- 1635008 Kbytes

Primary Server:node3
Index page logging status: Enabled
Index page logging was enabled at: 2024/04/01 22:34:08


Server ACKed Log    Supports     Status
       (log, page)  Updates
node4  7,4638       No           ASYNC(RSS),Connected,Active

6.数据测试

  • 192.168.6.6
[gbasedbt@node01 ~]$ dbaccess sysmaster -
Your evaluation license will expire on 2025-03-31 00:00:00

Database selected.

> create database test with log;

Database closed.


Database created.

> create table test(id int);

Table created.

> insert into test values(1);

1 row(s) inserted.

  • 192.168.6.7
[gbasedbt@node02 etc]$ dbaccess test -
Your evaluation license will expire on 2025-03-31 00:00:00

Database selected.

> select * from test;


         id

          1

1 row(s) retrieved.

二、SSC共享内存集群的安装部署

(一)SSC集群

1.SSC集群本次部署说明

        SSC集群是共享存储集群,多个数据库实例公用一个存储,由于没有相应的环境,故本次部署测试是在一台虚拟机上部署用两个实例公用一个数据文件进行模拟进行。

2.SSC集群本次部署信息说明

本次共享集群部署是在一台服务器上进行,所以只有一个IP地址,也只需安装一个软件但是是有两个实例,具体部署信息如下:

ip实例名称端口安装路径数据文件路径
192.168.6.6ssc19088/home/gbasedbt/gbase/home/gbasedbt/gbase/ssc1_dbs
192.168.6.6ssc29099/home/gbasedbt/gbase/home/gbasedbt/gbase/ssc1_dbs

3.SSC集群安装部署步骤

  • 192.168.6.6安装软件
  • 192.168.6.6进行实例初始化
  • 192.168.6.6调整环境变量文件,并复制重命名
  • 192.168.6.6调整连接控制文件,并复制重命名
  • 192.168.6.6调整参数控制文件,并复制重命名
  • 192.168.6.6重启节点1的数据库,使更改的参数生效
  • 192.168.6.6指定ssc1为主节点
  • 192.168.6.6启动节点2

(二)集群的部署

1.说明

本次默认192.168.6.6上已经安装了数据库软件(测试版本为3.5.1),且已经初始化实例,状态如下:

--192.168.6.6上查看节点状态,实例ssc1已经启动
[gbasedbt@node01 ~]$ onstat -g dis
Your evaluation license will expire on 2025-04-02 00:00:00
On-Line -- Up 00:00:35 -- 1650580 Kbytes
There are 1 servers found
Server        : ssc1
Server Number : 154
Server Type   : IDS
Server Status : Up
Server Version: GBase Database Server Version 12.10.FC4G1TL
Shared Memory : 0x44000000
GBASEDBTDIR   : /home/gbasedbt/gbase
ONCONFIG      : /home/gbasedbt/gbase/etc/onconfig.ssc1
SQLHOSTS      : /home/gbasedbt/gbase/etc/sqlhosts.ssc1
Host          : node01

2.调整环境变量文件并复制重命名

--调整后实例ssc1的环境变量文件内容如下
[gbasedbt@node01 ~]$ cat profile.ssc1
export GBASEDBTSERVER=ssc1
export GBASEDBTDIR=/home/gbasedbt/gbase
export GBASEDBTSQLHOSTS=/home/gbasedbt/gbase/etc/sqlhosts.ssc1
export ONCONFIG=onconfig.ssc1
export PATH=/home/gbasedbt/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
export GL_USEGLU=1
export GL_DATE="%Y-%m-%d"
export GL_DATETIME="%Y-%m-%d %H:%M:%S"

--进行复制重命名为实例ssc2的环境变量文件
[gbasedbt@node01 ~]$ cp /home/gbasedbt/profile.ssc1 /home/gbasedbt/profile.ssc2

--将实例ssc2的环境变量文件进行改动,改动三处,实例名称、连接控制文件名称和参数控制文件
[gbasedbt@node01 ~]$ cat profile.ssc2
export GBASEDBTSERVER=ssc2
export GBASEDBTDIR=/home/gbasedbt/gbase
export GBASEDBTSQLHOSTS=/home/gbasedbt/gbase/etc/sqlhosts.ssc2
export ONCONFIG=onconfig.ssc2
export PATH=/home/gbasedbt/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
export GL_USEGLU=1
export GL_DATE="%Y-%m-%d"
export GL_DATETIME="%Y-%m-%d %H:%M:%S"

3.调整连接控制文件并复制给ssc2

--调整后的连接参数文件如下,主要为增加实例ssc2的连接信息,主要差异为实例名称和端口
[gbasedbt@node01 ~]$ cat /home/gbasedbt/gbase/etc/sqlhosts.ssc1
ssc1 onsoctcp 192.168.6.6 9088
ssc2 onsoctcp 192.168.6.6 9099

--复制连接控制文件并重命名
[gbasedbt@node01 ~]$ cp /home/gbasedbt/gbase/etc/sqlhosts.ssc1 /home/gbasedbt/gbase/etc/sqlhosts.ssc2

--实例ssc2的连接控制文件不用调整,内容如下
[gbasedbt@node01 ~]$ cat /home/gbasedbt/gbase/etc/sqlhosts.ssc2
ssc1 onsoctcp 192.168.6.6 9088
ssc2 onsoctcp 192.168.6.6 9099

4.调整参数控制文件并复制给实例ssc2

  • 实例ssc1的参数文件主要调整有三个
    • SDS_ENABLE:用于启动和禁止SD的辅助功能,当设置为1时,主机down机后会自动接管数据库服务,所以主机设置为0,第二个节点设置为1
    • SDS_TEMPDBS:用于指定SD服务器在启动时动态创建的临时数据库空间的信息,需要配置临时数据库空间的相关信息,如数据库空间名称、路径、页面大小、偏移量和大小等。需要注意的是,对于每个SDS_TEMPDBS配置参数值,页面大小(pagesize)值必须是相同的。
    • SDS_PAGING:用来配置共享存储每个节点的独有缓冲区路径,需要配置两个文件路径
--实例ssc1关于三个参数的相关设置如下
[gbasedbt@node01 ~]$ cat /home/gbasedbt/gbase/etc/onconfig.ssc1|grep ^SDS|grep -v SDS_TIMEOUT|grep -v SDS_LOGCHECK|grep -v SDS_ALTERNATE|grep -v SDS_FLOW_CONTROL
SDS_ENABLE      0
SDS_TEMPDBS             sdstmpdbs1,/home/gbasedbt/gbase/ssc1/sdstmpdbs01,2,0,102400
SDS_PAGING              /home/gbasedbt/gbase/ssc1/pagefile01,/home/gbasedbt/gbase/ssc1/pagefile02
  • 将实例ssc1的实力复制并改名
[gbasedbt@node01 ~]$ cp /home/gbasedbt/gbase/etc/onconfig.ssc1 /home/gbasedbt/gbase/etc/onconfig.ssc2
  • 将实例ssc2的onconfig文件进行改动,改动参数如下:
--改动内容为:实例名称、实例编号、日志文件名称和共享存储的几个参数
--内容太长,将改动的参数进行罗列出来,需要改动内容如下(确保SERVERNUM和实例ssc1不一致)
MSGPATH /home/gbasedbt/gbase/tmp/online_ssc2.log
DBSERVERNAME ssc2
SERVERNUM 155
SDS_ENABLE            1
SDS_TEMPDBS           sdstmpdbs1,/home/gbasedbt/gbase/ssc2/sdstmpdbs01,2,0,102400
SDS_PAGING        /home/gbasedbt/gbase/ssc2/pagefile01,/home/gbasedbt/gbase/ssc2/pagefile02

  • 将实例ssc1和ssc2的onconfig文件进行对比
[gbasedbt@node01 ~]$ diff /home/gbasedbt/gbase/etc/onconfig.ssc2 /home/gbasedbt/gbase/etc/onconfig.ssc1
126c126
< MSGPATH /home/gbasedbt/gbase/tmp/online_ssc2.log
---
> MSGPATH /home/gbasedbt/gbase/tmp/online_ssc1.log
205,206c205,206
< SERVERNUM 155
< DBSERVERNAME ssc2
---
> SERVERNUM 154
> DBSERVERNAME ssc1
1300c1300
< SDS_ENABLE            1
---
> SDS_ENABLE      0
1302,1303c1302,1303
< SDS_TEMPDBS           sdstmpdbs1,/home/gbasedbt/gbase/ssc2/sdstmpdbs01,2,0,102400
< SDS_PAGING            /home/gbasedbt/gbase/ssc2/pagefile01,/home/gbasedbt/gbase/ssc2/pagefile02
---
> SDS_TEMPDBS           sdstmpdbs1,/home/gbasedbt/gbase/ssc1/sdstmpdbs01,2,0,102400
> SDS_PAGING            /home/gbasedbt/gbase/ssc1/pagefile01,/home/gbasedbt/gbase/ssc1/pagefile02

5.针对上述的参数文件创建相关的文件夹和相关文件

--实例ssc1,SDS的上述三个参数需要一个文件夹和三个文件
[root@node01 gbase]# mkdir /home/gbasedbt/gbase/ssc1
[root@node01 gbase]# touch /home/gbasedbt/gbase/ssc1/sdstmpdbs01
[root@node01 gbase]# touch /home/gbasedbt/gbase/ssc1/pagefile01
[root@node01 gbase]# touch /home/gbasedbt/gbase/ssc1/pagefile02
[root@node01 gbase]# chown -R gbasedbt:gbasedbt /home/gbasedbt/gbase/ssc1
[root@node01 gbase]# chmod 755 /home/gbasedbt/gbase/ssc1
[root@node01 gbase]# chmod 660 /home/gbasedbt/gbase/ssc1/*
--实例ssc2
cp /home/gbasedbt/gbase/ssc1 /home/gbasedbt/gbase/ssc2

6.搭建SSC共享集群

  • 重启ssc1实例
source /home/gbasedbt/profile.ssc1
onmode -ky
oninit -vy
  • 将ssc1设为共享存储的所有者数据库
--生效实例ssc1环境变量,指定ssc1
source /home/gbasedbt/profile.ssc1
onmode -d set SDS primary ssc1
--生效实例ssc2环境变量,启动ssc2
source /home/gbasedbt/profile.ssc2
oninit -vy

7.查看集群状态

--生效ssc1环境变量,查看
[gbasedbt@node01 ~]$ source /home/gbasedbt/profile.ssc1
[gbasedbt@node01 ~]$ onstat -g dri
Your evaluation license will expire on 2025-04-02 00:00:00
On-Line -- Up 02:39:03 -- 1650580 Kbytes

Data Replication at 0x4cf32028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  standard       off                                       -1 / -1         NA

  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /home/gbasedbt/gbase/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0
--生效ssc1环境变量,查看
[gbasedbt@node01 ~]$ source /home/gbasedbt/profile.ssc2
[gbasedbt@node01 ~]$ onstat -g dri
Your evaluation license will expire on 2025-04-02 00:00:00
Read-Only (SDS) -- Up 02:34:17 -- 2188180 Kbytes

Data Replication at 0x4cf2e028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  SDS Secondary  on           ssc1                          5 / 738        N

  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /home/gbasedbt/gbase/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0

--生效ssc1环境变量,查看复制状态
[gbasedbt@node01 ~]$ source /home/gbasedbt/profile.ssc1
[gbasedbt@node01 ~]$ onstat -g cluster
Your evaluation license will expire on 2025-04-02 00:00:00
On-Line -- Up 02:39:55 -- 1650580 Kbytes

Primary Server:ssc1
Current Log Page:5,780
Index page logging status: Disabled


Server ACKed Log    Applied Log  Supports     Status
       (log, page)  (log, page)  Updates
ssc2   5,780        5,780        No           SYNC(SDS),Connected,Active

--生效ssc2环境变量,查看复制状态
[gbasedbt@node01 ~]$ source /home/gbasedbt/profile.ssc2
[gbasedbt@node01 ~]$ onstat -g cluster
Your evaluation license will expire on 2025-04-02 00:00:00
Read-Only (SDS) -- Up 02:35:05 -- 2188180 Kbytes

Primary Server:ssc1
Index page logging status: Disabled


Server ACKed Log    Supports     Status
       (log, page)  Updates
ssc2   5,780        No           SYNC(SDS),Connected,Active

标签:00,Gbase8s,--,gbasedbt,192.168,RHAC,home,gbase,SSC
From: https://blog.csdn.net/qq_59083851/article/details/137247332

相关文章

  • 京东云开源软件治理工具SSCM强势来袭!免费试用
    开源软件是数字时代研发创新和效率的引擎•开源软件占所使用的所有软件的70%,是支持企业转型的创新生态系统不可或缺的部分。•根据奇安信的2023中国软件供应链安全分析报告,被分析的2631个国内企业软件项目中,100% 使用了开源软件,平均每个项目使用155个。开源软件使用存在的风险......
  • gbase8s数据表级别的同步(部分数据的下发等功能)一
    一、ER的部署(一)环境检查1.操作系统环境检查虚拟机是centos进行虚拟出来的测试机[root@node01install]#uname-aLinuxnode013.10.0-1160.71.1.el7.x86_64#1SMPTueJun2815:37:28UTC2022x86_64x86_64x86_64GNU/Linux2.数据库部署信息检查服务器名称服......
  • Gbase8s数据库保姆级安装部署 一
       一、单机安装部署(一)安装之前的环境检查和准备(本次安装以官网最新版本3.5.1为例)1.检查环境和操作系统和安装包是否匹配gbase8s数据库一般以是以CPU架构为主要区分点,主要分为x86架构和arm架构两种:X86:Intel(centos)、兆芯和海光arm:鲲鹏和飞腾--检查操作系统--本次操......
  • 文件操作(1)【文件打开和关闭】【文件的顺序读写(各种函数)】【sprintf和sscanf的理解】
    一.什么是文件?在程序设计中我们一般谈的文件有两种:程序文件和数据文件1.程序文件程序文件是包含计算机程序代码的文件。它通常包含一系列指令和算法,用于执行特定的任务或实现特定的功能。程序文件可以由不同的编程语言编写,如C、Java、Python等。程序文件通过编译或解释等过......
  • [NSSRound#19 Basic]bestkasscn的超级简单密码
    题目:fromCrypto.Util.numberimport*importgmpy2fromfunctoolsimportreducefromsecretimportflagp=getPrime(1024)i=0whileTrue:r=p*5+iifisPrime(r):i=0breakelse:i+=1whileTrue:q=p*......
  • 关于RCE的学习(2)nssctf部分题目实操(1)
           结果对一些基础命令的学习,我发现一个非常显而易见的问题,那就是,理论知识如果没有建立在实操的基础上来讲的话,那么理论知识就会显得非常空,那么结合我上一篇对rce学习的文章,我对一下题目做出如下总结。       首先是,[SWPUCTF2021新生赛]easyrce   ......
  • NSSCTF刷题日记复健day6
    昨天感觉左眼蒙上了一层黑雾,视野还收缩到只能看到中间一半,哈人,遂决定每日早睡早起。[NSSCTF2022SpringRecruit]ezgame游戏题,看js文件就可以了。[LitCTF2023]Followmeandhackme 如图,get加post就是了,彩蛋应该是当时这个比赛的某个flag组成题 彩蛋直接看的别的......
  • How to survive in ISSCC -- 下
    上次讲了day.0到day.3的故事,现在继续更新哈哈。day.4这次ISSCC我们报了demosession,所以除了pre之外还得去演示demo,我们在demosession2,也就是pre的前一天进行演示。demosession的时间是下午5点到7点,主办方会提供一个展位和banner,展位上有桌子,展板,还有电源。作者需要自己准......
  • NSSCTF—Crypyo "第一页" ԅ(≖‿≖ԅ) (待续……)
    [鹤城杯2021]easy_crypto题目:公正公正公正诚信文明公正民主公正法治法治诚信民主自由敬业公正友善公正平等平等法治民主平等平等和谐敬业自由诚信平等和谐平等公正法治法治平等平等爱国和谐公正平等敬业公正敬业自由敬业平等自由法治和谐平等文明自由诚信自由平等富强公正敬业......
  • 收藏一个不错的cssscript特效网站
    css水波浪效果demohttps://www.cssscript.com/demo/animated-waves-svg/  waves-animation/demohttps://www.cssscript.com/waves-animation/ ......