InnoDB is a very popular storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has got many strong sides that make it the preferred engine for plenty of open-source script-powered apps, among them Joomla™ and Magento, which have switched to InnoDB permanently. For example, importing large amounts of data will be much faster with InnoDB, because it locks only a single database row to execute a task, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, importing new or modifying existent data will either be fully completed, or will be aborted and the operation will be rolled back in case a given problem appears in the meantime, which is why the content that remains in the database will not be damaged.
InnoDB in Shared Website Hosting
You’ll be able to install any open-source script-powered web app that needs InnoDB if you’ve got a Linux shared website hosting package with our company, as the storage engine is present on our avant-garde cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is required. You can run apps which need the MyISAM engine without encountering any obstacle as well and, again, the engine will be selected automatically, so you will not have to edit any setting manually at any time. What’s more, we will also perform daily backups of all the MySQL databases that you have in your account, so if you delete or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.