mysql数据仓库解决方案infobright安装
安装：
1.查看操作系统版本及位数：（一下为64为系统） 系统 48G内存 16Cpu
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下对应的数据目录即可。
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql数据仓库解决方案infobright装配
转载请注明原文链接：mysql数据仓库解决方案infobright装配
