Upgrading AnthillPro3
Backup the Server
It is a best practice to back up your AnthillPro3 server before upgrading. The minimum suggested
backup is to backup the database. If you are using the embedded Apache Derby database, then a backup
can be done through the AnthillPro3 Web UI on the System - Backup Settings. Click the 'Backup Now'
button. The backup will take a few moments.
To backup other databases, please follow the procedures outlined by the vendors of the
database to perform a backup.
Upgrade the Server
Before upgrading a server, you should first shut down the server. To perform an upgrade,
follow the same instructions as a installation.
When asked for the directory to install the server, enter the existing server directory.
Upgrade the Server (Windows Only)
To manually upgrade the AnthillPro Server:
- Follow steps 1 to 5 of the Windows installation process.
- Input N to upgrade an existing AnthillPro server.
- If the AnthillPro server is installed as a Windows service: Input the unique name in the dialog box and click OK to stop and remove service (Windows service will be recreated, if desired, at the end of the upgrade process).
- If more than one instance of the AnthillPro server is installed as a Windows service, make sure the correct service name is entered.
- Input the directory where the AnthillPro server is installed.
- Input Y to upgrade the existing server.
- Follow the remainder of step 7 through step 10 of the Windows installation process.
Upgrade Agents
You should upgrade the server before upgrading any agents. AnthillPro3 supports a auto-upgrade
feature to upgrade running agents. The upgrade can be started in the AnthillPro3 Web UI under
System - Agents. Click the 'Upgrade Agents' button to begin the auto-upgrade process. All agents
that are not the correct version and are online will be upgraded. The upgrade can take some time,
so refresh the page to view the progress.
If you need to manually upgrade an agent, you need to stop the agent and follow the the same
instructions as a installation. When asked for the
directory to install the agent, enter the existing agent directory.
Upgrade the Agent (Windows Only)
To manually upgrade the AnthillPro Agent:
- Follow steps 1 to 5 of the Windows installation process.
- Input N to upgrade an existing AnthillPro agent.
- If the AnthillPro agent is installed as a Windows service: Input the unique name in the dialog box and click OK to stop and remove service (Windows service will be recreated, if desired, at the end of the upgrade process).
- If more than one instance of the AnthillPro server is installed as a Windows service, make sure the correct service name is entered.
- Input the directory where the AnthillPro server is installed.
- Input Y to upgrade the existing server.
- Follow the remainder of step 7 through step 11 of the Windows installation process.
Migrate the Server Database
We have seen some scalability issues with the embedded Apache Derby database. If you experience
slowness in the AnthillPro3 Web UI or if the server process is taking up too much memory, it is
likely time to migrate to a different database.
The AnthillPro3 command line installers include a database migration utility that exports
your existing database data and imports it into another supported database. The following
alternative databases are supported:
If using Oracle 9i, you must use the JDBC driver for Oracle 10g.
- MySQL (works with 4.1.22 and later)
If using MySQL 5, use the 5.0.8 driver version. The 5.1 version has
some bugs that will cause the AnthillPro server to throw an error. If
you are using the 5.1 version, switch the driver jar file in the
server's lib/ext directory and then restart.
Database Requirements
If using a database other than Apache Derby:
- You must use one of the command line installers for installation.
- You need to download the appropriate JDBC driver file for your database. These are
typically downloaded from the database vendor.
- You need to create an empty database for AnthillPro3 to use with a dedicated user.
See the User Documentation for detailed instructions on migrating database.
Windows Database Migration from .zip File
To migrate the AnthillPro database, follow the steps below:
- Download the anthill3-<version>.zip file.
- Expand the zip file using a tool like WinZip. Expanding will create a anthill3-install directory.
- Open the anthill3-install directory created in the previous step in Windows Explorer.
- Copy the JDBC driver file(s) of the database you are migrating to into the
anthill3-install\lib\ext directory.
- Run the migration script migrate-db.bat
- If the AnthillPro server is installed as a Windows service: Input the unique name in the dialog box and click OK to stop and remove service (Windows service may be recreated, if desired, in step 10).
- If more than one AnthillPro server is installed as a Windows service, make sure the correct service name is entered.
- Provide the directory where the AnthillPro server is installed.
- Input Y to upgrade the existing server.
- Provide the following:
- Database type AnthillPro should migrate to [derby, oracle, mysql].
- Database driver. See your database vendor documentation for the JDBC driver class to use.
- Database connection string. See your database vendor documentation on the format of this value.
- Database username.
- Database password.
- Follow the remainder of step 7 through step 10 of the Windows installation process.
- See Windows Server Installation from zip File for instructions.
To upgrade the AnthillPro Server:
1. Follow steps 1 to 5 of the Windows installation process.
2. Input N to upgrade an existing AnthillPro server.
3. If the AnthillPro server is installed as a Windows service: Input the unique name in the dialog box and click OK to stop and remove service (Windows service will be recreated, if desired, at the end of the upgrade process).
- If more than one instance of the AnthillPro server is installed as a Windows service, make sure the correct service name is entered.
4. Input the directory where the AnthillPro server is installed.
5. Input Y to upgrade the existing server.
6. Follow the remainder of step 7 through step 10 of the Windows installation process.
Linux/Unix Database Migration from .tar.gz File
To migrate the AnthillPro database, follow the steps below:
- Download the anthill3-<version>.tar.gz file.
- Open a UNIX shell to the directory containing the above downloaded file.
- Extract the downloaded tar.gz file. Type tar -zxf anthill3-<version>.tar.gz .
On some installations of Solaris and HP-UX the default tar command will not properly handle
our tar files. You may need to use \ install GNU tar.
- cd anthill3-install
- Copy the JDBC driver file(s) of the database you are migrating to into the
anthill3-install/lib/ext directory.
- Run the migration script ./migrate-db.sh.
During the migration you will be prompted for the following information:
- The directory where the AnthillPro server is installed.
- Enter the database type Anthill should migrate to. [derby, oracle, mysql]
- Enter the database driver. See your database vendor documentation for the JDBC driver class to use.
- Enter the database connection string. See your database vendor documentation on the format of this value.
- Enter the database username.
- Enter the database password.
