See what a database engine is, what exactly are the merits of the InnoDB engine and why it is gaining so much popularity.
InnoDB is a popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of strong sides which make it the preferred engine for many PHP-based applications, such as Joomla™ and Magento, which have switched over to InnoDB for good. For example, adding immense data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to perform a specific operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is tackled. In simpler words, importing 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 in the meantime, so the content that remains in the database will not be lost.
InnoDB in Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting service providers, it is part of the default set of features that we’re offering with our web hosting plans. In case you want to use a PHP script-driven software app that needs InnoDB particularly, in order to be activated and to perform correctly, you won’t have any obstacles because the InnoDB storage engine is available on our custom cloud hosting platform. No matter if you create a brand new database and activate an app manually or use our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. Besides the amazing database crash recovery that InnoDB is offering, we also maintain regular database backups, so that we can easily restore any database in your shared account.