InnoDB is a popular storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has plenty of strong sides which make it the engine of choice for numerous open-source script-driven software apps, including Joomla and Magento, which have moved to InnoDB for good. For instance, importing huge amounts of data will be much faster with InnoDB, as it locks only one database row to accomplish a certain task, not the entire 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 info is treated. In simpler words, adding new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case any issue shows up in the meantime, hence the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many hosting providers, it is an integral part of the standard set of services that we offer with our shared hosting plans. If you want to make use of an open-source script-powered software application that needs InnoDB specifically, in order to be installed and to perform correctly, you will not have to deal with any obstacles as the InnoDB database storage engine is available on our in-house built cloud web hosting platform. No matter if you set up a brand new MySQL database and activate an app manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it rather than MyISAM. In addition to the incredible crash recovery that InnoDB is offering, we also store daily database backups, so that we can swiftly recover any database in your shared hosting account.