How To Install Infobright on Linux Env

How To Install Infobright on Linux Env

Infobright is a commercial provider of column-oriented relational database software with a focus in machine-generated data.

Infobright Community Edition (ICE)

The Open-Source Database for Ad hoc Analytics

Infobright’s column oriented, open-source analytic database provides both speed and efficiency. Coupled with 10:1 average compression, ICE takes your machine generated data and gives you the ultimate power to slice-n’-dice your data. Plus, it’s free!

install infobright on Ubuntu/Debian
# wget http://www.infobright.org/downloads/ice/infobright-4.0.7-0-i686-ice.deb

# dpgk -i infobright-4.0.7-0-i686-ice.deb

install infobright on Centos
# wget https://www.infobright.org/downloads/ice/infobright-4.0.7-0-i686-ice.rpm

# rpm -ivh infobright-4.0.7-0-i686-ice.rpm --prefix=/usr/local/

# cd /usr/local/infobright-4.0.7-i686

# ./postconfig.sh

# /usr/local/infobright-4.0.7-i686/bin/mysql

[root@a5go ~]# /usr/local/infobright-4.0.7-i686/bin/mysql

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 27

Server version: 5.1.40 build number (revision)=IB_4.0.7_r16086_16275(ice) (static)

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

mysql>

infobright start|stop|restart
# /etc/init.d/mysqld-ib stop

# /etc/init.d/mysqld-ib start

Enable remote connect
GRANT ALL PRIVILEGES ON *.* TO 'a5go'@'%' IDENTIFIED BY 'a5go' WITH GRANT OPTION;

flush privileges;

Remote connect

mysql -ua5go -pa5go -h10.10.10.10 --port 5029

Note:

1. Support the MySQL native SQL
# vim /usr/local/infobright-4.0.7-i686/data/brighthouse.ini

set AllowMySQLQueryPath = 1

How To Install Infobright on Linux Env