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