GBase 8s Deployment Guide: Skip the Complex CLI with One‑Click Automated Installation
Introduction: Installing a database can be as simple as it is complex—sometimes maddeningly. Today, let’s walk through the installation methods for GBase 8s: from the hardcore command line to the “lazy guy’s dream” one‑click script, and then to the graphical management platform GEM—there’s an option for everyone.
I. Before You Get Started: Is Your Platform Compatible?
As an enterprise‑grade OLTP database, GBase 8s offers broad platform compatibility.
Operating System: GBase 8s is highly compatible—CentOS 7+, Kylin OS V10+, UnionTech UOS V20+, and Ubuntu 16+ can all run it. Before installation, remember to run the dependency check:
yum -y install unzip glibc-devel ncurses-libs libnsl libaio
CPU Chips: It supports multiple architectures including x86, ARM, POWER, MIPS, and SPARC. Chinese‑made chips like Hygon, Zhaoxin, Phytium, Kunpeng, and Loongson are all on the support list. In short, from Intel to China’s homegrown processors, it can handle them all.
II. Pre‑Installation Rituals: Don’t Skip System Tuning
Installing a database is like building a house: if the foundation isn’t solid, you’ll run into trouble later.
Disable the firewall and SELinux
Standardize the hostname
Database log archiving and backup file naming both depend on the hostname. It is recommended to follow a naming convention like dbhost[xx] and update /etc/hosts accordingly.
Tune the kernel parameters
Check system kernel parameters using ipcs -l to ensure they meet or exceed the official recommendations. If not, adjust /etc/sysctl.conf.
Disable RemoveIPC
Linux 7.x and later versions enable RemoveIPC by default, which can cause database semaphores to be accidentally removed and lead to crashes. It must be disabled:
III. Installation Methods Showdown: Three Ways to Choose From
GBase 8s offers multiple installation methods, ranging from completely manual to fully automated, with varying levels of difficulty and efficiency.
Method 1: Manual Installation (For the Hardcore User)
Suitable for DBAs who want an in‑depth understanding of database internals and fine‑grained control in production environments.
Steps overview:
Create gbasedbt user → Extract installation media → Run ids_install → Configure environment variables and onconfig、sqlhosts → Initialize instance with oninit -ivyw → Create database spaces.
Note: onconfig is the “heart” of the database. Critical settings like ROOTPATH, memory parameters, and BUFFERPOOL must be precisely controlled. It is recommended to set BUFFERPOOL larger on systems with ample memory, but total database memory should not exceed 50% of system memory.
Method 2: One‑Click Script Installation (A Lazy Person’s Dream)
Ideal for quick validation in test environments and for efficiency enthusiasts who don’t want to type a bunch of commands.
tar -xvf GBase8s*.tarcd PluginPak && sh install_init.sh
The script automatically completes environment checks, disables firewalls and SELinux, installs the software, initializes the instance, creates system databases, moves logs, and generates statistics. The whole process is automated and finishes in about 5 minutes.
Drawback: The configuration is relatively fixed; manual parameter adjustments may be required for production environments.
Method 3: GEM Graphical Management Platform (Victory for the Mouse‑Lovers)
Great for operations teams who dislike the command line and need to manage multiple databases.
GEM is a graphical management tool launched by General Data Technology Co., Ltd., truly an “all‑in‑one management powerhouse”:
Extract and run: No complex configuration needed; deploy in 30 seconds and log in directly from a browser.
Plugin‑based architecture: Resource center, monitoring and alerting, cluster configuration, etc., can be installed on‑demand.
Graphical deployment: One‑click installation of database/CSDK, visual instance creation, and point‑and‑click tablespace allocation and character set configuration.
Use case: A new employee can complete database initialization automatically in 10 minutes through GEM’s DBCA configuration interface, saving 3 hours of manual configuration time.
IV. Common Errors: Avoid These Pitfalls
Installation inevitably involves encountering errors. Here are several common issues and their solutions:
4.1 Could not initialize class sun.awt.X11GraphicsEnvironment
Cause: X11 forwarding is not disabled
Solution: Disable X11 forwarding in the SSH client (Options → Session Options → Remote/X11 → uncheck Forward X11 packets)
4.2 libnsl.so.1 cannot open shared object file
Cause: Missing libnsl.so.1 on newer systems
Solution:
ln -s /usr/lib64/libnsl.so.2 /usr/lib64/libnsl.so.1
4.3 The version file is not exist
Cause: Missing unzip package
Solution:
yum install unzip
V. After Installation: Don’t Forget to Verify
5.1 Check database status
onstat -
Normal output:
On-Line -- Up 00:12:45 -- 3378128 Kbytes
5.2 Connect to the database
dbaccess sysmaster -
VI. Conclusion: Choose the Right Method and Get Twice the Results with Half the Effort
Newbies: Start with the one‑click script installation to get up and running quickly and build confidence.
Deep dive: Try manual installation to understand core concepts like onconfig, sqlhosts, and dbspace.
Enterprise operations: Deploy GEM to centrally manage multiple instances and enhance team efficiency.
Installing the database is just the first step; optimization, backup, and cluster configuration are the main acts ahead. But a good start makes the rest of the journey much smoother. I hope this article helps you avoid detours and become a GBase 8s “pro” in no time!