InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has plenty of pluses that have made it the engine of choice for a lot of PHP script-powered web apps, including Joomla and Magento, which have switched to InnoDB permanently. For instance, importing immense amounts of data will be faster with InnoDB, as it locks only a single row to carry out a certain task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Put simply, importing new or modifying existing data will either be fully completed, or will be annulled and the operation will be rolled back if a certain issue occurs during the process, which is why the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
Every open-source script-based web application that requires InnoDB will function impeccably on our advanced cloud platform and the database storage engine is available with all our shared hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without having to modify any setting in your hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We’ll generate daily content backups, so if you accidentally delete a database that’s important to you or you overwrite certain parts of it, we’ll be able to restore your database the way it was just a couple of hours earlier.