Find out more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by a lot of web developers that run highly scalable apps, as it works better with huge data volumes, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be modified, while lots of other engines lock the entire database table and therefore need more time to carry out several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest editions of Joomla™ are two examples of popular PHP-driven software applications that have shifted over to InnoDB.
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other web hosting providers, it’s included in the standard set of services that we are offering with our cloud hosting plans. If you would like to make use of an open-source script-powered app that needs InnoDB particularly, in order to be activated and to work correctly, you won’t experience any difficulties since the InnoDB database storage engine is available on our in-house developed cloud website hosting platform. No matter if you create a brand new database and install an application manually or take advantage of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the app needs InnoDB rather than MyISAM. In addition to the exceptional database failure recovery that InnoDB is offering, we also perform regular backups of all databases, so we can quickly recover any MySQL database in your shared hosting account.