What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got numerous strengths which have made it the engine of choice for plenty of PHP script-driven applications, including Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, adding large amounts of data will be much faster with InnoDB, as it locks only a single database row to accomplish a particular operation, 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 information is handled. Simply put, importing new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back if some problem occurs in the meantime, which is why the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
Every PHP script-powered software app that needs InnoDB will run impeccably on our leading-edge cloud hosting platform and the storage engine comes with all our shared hosting plans. Every time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s prerequisites without having to edit any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We will store regular backups of your content, so if you unintentionally remove a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your content the way it was only a few hours earlier.