InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has numerous pluses which have made it the preferred engine for numerous script-driven apps, among them Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding huge data volumes will be much faster with InnoDB, as it locks only one database row to carry out a specific task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, appending new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a given problem shows up during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Shared Web Hosting
You can use any PHP-driven app that requires InnoDB if you have a shared web hosting with us, as the MySQL database storage engine is available on our leading-edge cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can install apps which use the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you won’t have to update any setting manually at any point. What’s more, we’ll also perform regular backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the past 7 days.