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

一、RPM安装1.下载2.root权限用户安装rpm -ivh infobright-version.rpm  –prefix=/usr/local装完后在目标目录下会有两个新文件夹，infobright-version-86_x64和其链接infobright3.启动infobright：/etc/init.d/mysqld-ib start4.任意路径下运行mysql-ib二、二进制安装1.下载、解压、软链http://www.infobright.org/Download/ICE/虚拟机使用的32位linux版，国内下载tar -zxvf infobright-4.0.4-0-linux-i686-ice.tar.gzmv infobright-4.0.4-i686/ /usr/local/cd /usr/localln -s infobright-4.0.4-i686/ infobright2.安装infobrightcd /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 codehttp://www.infobright.org/Download/ICE/2.确认环境rpm -q gccrpm -q autoconfrpm -q boost3.如果有缺少则进行安装autoconf下载后解压./configure --prefix=/usrmakemake installboost1.43下载后解压./bootstrap.sh --prefix=/usr/local/boost_1_43_0./bjam installexport BOOST_ROOT=/usr/local/boost_1_43_0ldconfig4.编译 安装shell> groupadd mysqlshell> useradd -g mysql mysqlshell> cd infobright-versionshell> make EDITION=community releaseshell> make EDITION=community install-release5.配置环境shell> cp src/build/pkgmt/my-ib.cnf /etc/shell> cd /usr/local/infobrightshell> bin/mysql_install_db –defaults-file=/etc/my-ib.cnf –user=mysqlshell> chown -R root  .shell> chown -R mysql var cacheshell> chgrp -R mysql .安装启动脚本：shell> cp share/mysql/mysql.server /etc/init.d/mysqld-ibshell> vi /etc/init.d/mysqld-ib找到以下两行：conf=@BH_CONF@user=@BH_USER@修改为：Shell代码conf=/etc/mysql-ib.cnfuser=mysql加入开机启动：shell> chkconfig –add mysqld-ib增加客户端软链ln -s ./bin/mysql /usr/local/mysql-ib6.启动/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_upgrade4.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 startcd /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.iniServerMainHeapSize为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