Infobright on Ubuntu 安装

最新推荐文章于 2022-07-14 09:53:53 发布

AceDoctor

最新推荐文章于 2022-07-14 09:53:53 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签： infobright olap mysql

本文链接：https://blog.youkuaiyun.com/AceDoctor/article/details/48656099

MySQL 专栏收录该内容

1 篇文章

订阅专栏

本文档提供了在Ubuntu x86_64环境下安装Infobright OLAP数据库的步骤，包括下载适用于Ubuntu的Infobright RPM包的链接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、下载

Centos 6.4_x86_64

wget https://www.infobright.org/downloads/ice/infobright-4.0.7-0-x86_64-ice.rpm

Ubuntu x86_64

wget https://www.infobright.org/downloads/ice/infobright-4.0.7-0-x86_64-ice.deb

下载地址：
https://www.infobright.org/index.php/download/ICE/

以Ubuntu为例：
2、安装
#dpkg -i infobright-4.0.7-0-x86_64-ice.deb
Selecting previously unselected package infobright.
(正在读取数据库 ... 系统当前共安装有 173684 个文件和目录。)
Preparing to unpack infobright-4.0.7-0-x86_64-ice.deb ...
Installing infobright 4.0.7-0 (x86_64)
The installer will generate /tmp/ib4.0.7-0-install.log install trace log.
Unpacking infobright (4.0.7-0) ...
正在设置 infobright (4.0.7-0) ...
Creating/Updating datadir and cachedir
Creating user mysql and group mysql
Installing default databases
Installing MySQL system tables...
OK
Filling help tables...
OK

3、激活
# sh /usr/local/infobright-4.0.7-x86_64/postconfig.sh
Infobright post configuration
--------------------------------------
Infobright server activated.
--------------------------------------
Register your copy of ICE and receive a free copy of the User Manual (a $50 value) as well as a copy of the Bloor Research Spotlight Report "What's Cool About Columns" which explains the differences and benefits of a columnar versus row database.
Registration will require opening an HTTP connection to Infobright, do you wish to register now? [Y/N]: y
Do you want to tell us a bit about yourself? We will try to send your information to our server. [Y/N]: y
First Name: jason
Last Name: liu
Company: sunshain
Job Title: dba

4、启动infobright
# /etc/init.d/mysqld-ib start
#/etc/init.d/mysqld-ib status

5、设置root密码
# /usr/local/infobright-4.0.7-x86_64/bin/mysqladmin -u root password '123456'

6、设置远程登录权限
#mysql-ib -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

注：
infobright的默认端口是5029，配置文件/etc/my-ib.cnf