Starting off with a Viaduct Hobby-level database is a great way to get your application up and running. However, when you enter production we strongly recommend upgrading your MySQL or PostgreSQL database to use our enterprise-level databases. Here's just a few reasons to upgrade.

  • Regular backups and replication of data store to hot spare in case of hardware failure at the storage node.

  • Immediate self-healing in the case of hardware failure or maintenance on our application hosts.

  • Superior speed with guaranteed memory for each database ensuring your data can be accessed quickly.

How to upgrade

Upgrading is simple. Just follow these simple steps and you'll be using a production DB in no time.

  1. Ensure your application's main database is set to your current hobby database and that your configuration uses the VDT_DB_XXX environment variables.

  2. Create a production database using the same engine which your hobby database uses.

  3. Take a full backup of your shared database. You can take an export though the web interface or simply use the mysqldump or pgdump commands in your application's console.

  4. Put your application into maintenance mode.

  5. Migrate your data from the hobby DB to the new production database. To do this, just go to your application's databases page and select Migrate next to the hobby DB you wish to move. When prompted, choose your new production database and check the "Promote?" checkbox.

Screenshot

  1. Once the migration has completed, re-deploy your application.

  2. When deployed successfully, you can disable maintenance mode and remove your old hobby DB at your conveinence.

That's all there is to it.

If you've got any questions, please don't hesitate to get in touch and we'll be happy to assist.

Tell us how you feel about this post?