We have seen some scalability issues with the embedded Apache Derby database. If you experience slowness in the AnthillPro Web UI or if the server process is taking up too much memory, it is likely time to migrate to a different database.
The AnthillPro command line installers include a database migration utility that exports your existing database data and imports it into another supported database.
| If you want to move or create a test instance of your AnthillPro server, but keep the same database type, see Clone AnthillPro Instance. |
The following databases are supported using the migration utility:
Oracle. Use the JDBC driver for Oracle 10.2 or higher, regardless of what version of the database is used.
MySQL with InnoDB storage (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. It is also recommended that the InnoDB storage engine be used.
Microsoft SQL Server. The MS SqlServer 2.0 driver (sqljdbc4.jar) will not work with AnthillPro. To install the server using Microsoft SQL Server, you will need to use one of the following drivers, depending on which version of Java the AnthillPro server uses:
Java 5. Use either the 1.2 driver or the 2.0 sqljdbc.jar driver.
Java 6. Use the 1.2 driver.
PostgreSQL. Due to a known defect with PostgreSQL 8.4.0, AnthillPro can't be installed with that version. Use version 8.3.7.
See the Installation for migrating server database.
These requirements apply if you want to use 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 AnthillPro to use with a dedicated user.
The database migration should only be run after you have completed an upgrade to the version you are using to migrate. So if you download a new version and want to migrate, you must first do an upgrade.
To migrate the AnthillPro database:
Shut down the server.
Download the anthill3-<version>.zip file.
Expand the zip file using a tool like WinZip. Expanding will create an anthill3-install directory.
Open the anthill3-install directory created in the previous step in Windows.
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 user name.
Database password.
Follow the remainder of step 7 through step 10 of the Windows installation process. See Windows Installation.
To migrate the AnthillPro database, follow the steps below:
Shut down the server.
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. When installing AnthillPro on Solaris,
it is recommended to use korn shell (ksh).
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:
Directory where the AnthillPro server is installed.
Database type AnthillPro should
migrate to (derby, oracle, mysql, etc.).
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 user name.
Database password.