When should I consider migrating off of the default H2 database?

+1 vote
asked Jul 3, 2013 by mike-r-7535 (13,830 points)
edited Sep 22, 2015 by gary-t-8719
My H2 database has grown to 5GB.  Should I be planning a migration to MariaDB, MySql, or MSSQL?

1 Answer

+2 votes
Best answer

Generally, we recommend migrating away from the H2 when the database has grown to over 2 to 4 GB, but it depends on the resources of the server.  Although we have seen an H2 database as large as 8+ GB this is not recomended for stability reasons..  If you do not have a database preference, we recommend migrating to MariaDB.

Migrating to another database is fairly simple.  If the server has multiple processors and enough memory, you should be fine installing the database locally on the QIE server.  Here are the steps I recommend taking:

  1. Install your database software
  2. Create a QIE database/schema
  3. Create a QIE user which has permissions to the database
  4. Update the QIE Service Manager to use the new database
  5. Restart QIE
  6. Import the QIE configuration
In migrating to a new database, we only migrate the configurations.  So you have all the configurations, but an empty message history.
It should take less than an hour, with the actual down time of QIE being a few minutes.


answered Jul 3, 2013 by mike-r-7535 (13,830 points)
selected Jul 9, 2013 by mike-r-7535