Quick Setup of GBase 8s SSC Shared-Storage Cluster for High Availability
Database high availability is a critical capability for supporting core business operations. Among many high-availability architectures, the shared-storage approach is the most common and widely adopted. The GBase 8s shared-storage high-availability cluster (SSC) achieves node high availability through shared disks, storing only one copy of data. This maximizes hardware utilization and avoids data duplication, making it an essential item in the GBase 8s high-availability technology stack.
We noticed that many community members are looking for a simple way to verify the functionality of the GBase 8s shared-storage cluster. This article provides a setup guide for the SSC shared-storage cluster and helps you quickly and easily validate its capabilities. Let's explore how to deploy an SSC shared-storage cluster in a standalone environment.
Preparation
Prepare the database installation package
Download the appropriate architecture package from the GBase official website. The URL is:
https://www.gbase.cn/download/gbase-8s-1?category=INSTALL_PACKAGE
Prepare a test machine (virtual or physical)
Steps
Install the database
You can use a non-instantiated installation (choose not to create an instance after running ids_install) or a silent installation.
Note: Before a silent installation, create the gbasedbt user in advance. The recommended command is as follows:
Create environment variable files
Prepare two environment variable files.
Assume the instance name for database instance 1 is Server1 and instance 2 is Server2. The configuration file content is as follows:
Instance 1:
Instance 2:
Prepare data storage directories and rootdbs files for Instance 1 and Instance 2
Modify sqlhosts
The sqlhosts for server2 can be the same as that for server1.
Configure onconfig
Set up the SDS cluster
Run the following command on the primary node:
Run the following command on the secondary node:
Cluster check
By following the steps above, we have successfully set up an SSC shared-storage cluster. GBase 8s offers a comprehensive high-availability cluster solution. In addition to the SSC shared-storage cluster, it supports HAC, remote HAC clusters, an SSC+HAC active-active architecture within the same city, an SSC+HAC+remote HAC disaster recovery architecture for two-site three-center deployments, and an ER cluster solution with real-time synchronization.
In the upcoming series, we will continue to share and introduce the high-availability architecture of GBase 8s. We hope this article helps you better understand and leverage shared-storage cluster technology.