infobright rpm安装

1. 安装 Infobright

[root@local-server ~]# rpm -ivh infobright-4.0.7-0-x86_64-ice.rpm
Preparing… ########################################### [100%]
Installing infobright 4.0.7-0 (x86_64)
The installer will generate /tmp/ib4.0.7-0-install.log install trace log.
1:infobright ########################################### [100%]
Creating/Updating datadir and cachedir
Creating user mysql and group mysql
Installing default databases
Installing MySQL system tables…
OK
Filling help tables…
OK

… …

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/infobright-4.0.7-x86_64 ; /usr/local/infobright-4.0.7-x86_64/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/infobright-4.0.7-x86_64/mysql-test ; perl mysql-test-run.pl

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

System Physical memory: 992(MB)
System memory too low!
Infobright optimal ServerMainHeapSize is set to 400(MB)
Infobright optimal LoaderMainHeapSize is set to 300(MB)
Infobright server installed into folder /usr/local/infobright
Installation log file /tmp/ib4.0.7-0-install.log
————————————–
To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-4.0.7-x86_64.
Example command: cd /usr/local/infobright-4.0.7-x86_64; ./postconfig.sh

2. 配置 Infobright 数据库

默认安装情况下相关配置文件位置如下：

配置文件: [/etc/my-ib.cnf]
brighthouse.ini 文件: [/usr/local/infobright-4.0.7-x86_64/data/brighthouse.ini]
数据存放目录: [/usr/local/infobright-4.0.7-x86_64/data]
缓存目录: [/usr/local/infobright-4.0.7-x86_64/cache]
socket 位置: [/tmp/mysql-ib.sock]
port 端口: [5029]

可以通过执行如下脚本来设置以上配置：

[root@local-server infobright]# /usr/local/infobright/postconfig.sh

然后，根据提示来进行更改配置吧。

3. 启动 Infobright 数据库

[root@local-server bin]# service mysqld-ib start
Starting MySQL.. SUCCESS!

4. 登录 Infobright 数据库并查看支持的存储引擎

[root@local-server bin]# mysql-ib
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.40 build number (revision)=IB_4.0.7_r16961_17249(ice) (static)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> show engines;
+————-+———+———————————————————–+————–+——+————+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+————-+———+———————————————————–+————–+——+————+
| BRIGHTHOUSE | DEFAULT | Brighthouse storage engine | YES | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+————-+———+———————————————————–+————–+——+————+
5 rows in set (0.00 sec)

mysql>