Read more about InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved database crash recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is preferred by lots of devs that run highly scalable web apps, due to the fact that it works more effectively with large volumes of data, while it keeps the server processing load low. Moreover, it uses row-level locking in case anything should be updated, while many other engines lock the entire table and hence need more time to execute several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest Joomla™ releases are two examples of famous open-source script-driven web apps which have moved to InnoDB.
InnoDB in Cloud Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it’s an essential part of the default set of features that we’re offering with our cloud web hosting packages. If you’d like to use a PHP script-powered app that needs InnoDB specifically, in order to be activated and to function properly, you will not come across any difficulties as the MySQL database storage engine is available on our in-house developed cloud Internet hosting platform. No matter if you set up a brand-new database and install an app manually or make use of our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it instead of MyISAM. Besides the exceptional database failure recovery that InnoDB offers, we also make daily backups of all databases, so we can swiftly recover any MySQL database in your shared hosting account.