infobright安装（RPM包，二进制，源码编译）、升级及配置

一、RPM安装
1.下载
2.root权限用户安装
rpm -ivh infobright-version.rpm  –prefix=/usr/local
装完后在目标目录下会有两个新文件夹，
infobright-version-86_x64和其链接infobright
3.启动infobright：/etc/init.d/mysqld-ib start
4.任意路径下运行mysql-ib

二、二进制安装

1.下载、解压、软链

http://www.infobright.org/Download/ICE/

虚拟机使用的32位linux版，国内下载
tar -zxvf infobright-4.0.4-0-linux-i686-ice.tar.gz
mv infobright-4.0.4-i686/ /usr/local/
cd /usr/local
ln -s infobright-4.0.4-i686/ infobright

2.安装infobright
cd /usr/local/infobright
查看安装参数
./install-infobright.sh --help
自定义比较多的是 --datadir=/usr/local/infobright/data --port=5029
完整默认参数为
./install-infobright.sh --datadir=/usr/local/infobright/data

  --cachedir=/usr/local/infobright/cache --port=5029

  --config=/etc/my-ib.cnf --socket=/tmp/mysql-ib.sock

  --user=mysql --group=mysql
直接默认安装
./install-infobright.sh
中途有个许可协议浏览过程

3.启动infobright
/etc/init.d/mysqld-ib start

三、源码编译安装
1.下载source code

http://www.infobright.org/Download/ICE/

2.确认环境
rpm -q gcc
rpm -q autoconf
rpm -q boost

3.如果有缺少则进行安装
autoconf
下载后解压
./configure --prefix=/usr
make
make install

boost1.43
下载后解压
./bootstrap.sh --prefix=/usr/local/boost_1_43_0
./bjam install
export BOOST_ROOT=/usr/local/boost_1_43_0
ldconfig

4.编译 安装
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd infobright-version
shell> make EDITION=community release
shell> make EDITION=community install-release

5.配置环境
shell> cp src/build/pkgmt/my-ib.cnf /etc/
shell> cd /usr/local/infobright
shell> bin/mysql_install_db –defaults-file=/etc/my-ib.cnf –user=mysql
shell> chown -R root  .
shell> chown -R mysql var cache
shell> chgrp -R mysql .
安装启动脚本：
shell> cp share/mysql/mysql.server /etc/init.d/mysqld-ib
shell> vi /etc/init.d/mysqld-ib
找到以下两行：
conf=@BH_CONF@
user=@BH_USER@
修改为：
Shell代码
conf=/etc/mysql-ib.cnf
user=mysql
加入开机启动：
shell> chkconfig –add mysqld-ib
增加客户端软链
ln -s ./bin/mysql /usr/local/mysql-ib

6.启动
/etc/init.d/mysql-ib start

四、版本升级
4.1.RPM升级
rpm -Uvh infobright-version-platform.rpm
/etc/init.d/mysqld-ib start
开启ib后执行升级脚本
cd /usr/local/infobright
./bin/mysql_upgrade --defaults-fle=/etc/my-ib.cnf --user=root --tmpdir=/tmp
/etc/init.d/mysqld-ib restart
如果是3.5以前的旧版本，还需要更新domainexpert的存储过程
cd /usr/local/infobright
./infobright_upgrade.sh -u <user> -p <password>
注意上面是mysql_upgrade,这次是Infobright_upgrade

4.2二进制包升级
解压
cd /path/to/temp/
gunzip < /path/to/infobright-version-x86_64.tar.gz | tar xvf -
/etc/init.d/mysqld-ib stop
./install-infobright.sh  --upgrade --confg=/etc/my-ib.cnf
运行安装命令，加上upgrade参数，之后的操作如rpm包安装
/etc/init.d/mysqld-ib start
cd /usr/local/infobright
./bin/mysql_upgrade --defaults-fle=/etc/my-ib.cnf --user=root --tmpdir=/tmp
/etc/init.d/mysqld-ib restart
如果是3.5以前的旧版本，还需要更新domainexpert的存储过程
cd /usr/local/infobright
./infobright_upgrade.sh -u <user> -p <password>

【修改参数配置】
vi /usr/local/infobright/data/brighthouse.ini
ServerMainHeapSize为IB所使用内存的最大值（不包括bh_loader），如果是专用DB服务器，

可适当调大，保证在业务最高峰，系统swap交换不高即可
LoaderMainHeapSize由于是列式存储，IB需要将多行数据各列数据组合后写入数据块，

如果导入表的列数很多，字段很长，将该值调高，加快导入速率（导入前set autocommit=0,

完成后commit+复原，可大幅提高导入效率）
ControlMessages 为IB错误日志记录类型，实验环境设为4有利于排错，

成熟的生产环境设为2或3即可
KNFolder 为知识网格所在目录，通常情况下大小都很小，直接放在data目录下即可

【给予局域网访问权限】
GRANT ALL PRIVILEGES ON *.* TO ‘root’@'192.168.201.%' WITH GRANT OPTION ;
flush PRIVILEGES;

【每日更新load的脚本】转载自张鹏的博客
/usr/local/mysql/bin/mysql -u admin -p111

–default-character-set=utf8

-S /tmp/mysql.sock -D analytic

-e "select * from visitlog where time > date_add(curdate(),

interval -1 day) into outfile ‘/usr/local/csv/visitlog_${enddate}.csv’

FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘\”‘  ESCAPED BY ‘\\\’ LINES TERMINATED BY ‘\n’;"

/usr/local/infobright/bin/mysql -u admin -p111

–default-character-set=utf8

-S /tmp/mysql-ib.sock -D analytic

–skip-column-names

-e "LOAD DATA INFILE ‘/usr/local/csv/visitlog_${enddate}.csv’

INTO TABLE visitlog FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\\\’

LINES TERMINATED BY ‘\n’;"

http://www.mysqlsky.com/201110/infobright-setup-install-upgrade