InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got lots of strong sides which have made it the preferred engine for lots of script-based software applications, among them Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing enormous data volumes will be much faster with InnoDB, as it locks only one database row to accomplish a task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is treated. Put simply, appending new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a given problem occurs in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
You can activate any script-powered application that requires InnoDB in case you’ve got a cloud hosting with our company, as the database storage engine is available on our leading-edge cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can run apps which use the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be pre-selected, so you won’t need to edit any setting manually at any point. On top of that, we will also perform regular backups of all the databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.