What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of pluses that make it the engine of choice for plenty of script-based apps, including Magento and Joomla™, which have switched over to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, as it locks only one row to accomplish a particular task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. To put it simply, appending new or modifying existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case some issue occurs in the meantime, which means that the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
Any script-based application that requires InnoDB will run impeccably on our leading-edge cloud hosting platform and the storage engine is offered with all our shared hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without the need to update any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will store daily content backups, so in case you unintentionally erase a MySQL database that is important to you or you overwrite a specific part of it, we will be able to restore the database the way it was only a couple of hours earlier.