infobright安装（RPM包，二进制，源码编译）

浅浅的花香味﹌ 2022-06-12 11:46 227阅读 0赞

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