What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has numerous upsides which have made it the preferred engine for many PHP-driven applications, including Magento and Joomla™, which have moved to InnoDB permanently. For example, adding enormous data volumes will be much faster with InnoDB, as it locks only one row to complete a particular operation, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, 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 certain problem appears in the meantime, so the content that remains in the database will not be lost.
InnoDB in Shared Website Hosting
You will be able to use any PHP script-based application that needs InnoDB if you have a shared website hosting
with our company, as the database engine is present on our leading-edge cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install applications which need the MyISAM engine without having any problem as well and, once again, the engine will be selected automatically, so you won’t need to update any setting manually at any time. What’s more, we will also create daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you delete or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.