首先从InfoBright官网下载源码,最新的版本是:infobright-4.0.7-0-src-ice.tar.gz
编译安装
1.首先要安装boost_1_42以上版本
tar jxvf boost_1_43_0.tar.bz2
./bootstrap.sh --prefix=/usr/local/boost
./bjam install
export BOOST_ROOT=/usr/local/boost
echo "/usr/local/boost/lib" > /etc/ld.so.conf.d/boost-x86_64.conf
ldconfig
2.编译安装infobright
tar zxvf infobright-4.0.7-0-src-ice.tar.gz
cd infobright-4.0.7 make PREFIX=/usr/local/infobright EDITION=community release make PREFIX=/usr/local/infobright EDITION=community install-release mkdir -p /usr/local/infobright/conf /usr/local/infobright/logs /data/infobright/data chown -R mysql.mysql /usr/local/infobright/conf /usr/local/infobright/logs /data/infobright/data
cp src/build/pkgmt/my-ib.cnf /usr/local/infobright/conf/my-ib.cnf
/usr/local/infobright/bin/mysql_install_db --basedir=/usr/local/infobright --datadir=/data/infobright/data --user=mysql
修改my-ib.cnf为如下
# Example Infobright config file (mysql server). # In this file, you can use all long options that mysql supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 5029 socket = /tmp/mysql-ib.sock loose-local-infile=1 # Here follows entries for some specific programs # The MySQL server [mysqld] basedir = /usr/local/infobright datadir = /data/infobright/data log-error = /usr/local/infobright/var/bh.err log-output = FILE #general_log=1 #general_log_file=path-of-datadir/general_query.log #slow_query_log=1 #slow_query_log_file=path-of-datadir/slow_query.log port = 5029 socket = /tmp/mysql-ib.sock skip-locking key_buffer = 16M max_allowed_packet = 500M table_cache = 16 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 8M net_buffer_length = 8K thread_cache_size = 32 thread_stack = 512K query_cache_size = 8M query_cache_type=0 # Try number of CPU cores*4 for thread_concurrency thread_concurrency = 8 #core-file # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (using the "enable-named-pipe" option) will render mysqld useless! # #skip-networking server-id=1 # log-bin=mysql-bin default-storage-engine=brighthouse collation_server=latin1_bin character_set_server=latin1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 32M sort_buffer_size = 32M read_buffer = 1M write_buffer = 1M [myisamchk] key_buffer = 32M sort_buffer_size = 32M read_buffer = 1M write_buffer = 1M [mysqlhotcopy] interactive-timeout [mysql-test] host=local user=root port=5029 database=dk # suite-timeout=60 testcase-timeout=3600
启动ib实例
/usr/local/infobright/bin/mysqld_safe --defaults-file=/usr/local/infobright/conf/my-ib.cnf --user=mysql > /dev/null 2>&1 &
初始化ib实例的密码
/usr/local/infobright/bin/mysqladmin -u root password "123456"