infobright安装（RPM包，二进制，源码编译）-蒲公英云

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’;"