官方文档https://mariadb.com/kb/en/library/mariadb-columnstore/
推荐使用最新1.2.x最新版本。
先决条件
yum -y install boost
yum -y install expect perl perl-DBI openssl zlib file sudo libaio rsync snappy net-tools numactl-libs nmap
安装1.0的jemalloc,可下载rpm包如jemalloc-3.6.0-1.el7.x86_64.rpm。
安装(单机)
推荐下载linux二进制版本https://downloads.mariadb.com/ColumnStore/1.2.2/centos/x86_64/7/mariadb-columnstore-1.2.2-1-centos7.x86_64.bin.tar.gz,更加透明。
直接运行自带shell命令/usr/local/mariadb/columnstore/bin/quick_installer_single_server.sh即可完成单机版本安装与启动。
使用这种模式安装的columnstore并没有独立UM模块,而是作为原生进程存在(否则、至少需要2台服务器)。
安装完成后,建议执行命令/usr/local/mariadb/columnstore/bin/columnstoreAlias为columnstore的两个主要客户端:SQL客户端以及mcsadmin(MariaDB ColumnStore MySQL Console)创建别名:
其中:
#和非columnstore引擎的mysql是一样的
mcsmysql = /usr/local/mariadb/columnstore/mysql/bin/mysql--defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf-u root #默认密码为空
mcsadmin= /usr/lodcal/mariadb/columnstore/bin/mcsadmin
然后就可以检查节点状态了(节点状态异常是可用来查看),如下所示:
[root@oel-12c ~]#mcsadmin getsysteminfo
getsysteminfo Wed Mar 13 15:52:54 2019System columnstore-1System and Module statuses
Component Status Last Status Change------------ -------------------------- ------------------------System ACTIVE Tue Mar12 13:35:07 2019Module pm1 ACTIVE Tue Mar12 13:34:59 2019MariaDB ColumnStoreProcessstatusesProcess Module Status Last Status Change ProcessID------------------ ------ --------------- ------------------------ ----------ProcessMonitor pm1 ACTIVE Tue Mar12 13:34:23 2019 1281ProcessManager pm1 ACTIVE Tue Mar12 13:34:29 2019 1838DBRMControllerNode pm1 ACTIVE Tue Mar12 13:34:39 2019 2428ServerMonitor pm1 ACTIVE Tue Mar12 13:34:42 2019 2447DBRMWorkerNode pm1 ACTIVE Tue Mar12 13:34:42 2019 2465PrimProc pm1 ACTIVE Tue Mar12 13:34:45 2019 2544ExeMgr pm1 ACTIVE Tue Mar12 13:34:50 2019 2628WriteEngineServer pm1 ACTIVE Tue Mar12 13:34:54 2019 2685DDLProc pm1 ACTIVE Tue Mar12 13:34:58 2019 2756DMLProc pm1 ACTIVE Tue Mar12 13:35:06 2019 2827mysqld pm1 ACTIVE Tue Mar12 13:34:36 2019 2260Active Alarm Counts: Critical= 0, Major = 0, Minor = 0, Warning = 0, Info = 0[root@oel-12c ~]#mcsadmin getsystemstatus
getsystemstatus Wed Mar 13 15:53:05