InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has numerous advantages that make it the preferred engine for lots of open-source script-powered applications, such as Joomla and Magento, which have switched over to InnoDB for good. For instance, importing enormous amounts of data will be faster with InnoDB, since it locks only one database row to complete a specific operation, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. To put it simply, importing new or updating existent data will either be entirely completed, or will be annulled and the operation will be rolled back if a certain problem occurs in the meantime, which is why the content that remains in the database will not be damaged.
InnoDB in Cloud Hosting
You can run any script-powered web application that needs InnoDB in case you have a cloud plan with us, as the MySQL database storage engine is present on our advanced cloud website hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can activate apps which use the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you will not need to update any setting manually at any point. What’s more, we will also generate daily backups of all the MySQL databases that you’ve got in your shared account, so in case you delete or overwrite something, we can swiftly restore it the way it was on any of the past seven days.