InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of web developers that write scalable web apps, as it works better with large data volumes, while it keeps the server load low. In addition, it it locks only one row in the database in case any information should be updated, while many other engines lock the entire table and thus need more time to fulfill multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to prevent confusion or data loss. Magento and the latest Joomla editions are two instances of popular open-source script-driven web applications which have shifted over to InnoDB.

InnoDB in Cloud Hosting

Any PHP script-driven software application that requires InnoDB will function impeccably on our innovative cloud website hosting platform and the MySQL database engine is offered with all our cloud hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected on the basis of the app’s prerequisites without the need to update any setting in your hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll generate regular backups of your content, so if you unintentionally erase a database that is important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the Control Panel offered with each of our semi-dedicated server packages and you begin installing a script-driven application either manually or using our 1-click app installer, the storage engine for the database will be selected automatically on the basis of the prerequisites of the app in question. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that needs it without any manual action required on your end at any moment. To avoid any risk of losing data if you update an application or if you erase a database unintentionally, we’ll carry out a backup of all your databases each and every day, so if anything happens, we can recover your data.