InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster crash recovery compared with the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by plenty of programmers that create scalable web apps, since it works much better with huge data volumes, while it keeps the server processing load low. In addition, it locks only a single row in the database in case anything should be edited, while many other engines lock the entire table and thus require more time to fulfill multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ versions are two instances of widespread PHP script-driven software apps which have switched to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it’s part of the default set of features that we offer with our shared hosting plans. In case you’d like to make use of an open-source script-based web application that requires InnoDB particularly, in order to be activated and to perform correctly, you won’t encounter any problems because the storage engine is available on our custom-developed cloud platform. Regardless of whether you set up a new database and activate an app manually or take advantage of our one-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the given application needs it rather than MyISAM. In addition to the amazing crash recovery that InnoDB is offering, we also make daily database backups, so that we can swiftly restore any MySQL database in your shared web hosting account.