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 DBMS. It is an alternative to the default MyISAM engine and it has lots of strong sides that have made it the preferred engine for a lot of open-source script-powered software apps, such as Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, adding enormous volumes of data will be much faster with InnoDB, because it locks only one database row to accomplish a specific operation, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. Put simply, appending new or editing existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if any issue appears in the meantime, which means that the content that remains in the database won’t be lost.
InnoDB in Cloud Hosting
Any PHP-driven web application that requires InnoDB will run impeccably on our advanced cloud hosting platform and the MySQL database storage engine comes with all our cloud hosting
plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s requirements without the need to change any setting in your shared account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We’ll carry out regular content backups, so if you unintentionally remove a MySQL database that you need or you overwrite a certain part of it, we will be able to restore everything the way it was only several hours earlier.