ICE 3.5.2 GA – Upgrade Notes

1. With ICE 3.5.2 GA, 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 ICE 3.3.2 the Charset Migration Tool (CHMT) should be run during upgrade.

Linux Upgrade Instructions Using the Tar Package

1. Obtain root user access

2. Unpack the tarball into a temporary folder:

cd /path/to/temp/
gunzip < /path/to/infobright-3.5.2-x86_64.tar.gz | tar xvf -
cd infobright-3.5-x86_64

3. Stop the Infobright server:

/etc/init.d/mysqld-ib stop

3. 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

4. Run the Charset Migration Tool:

cd /usr/local/infobright
./bin/chmt --datadir=/absolute/path/to/data/directory

5. Start the Infobright server and run the mysql_upgrade utility:

/etc/init.d/mysqld-ib start
cd /usr/local/infobright
./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.

6. Re-start the Infobright server:

/etc/init.d/mysqld-ib restart

7. Confirm the build version as IB_3.5.2_r11794_12019:

/usr/local/infobright/bin/mysqld --version