infobright使用记
安装infobright，我使用的是rpm包，用rpm包安装不需手动新建mysql用户与组。
首先下载infobright rpm包：
# wget http://www.infobright.org/downloads/ice/infobright-3.5.2-0-x86_64-ice.rpm
安装infobright rpm包，使用--prefix option指定安装目录：
# rpm -ivh infobright-3.5.2-0-x86_64-ice.rpm --prefix=/usr/local/
Preparing... ########################################### [100%]
Installing infobright 3.5.2-0 (x86_64)
The installer will generate /tmp/ib3.5.2-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
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-3.5.2-x86_64/bin/mysqladmin -u root password 'new-password'
/usr/local/infobright-3.5.2-x86_64/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
Alternatively you can run:
/usr/local/infobright-3.5.2-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-3.5.2-x86_64 ; /usr/local/infobright-3.5.2-x86_64/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/infobright-3.5.2-x86_64/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/local/infobright-3.5.2-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: 3952(MB)
Infobright optimal ServerMainHeapSize is set to 1300(MB)
Infobright optimal LoaderMainHeapSize is set to 400(MB)
Infobright server installed into folder /usr/local/infobright
Installation log file /tmp/ib3.5.2-0-install.log
--------------------------------------
To activate infobright server, please run ./postconfig.sh script from /usr/local/infobright-3.5.2-x86_64.
Example command: cd /usr/local/infobright-3.5.2-x86_64; ./postconfig.sh
开始使用之前需要关注一下infobright安装目录中的结构：
# cd /usr/local
# ll
总计 92
drwxr-xr-x 2 root root 4096 2009-03-12 bin
drwxr-xr-x 2 root root 4096 2009-03-12 etc
drwxr-xr-x 2 root root 4096 2009-03-12 games
drwxr-xr-x 2 root root 4096 2009-03-12 include
lrwxrwxrwx 1 root root 34 02-24 18:43 infobright -> /usr/local/infobright-3.5.2-x86_64
drwxr-xr-x 11 root root 4096 02-24 18:43 infobright-3.5.2-x86_64
drwxr-xr-x 2 root root 4096 2009-03-12 lib
drwxr-xr-x 2 root root 4096 2009-03-12 lib64
drwxr-xr-x 2 root root 4096 2009-03-12 libexec
drwxr-xr-x 2 root root 4096 2009-03-12 sbin
drwxr-xr-x 4 root root 4096 02-23 20:32 share
drwxr-xr-x 2 root root 4096 2009-03-12 src
# ll
总计 92
drwxr-xr-x 2 root root 4096 2009-03-12 bin
drwxr-xr-x 2 root root 4096 2009-03-12 etc
drwxr-xr-x 2 root root 4096 2009-03-12 games
drwxr-xr-x 2 root root 4096 2009-03-12 include
lrwxrwxrwx 1 root root 34 02-24 18:43 infobright -> /usr/local/infobright-3.5.2-x86_64
drwxr-xr-x 11 root root 4096 02-24 18:43 infobright-3.5.2-x86_64
drwxr-xr-x 2 root root 4096 2009-03-12 lib
drwxr-xr-x 2 root root 4096 2009-03-12 lib64
drwxr-xr-x 2 root root 4096 2009-03-12 libexec
drwxr-xr-x 2 root root 4096 2009-03-12 sbin
drwxr-xr-x 4 root root 4096 02-23 20:32 share
drwxr-xr-x 2 root root 4096 2009-03-12 src
从上面的目录文件可以发现其安装的思想与mysql binary包无异，进入softlink中，可以看到cache目录与数据目录宿主、宿组已经是mysql:
# cd infobright
# ll
总计 712
drwxr-xr-x 2 root root 4096 02-24 18:43 bin
drwxr-xr-x 2 mysql mysql 4096 02-24 18:43 cache
drwxr-xr-x 4 mysql mysql 4096 02-24 18:43 data
-rw-r--r-- 1 root root 595003 01-14 23:29 Data_Loading_Guide.pdf
drwxr-xr-x 3 root root 4096 02-24 18:43 include
-rw-r--r-- 1 root root 15208 02-24 18:43 infobright.license
drwxr-xr-x 3 root root 4096 02-24 18:43 lib
drwxr-xr-x 2 root root 4096 02-24 18:43 libexec
-rwxr-xr-x 1 root root 13604 02-01 05:08 postconfig.sh
-rw-r--r-- 1 root root 2557 02-01 05:08 README
drwxr-xr-x 2 root root 4096 02-24 18:43 scripts
drwxr-xr-x 6 root root 4096 02-24 18:43 share
drwxr-xr-x 2 root root 4096 02-24 18:43 support-files
# ll
总计 712
drwxr-xr-x 2 root root 4096 02-24 18:43 bin
drwxr-xr-x 2 mysql mysql 4096 02-24 18:43 cache
drwxr-xr-x 4 mysql mysql 4096 02-24 18:43 data
-rw-r--r-- 1 root root 595003 01-14 23:29 Data_Loading_Guide.pdf
drwxr-xr-x 3 root root 4096 02-24 18:43 include
-rw-r--r-- 1 root root 15208 02-24 18:43 infobright.license
drwxr-xr-x 3 root root 4096 02-24 18:43 lib
drwxr-xr-x 2 root root 4096 02-24 18:43 libexec
-rwxr-xr-x 1 root root 13604 02-01 05:08 postconfig.sh
-rw-r--r-- 1 root root 2557 02-01 05:08 README
drwxr-xr-x 2 root root 4096 02-24 18:43 scripts
drwxr-xr-x 6 root root 4096 02-24 18:43 share
drwxr-xr-x 2 root root 4096 02-24 18:43 support-files
通过rpm包安装后，infobright的配置文件默认是放在/etc/目录下，相关文件如下：
# ll my-*
-rwxr-xr-x 1 root root 2141 02-24 18:43 my-ib.cnf
-rwxr-xr-x 1 root root 2550 02-24 18:43 my-ib-master.cnf
-rwxr-xr-x 1 root root 3044 02-24 18:43 my-ib-slave.cnf
-rwxr-xr-x 1 root root 2141 02-24 18:43 my-ib.cnf
-rwxr-xr-x 1 root root 2550 02-24 18:43 my-ib-master.cnf
-rwxr-xr-x 1 root root 3044 02-24 18:43 my-ib-slave.cnf
infobright默认的端口是5029，可在配置文件中修改。
