InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got many upsides that have made it the engine of choice for numerous open-source script-powered web applications, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a given operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem occurs during the process, which means that the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You will be able to activate any PHP-driven app that requires InnoDB in case you’ve got a shared hosting with our company, as the MySQL storage engine is present on our leading-edge cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install applications which use the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t need to modify anything manually at any time. On top of that, we will also perform regular backups of all the MySQL databases that you have in your shared hosting account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the past 7 days.