infobright安装

安装：

1.查看操作系统版本及位数：（一下为64为系统） 系统 48G内存 16Cpu

2.获取安装包：wget http://www.infobright.org/mint/pepper/tillkruess/downloads/tracker.php?url=http%3A//www.infobright.org/downloads/ice/infobright-4.0.6-0-x86_64-ice.rpm

3.安装并配置：

[@db_zw_77_81 software]# rpm -i infobright-4.0.6-0-x86_64-ice.rpm

Installing infobright 4.0.6-0 (x86_64)

The installer will generate /tmp/ib4.0.6-0-install.log install trace log.

Creating/Updating datadir and cachedir

Creating user mysql and group mysql

Installing default databases

Installing MySQL system tables...

OK

Filling help tables...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/local/infobright-4.0.6-x86_64/bin/mysqladmin -u root password 'new-password'

/usr/local/infobright-4.0.6-x86_64/bin/mysqladmin -u root -h db_zw_77_81 password 'new-password'

Alternatively you can run:

/usr/local/infobright-4.0.6-x86_64/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default. This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr/local/infobright-4.0.6-x86_64 ; /usr/local/infobright-4.0.6-x86_64/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/local/infobright-4.0.6-x86_64/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/infobright-4.0.6-x86_64/scripts/mysqlbug script!

The latest information about MySQL is available at http://www.mysql.com/

Support MySQL by buying support/licenses from http://shop.mysql.com/

System Physical memory: 48288(MB)

Infobright optimal ServerMainHeapSize is set to 32000(MB)

Infobright optimal LoaderMainHeapSize is set to 800(MB)

Infobright server installed into folder /usr/local/infobright

Installation log file /tmp/ib4.0.6-0-install.log

--------------------------------------

To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-4.0.6-x86_64.

Example command: cd /usr/local/infobright-4.0.6-x86_64; ./postconfig.sh

[@db_zw_77_81 software]# cd /usr/local/infobright-4.0.6-x86_64

[@db_zw_77_81 infobright-4.0.6-x86_64]# ./postconfig.sh

设置即可。

修改：/etc/init.d/mysql-ib 中配置文件路径

修改配置文件 /etc/my-ib.conf

修改brighthouse配置 /data/infobright/data/brighthouse.ini

注意权限。

infobright备份恢复：

只需要对data目录备份即可。

恢复只需要将对应的 数据表文件 拷贝到 目的数据库的data下对应的数据目录即可。