What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of advantages that have made it the engine of choice for numerous PHP script-powered web apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For instance, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a particular task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. In simpler words, appending new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case any issue occurs during the process, hence the content that remains in the database will not be lost.
InnoDB in Shared Web Hosting
While InnoDB is either not available or a paid upgrade with many web hosts, it is an integral part of the default set of features that we offer with our shared web hosting plans. If you wish to use an open-source script-based software application that requires InnoDB particularly, in order to be activated and to perform properly, you will not encounter any obstacles because the database storage engine is available on our custom-developed cloud hosting platform. No matter if you set up a brand-new MySQL database and activate an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires InnoDB instead of MyISAM. Besides the outstanding database crash recovery offered by InnoDB, we also make regular database backups, so that we can quickly restore any database in your shared website hosting account.