Learn what a database engine is, what exactly are the merits of the InnoDB engine and why it's gaining so much popularity.
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved database failure recovery compared to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of developers that create highly scalable software applications, as it works much more efficiently with enormous amounts of data, while it keeps the server processing load low. Additionally, it locks only a single database row in case anything should be edited, whereas many other engines lock the entire database table and therefore need much more time to accomplish several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest releases of Joomla™ are two instances of widespread PHP-driven software platforms that have switched over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many other hosting companies, it’s included in the standard set of services that we’re offering with our shared hosting packages. In case you wish to use an open-source script-based web application that needs InnoDB particularly, in order to be activated and to work correctly, you won’t have to deal with any obstacles since the database storage engine is available on our in-house developed cloud platform. Regardless of whether you create a brand-new MySQL database and install an application manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. In addition to the excellent database failure recovery that InnoDB offers, we also keep regular database backups, so that we can quickly recover any database in your shared web hosting account.