IEE 4.0.3 GA – Upgrade Notes

1. With IEE 4.0.3, several tuning parameters are now configured automatically and have been deprecated from the brighthouse.ini file. The deprecated parameters include:

• ServerCompressedHeapSize
• LoaderSaveThreadNumber
• BufferingLevel
• CachingLevel
• ClusterSize
• HugefileDir

2. Due to a known issue with the embedded version of MySQL, it is recommended you run the MySQL Updater program after any upgrade to avoid issues with stored procedures or table structures.

3. The enable UTF-8 flag (UseCharset = 0/1) is no longer needed and if present, must be removed from the brighthouse.ini file. For table structures created prior to IEE 3.3.1 the Charset Migration Tool (CHMT) should be run during upgrade.

To upgrade Infobright on Solaris using the tarball package:

Unpack the tarball into a temporary folder. Use the gunzip utility for unpacking:
cd /path/to/temp/

gunzip < /path/to/infobright-4.0.3-x86_64.tar.gz | tar xvf –

Stop the Infobright server:
/etc/init.d/mysqld-ib stop

Run the install script with the “—upgrade” and “—config” flags and pass in the configuration files of the previously installed version:

./install-infobright.sh —upgrade –config=/etc/my-ib.cnf

Start the Infobright server and run the mysql_upgrade utility:

/etc/init.d/mysqld-ib start
cd /opt/infobright
LD_LIBRARY_PATH=/opt/infobright/lib/mysql
export LD_LIBRARY_PATH
./bin/mysql_upgrade —defaults-file=/etc/my-ib.cnf —user=root —tmpdir=/tmp

Important:
The MySQL Upgrade utility may display several errors regarding the use of locks with log tables and errors requiring table upgrades. The errors are all handled automatically by Infobright and/or the upgrade utility and can be ignored.

Restart the Infobright server:
/etc/init.d/mysqld-ib restart

Confirm the build version as IB_4.0_r13151_13690:
/opt/infobright/bin/mysqld —version

If you are upgrading from Infobright 3.5 or earlier, run the Infobright upgrade tool.

This creates stored procedures used by the DomainExpert.
cd /usr/local/infobright
./infobright_upgrade.sh -u <user> -p
i.e. ./infobright_upgrade.sh -u root
Usage: ./infobright_upgrade.sh [-u <user>] [-p ]

If you are upgrading from a version prior to IEE 3.3.2, you must update your table structures.

If you are upgrading from a version prior to IEE 3.3.2, you must update your table structures after upgrading IEE. Do NOT follow these instructions if you are upgrding from IEE 3.3.2 or higher or you may experience data corruption. If you are unsure what version of IEE you are using, please contact Professional Services.

Stop the Infobright server from the Start Menu items

Run the Charset Migration Tool (as user mysql):
cd /usr/local/infobright
./bin/chmt –datadir=/absolute/path/to/data/directory

Start the Infobright server from the Start Menu items