ICE 4.0.3 GA – Upgrade Notes

1. With ICE 3.4.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.

Windows Upgrade Instructions

1. Stop the Infobright server using the Start Menu item.

2. Follow the Install Guide for Windows. The Install Wizard automatically detects a previous version of ICE and upgrades your Infobright installation while preserving your data and configuration settings.

3. Stop the Infobright server from the Start Menu item

4. Start the Infobright server from the Start Menu item

5. Create or ensure that the directory c:\tmp exists (necessary for step 7)

6. Run the MySQL Upgrade utility from the Windows command line:

cd "C:\Program Files\Infobright"
.\bin\mysql_upgrade.exe --defaults-file="c:\Program Files\Infobright\my-ib.ini” -uroot --tmpdir=c:\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.

8. Stop and start the Infobright server from the Start Menu items.