GBase 8a单机免费版安装,请先按照默认值操作,确保能正常安装使用。本文采用官方免费版本GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2为例,介绍单机版安装步骤。
目录导航
前提
请确认你的操作系统是redhat 7系列。
[root@localhost ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.3 (Maipo)
[root@localhost ~]#
创建用户
我这里是gbase8用户。如果你已经有自己的用户,则无需创建了。
[root@localhost ~]# useradd gbase8 -m
[root@localhost ~]# chown gbase8:gbase8 GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2
将安装包复制到你的用户主目录下面
比如我例子中的/home/gbase/gbase8下面。本例是我通过root上传,然后mv过去的。请根据自己的情况,将安装包放过去。
注意之后我们都是在自己的gbase8用户下操作
[root@localhost ~]# mv GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2 /home/gbase8/
[root@localhost ~]# su - gbase8
[gbase8@localhost ~]$ ll
total 34804
-rw-r--r-- 1 gbase8 gbase8 35638083 Sep 4 05:50 GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2
解压缩安装包
[gbase8@localhost ~]$ tar -xvf GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2
GBaseInstall/
GBaseInstall/docs/
GBaseInstall/clear.sh
GBaseInstall/license.txt
GBaseInstall/Install_lin.sh
GBaseInstall/install_config/
GBaseInstall/install_config/.gbase.properties
此处省略一大堆解压缩信息
查看readme.txt
redame.txt里有常见的操作信息,包括安装,启动停止,登陆等,
[gbase8@localhost GBaseInstall]$ cat readme.txt
Guide:
1. To install
$ cd GBaseInstall
$ sh ./Install_lin.sh
$ source ~/.bashrc
2. To start&stop GBase
$ gbase.server start
$ gbase.server stop
$ gbase.server restart
3. To use GBase
$ gbase -uroot
4. To list all instance
$ cat $HOME/.gbase8a.properties_instance
5. To uninstall:
$ cd <installPath>
$ sh .server/bin/Uninstall_lin.sh
6. To Update
$ cd GBaseInstall
$ sh ./Install_lin.sh -U
$ source ~/.bash_profile
[gbase8@localhost GBaseInstall]$
安装
Install_lin.sh是安装脚本
其中所有的选项,我们都采用默认值即可,不需要修改。其中
安装目录默认是 /home/gbase8/GBase
默认的实例名是 gbase8a
默认端口是 5258
[gbase8@localhost GBaseInstall]$ ./Install_lin.sh
*********************************************************************************
Thank you for choosing GBase product!
省略许可内容
*********************************************************************************
Do you accept the above licence agreement (Yes/No, default=No) ?
yes
*********************************************************************************
Welcome to install GBase products
*********************************************************************************
Please input the GBase software installation directory (Default:/home/gbase8/GBase):
Installing all software packages ...
Software packages installation done.
*********************************************************************************
Welcome to create GBase database instance
*********************************************************************************
Please input the new database instance name (default: gbase8a):
Please input the port number for the new database instance (default:5258):
GBase is creating the New 'gbase8a' instance ...
hostkey: c9b28eccaed0efbfac9ceda2e992aeec
The host key file is genarate at GBASE_BASE/config/gbase_host.cnf.
Congratulations. Your GBase installation is successful.
Please execute $source ~/.bashrc manually on the first run.
Please refer to the product's manuals and readme.txt to start using GBase product.
查看下我们安装后的目录
[gbase8@localhost GBaseInstall]$ cd /home/gbase8/GBase
[gbase8@localhost GBase]$ ll
total 8
drwxrwxr-x 2 gbase8 gbase8 56 Sep 4 05:54 config
drwxrwxr-x 2 gbase8 gbase8 6 Sep 4 05:54 docs
drwxrwxr-x 2 gbase8 gbase8 101 Sep 4 05:54 install_config
drwxrwxr-x 3 gbase8 gbase8 37 Sep 4 05:54 install_templet
-rw-r--r-- 1 gbase8 gbase8 3351 Sep 4 05:54 license.txt
drwxrwxr-x 3 gbase8 gbase8 21 Sep 4 05:54 log
drwxrwxr-x 2 gbase8 gbase8 6 Sep 4 05:54 misc
-rw-rw-r-- 1 gbase8 gbase8 446 Sep 4 05:54 readme.txt
drwxrwxr-x 7 gbase8 gbase8 72 Sep 4 05:54 server
drwxrwxr-x 4 gbase8 gbase8 49 Sep 4 05:54 tmpdata
drwxrwxr-x 3 gbase8 gbase8 21 Sep 4 05:54 userdata
[gbase8@localhost GBase]$
加载环境变量
环境变量在~/.bashr 里面,我们直接加载这个文件。
[gbase8@localhost GBaseInstall]$ source ~/.bashrc
看一下这个文件的内容,内部是加载/home/gbase8/.gbase_profile的。查看下.gbase_profile内容,都是环境变量相关的。
重要提示:数据库运行必须有响应的环境变量。
[gbase8@localhost GBaseInstall]$ cat ~/.bashrc
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=
# User specific aliases and functions
if [ -f "/home/gbase8/.gbase_profile" ]; then
. "/home/gbase8/.gbase_profile"
fi
[gbase8@localhost GBaseInstall]$ cat ~/.gbase_profile
export GBASE_BASE=/home/gbase8/GBase
export GBASE_HOME=/home/gbase8/GBase/server
export GBASE_SID=gbase8a
export PATH=$GBASE_HOME/bin:$PATH
export TCMALLOC_AGGRESSIVE_DECOMMIT=1
export LD_LIBRARY_PATH=$GBASE_HOME/lib/gbase/:$LD_LIBRARY_PATH
export TERMINFO=$GBASE_HOME/share/terminfo
[gbase8@localhost GBaseInstall]$
启动数据库服务
[gbase8@localhost GBaseInstall]$ gbase.server start
Starting GBase. SUCCESS!
登陆数据库并测试建库建表等操作
[gbase8@localhost GBaseInstall]$ gccli
bash: gccli: command not found...
[gbase8@localhost GBaseInstall]$ gbase
GBase client Free Edition 8.6.2.43-R7-free.110605. Copyright (c) 2004-2020, GBase. All Rights Reserved.
gbase> create database testdb;
Query OK, 1 row affected (Elapsed: 00:00:00.00)
gbase> use testdb;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)
gbase> create table t1(id int,name varchar(100));
Query OK, 0 rows affected (Elapsed: 00:00:00.04)
gbase> insert into t1 valeus(1,'First');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near 'valeus(1,'First')' at line 1
gbase> insert into t1 values(1,'First');
Query OK, 1 row affected (Elapsed: 00:00:00.05)
gbase> insert into t1 values(2,'第二名');
Query OK, 1 row affected (Elapsed: 00:00:00.05)
gbase> select * from t1;
+------+-----------+
| id | name |
+------+-----------+
| 1 | First |
| 2 | 第二名 |
+------+-----------+
2 rows in set (Elapsed: 00:00:00.00)
gbase> exit
Bye
总结
至此,GBase 8a单机免费版已经顺利完成了。
单机版下载地址