gbase8a  4节点安装配置过程

192.168.98.165
192.168.98.166
192.168.98.167
192.168.98.168

配置主机名
禁用selinux
禁用防火墙
重启 

 

[root@node015 ~]# cd /home
[root@node015 home]# ls
gbase  GBase8a_MPP_Cluster-8.5.1.2-build5.1-utf8-redhat6.2-x86_64.tar.gz  gcinstall  storm  upload
[root@node015 home]# cd gcinstall/
[root@node015 gcinstall]# ls
authkey.demo        DBDCluster.py    DBname.pyc        gcinstall.py         netverify.py   sshtrust_conf.sh
auto_add_sg.py      DBfunctions.py   demo.options      gcluster.xml         netverify.pyc  SystemProfileFactory.py
auto_install.sh     DBfunctions.pyc  designerTests.py  gen_demo_options.py  pexpect.py     SystemProfileFactory.pyc
bundle.tar.gz       DBinclude.py     Diagnostics.py    install_config       pexpect.pyc    TXTlcheck.py
c3_conf.sh          DBinclude.pyc    ErrorMonitor.py   log                  SSH.py         unInstall.py
commandLineCtrl.py  DBname.py        ErrorMonitor.pyc  LogRotate.py         SSH.pyc        unInstall.sh
[root@node015 gcinstall]# vi demo.options

authkey_file_name = authkey.demo
gcluster_dba_group = gbase
#gcluster_dba_group_id = 1234
gcluster_dba_user = gbase
#gcluster_dba_user_id = 1234
gcluster_dba_user_password = gbase
hosts =  192.168.98.165,192.168.98.166,192.168.98.167,192.168.98.168
mcast_addr = 226.94.1.39
mcast_port = 5493
root_password = jianguo123
source = 192.168.98.165
skip_network_test = false~
~
~
~
"demo.options" 12L, 369C written
[root@node015 gcinstall]# ps -ef|grep gbase
root      3207  3185  0 14:14 pts/6    00:00:00 grep gbase
[root@node015 gcinstall]# pwd
/home/gcinstall
[root@node015 gcinstall]# ls
authkey.demo        DBDCluster.py    DBname.pyc        gcinstall.py         netverify.py   sshtrust_conf.sh
auto_add_sg.py      DBfunctions.py   demo.options      gcluster.xml         netverify.pyc  SystemProfileFactory.py
auto_install.sh     DBfunctions.pyc  designerTests.py  gen_demo_options.py  pexpect.py     SystemProfileFactory.pyc
bundle.tar.gz       DBinclude.py     Diagnostics.py    install_config       pexpect.pyc    TXTlcheck.py
c3_conf.sh          DBinclude.pyc    ErrorMonitor.py   log                  SSH.py         unInstall.py
commandLineCtrl.py  DBname.py        ErrorMonitor.pyc  LogRotate.py         SSH.pyc        unInstall.sh
[root@node015 gcinstall]# pwd
/home/gcinstall
[root@node015 gcinstall]# ./gcinstall.py --silent=demo.options
GBase Database 8.5.1.2 Installation Tool

Starting installation tasks...

Getting system information for cluster (this may take a while)....

Begin Installation
['192.168.98.165', '192.168.98.166', '192.168.98.167', '192.168.98.168']
Very first check on all nodes:
Checking/fixing OS parameters.....

Detected cpufreq module loaded on 192.168.98.168
Detected cpufreq module loaded on 192.168.98.165
Detected cpufreq module loaded on 192.168.98.167
Detected cpufreq module loaded on 192.168.98.166
CPU frequency scaling is enabled.  This may adversely affect the performance of your database.
GBase recommends that cpu frequency scaling be turned off or set to 'performance'

Creating/Checking GBase DBA group

Creating/Checking GBase DBA user

Setting /etc/security/limits.conf nproc  to 7855 ...
Setting /etc/security/limits.conf nproc  to 7855 ...
Setting /etc/security/limits.conf nproc  to 7855 ...
Setting /etc/security/limits.conf nproc  to 7855 ...
Installing/Repairing SSH keys for gbase

Creating GBase Data Directory...

Testing N-way network test.  (this may take a while)
 All hosts are available                            ... 
Host availability                                  ...
 IP configuration                                   ... 
 IP configuration                                   ... 
 IP configuration                                   ... 
 IP configuration                                   ... 

Running Consistency Tests
 LANG and TZ environment variables                  ... 
Running Network Connectivity and Throughput Tests...
Waiting for 1 of 4 sites...                         ... 

  Consistency Test (ok) 
=========================

  Info: The $TZ environment variable is not set on  192.168.98.165
  Info: The $TZ environment variable is not set on  192.168.98.166
  Info: The $TZ environment variable is not set on  192.168.98.167
  Info: The $TZ environment variable is not set on  192.168.98.168

  Network Test (ok) 
=====================

    Network communication (ok) 
  ------------------------------
    Low throughput 192.168.98.165 to 192.168.98.165: 31.4338126942 Mbps; check network interface/switch configuration
    Low throughput 192.168.98.166 to 192.168.98.166: 31.8648917117 Mbps; check network interface/switch configuration
    Low throughput 192.168.98.167 to 192.168.98.167: 31.7004921194 Mbps; check network interface/switch configuration
 

Install on all nodes...
Install on all nodes...

 

Error Monitor  0 errors  1 warnings
Installation completed with warnings. 
[root@node015 gcinstall]#

 

添加safegroup
su - gbsae

gcadmin addsg --nodes 192.168.98.165, 192.168.98.166 --names node1, node2
gcadmin addsg --nodes 192.168.98.167, 192.168.98.168 --names node3, node4

[gbase@node015 ~]$ gcadmin addsg --nodes 192.168.98.165, 192.168.98.166 --names node1, node2
Address:        [192.168.98.165] <--> Node id : [2774706368]
dpname value:   [n1].
nodename value: [node1]
Address:        [192.168.98.166] <--> Node id : [2791483584]
dpname value:   [n2].
nodename value: [node2]
safegroup name: [sg01]

[addsafegroup] Add SafeGroup Complete.

[gbase@node015 ~]$ gcadmin addsg --nodes 192.168.98.167, 192.168.98.168 --names node3, node4
Address:        [192.168.98.167] <--> Node id : [2808260800]
dpname value:   [n3]
nodename value: [node3]
Address:        [192.168.98.168] <--> Node id : [2825038016]
dpname value:   [n4]
nodename value: [node4]
safegroup name: [sg02]

init new safegroup node,there may be consume some time,please wait a moment...
init the 192.168.98.167 node environment from source node 192.168.98.165...
Warning: Permanently added '192.168.98.167' (RSA) to the list of known hosts.
 
Init server ok!
Warning: Permanently added '192.168.98.167' (RSA) to the list of known hosts.
init the 192.168.98.168 node environment from source node 192.168.98.167...
/usr/bin/gc_sync_cpnode.py 192.168.98.167 192.168.98.165
Warning: Permanently added '192.168.98.168' (RSA) to the list of known hosts.
 
Warning: Permanently added '192.168.98.168' (RSA) to the list of known hosts.
[addsafegroup] Add SafeGroup Complete.

[gbase@node015 ~]$

[gbase@node015 ~]$ gcadmin

  CLUSTER STATE:  ACTIVED
  CLUSTER MODE:   NORMAL

  =========================================================================================================================
 |                                                  GCLUSTER INFORMATION                                                   |
  =========================================================================================================================
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
 | rowid | nodename |    IpAddress   | sgname | dpname | gcware  |  gnode  | gcluster | syncserver | datastate | nodestate |
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
 |   1   |   node1  | 192.168.98.165 |  sg01  |   n1   | Online  |  OPEN   |   OPEN   |    OPEN    |  [0]      |  [0]      |
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
 |   2   |   node2  | 192.168.98.166 |  sg01  |   n2   | Online  |  OPEN   |   OPEN   |    OPEN    |  [0]      |  [0]      |
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
 |   3   |   node3  | 192.168.98.167 |  sg02  |   n3   | Online  |  OPEN   |   OPEN   |    OPEN    |  [0]      |  [0]      |
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
 |   4   |   node4  | 192.168.98.168 |  sg02  |   n4   | Online  |  OPEN   |   OPEN   |    OPEN    |  [0]      |  [0]      |
  ------- ---------- ---------------- -------- -------- --------- --------- ---------- ------------ ----------- -----------
[gbase@node015 ~]$

[gbase@node015 ~]$ gccli -ugbase -pgbase20110531 -h127.0.0.1 -P5258
Welcome to the GBase monitor.  Commands end with ; or \g.
Your gcluster connection id is 6
Server version: 8.5.1.2

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

gbase>
gbase> show databases;
--------------------
| Database           |
--------------------
| information_schema |
| gbase              |
| gclusterdb         |
| gctmpdb            |
--------------------
4 rows in set (Elapsed: 00:00:00.02)

gbase>
初始化数据库

gbase> initnodedatamap;
Query OK, 0 rows affected (Elapsed: 00:00:07.09)

创建数据库

gbase> create database cup;
Query OK, 1 row affected (Elapsed: 00:00:00.71)

重新连接数据库，创建表

base> create table ljg (name varchar(10) ,olds numeric(8));
ERROR 1046 (3D000): No database selected
gbase> show databases;
--------------------
| Database           |
--------------------
| information_schema |
| cup                |
| gbase              |
| gclusterdb         |
| gctmpdb            |
--------------------
5 rows in set (Elapsed: 00:00:00.00)

gbase> use cup
    -> ;
Query OK, 0 rows affected (Elapsed: 00:00:00.01)

gbase> create table ljg (name varchar(10) ,olds numeric(8));
Query OK, 0 rows affected (Elapsed: 00:00:04.02)

 

5258端口连接的是8a

5050端口连接的是8a node(在各节点创建的对象属于本地对象，不属于全局对象)
[gbase@node017 ~]$  gccli -ugbase -pgbase20110531 -h127.0.0.1 -P 5050
Welcome to the GBase monitor.  Commands end with ; or \g.
Your gcluster connection id is 6
Server version: 8.5.1.2

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

gbase> show databases;
--------------------
| Database           |
--------------------
| information_schema |
| cup                |
| gbase              |
| gclusterdb         |
| gctmpdb            |
--------------------
5 rows in set (Elapsed: 00:00:00.00)

gbase> use cup
    -> ;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> desc ljg;
ERROR 1146 (42S02): Table 'cup.ljg' doesn't exist
gbase> select * from dual;
ERROR 1096 (HY000): No tables used
gbase>

显示当前连接的是哪个数据库
gbase> select database();
------------
| database() |
------------
| cup        |
------------
1 row in set (Elapsed: 00:00:00.00)