Installation instructions for ICE 3.0 RC1:

1. Download the package infobright-3.0-x86_64.tar.gz or infobright-3.0-i686.tar.gz to the server where you are installing Infobright

2. Obtain root user access

3. Create the mysql user and group

groupadd mysql
useradd -g mysql mysql

4. Change to the parent location in which you want to install (e.g. /usr/local)

cd /usr/local

5. Unpack the tarball, which will create the product directory (infobright-3.0-x86_64/), and reate a symbolic link ‘mysql’ to the product folder

gunzip < /path/to/infobright-3.0-x86_64.tar.gz | tar xvf -
ln -s /usr/local/infobright-3.0-x86_64 mysql

6. Change the mysql directory and set the owner and group to mysql

cd mysql
chown -R mysql .
chgrp -R mysql .

7. Run the install script with the “—help” flag to check for system configuration and provide examples of directory parameters

./install-infobright.sh --help

Parameters required-
--datadir=infobright data folder [‑‑datadir=/usr/local/mysql/data]
--cachedir=infobright cache folder [‑‑cachedir=/usr/local/mysql/cache]
--config=mysql conf file to be created [--config=/etc/my.cnf]
--port=infobright server port [--port=3306]
--socket=socket file to be used by this server [‑‑socket=/tmp/mysql.sock]
--user=user to be created if not exist [--user=mysql]
--group=user group be created if not exist [--group=mysql]

Example command
./install-infobright.sh (install with defaults)
./install-infobright.sh --help
./install-infobright.sh --force (bypass system compatibility checking)
./install-infobright.sh --datadir=/usr/local/mysql/data --cachedir=/usr/local/mysql/cache --port=3306 --config=/etc/my.cnf --socket=/tmp/mysql.sock --user=mysql --group=mysql --force

8. Run the install script again, this time with directory parameters. If parameters are used that already exist, an error will occur (for example running the same script with parameters twice)

9. Change default memory configuration by editing the file brighthouse.ini within the data directory. The following table lists the parameters and some recommended values based on the amount of system memory (values are expressed in megabytes).

System	Server Main	Server Compressed	Loader Main
Memory	Heap Size	Heap Size	Heap Size
32 GB	24000	4000	800
16 GB	10000	1000	800
8 GB	4000	500	800
Default	4000	500	800
.

Note: The default values are set in the brighthouse.ini file, and if these values or that file are deleted, they will be reset to the application minimum allowed values of 600, 250, and 320 for ServerMainHeapSize, ServerCompressedHeapSize, and LoaderMainHeapSize respectively and performance may be impacted.

The 32-bit install is also set to the minimum allowed values of 600, 250, and 320 for ServerMainHeapSize, ServerCompressedHeapSize, and LoaderMainHeapSize respectively.

10. Change user to mysql in order to run the mysql client and server

11. To start the Infobright server, run:

cd /usr/local/mysql
bin/mysqld_safe --defaults-file=/etc/my.cnf &

To connect to the Infobright server, run:

/usr/local/mysql/bin/mysql --defaults-file=/etc/my.cnf -uroot

To stop the Infobright server, run:

/usr/local/mysql/bin/mysqladmin --defaults-file=/etc/my.cnf -uroot shutdown