mysql数据仓库解决方案infobright安装
安装：1.查看操作系统版本及位数：（一下为64为系统） 系统 48G内存 16Cpu2.获取安装包：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.rpm3.安装并配置：[@db_zw_77_81 software]# rpm -i infobright-4.0.6-0-x86_64-ice.rpmInstalling 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 cachedirCreating user mysql and group mysqlInstalling default databasesInstalling MySQL system tables...OKFilling help tables...OK
To start mysqld at boot time you have to copysupport-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 testdatabases and anonymous user created by default. This isstrongly 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.plcd /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/infobrightInstallation 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下对应的数据目录即可。
