InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got lots of pluses that have made it the engine of choice for a lot of open-source script-based software applications, such as Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, because it locks only one database row to complete a certain operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is tackled. Simply put, appending new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a certain issue shows up during the process, which is why the content that remains in the database will not be lost.
InnoDB in Shared Website Hosting
Any open-source script-powered software app that requires InnoDB will run impeccably on our leading-edge cloud platform and the storage engine is available with all our shared website hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected on the basis of the app’s specifications without the need to edit any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to get the most out of its full capacity. We’ll make daily backups of your content, so in case you unintentionally delete a MySQL database that you need or you overwrite certain parts of it, we will be able to restore the database the way it was only a few hours earlier.