Find out more about InnoDB and see why it’s been chosen as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster database failure recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by a lot of web developers that build highly scalable apps, due to the fact that it works much more effectively with large amounts of data, while it keeps the server load low. Also, it locks only a single row in the database if anything should be modified, while lots of other engines lock the entire database table and thus require much more time to fulfill several consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest editions of Joomla™ are two instances of popular open-source script-powered web apps which have switched over to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not available or a paid upgrade with many web hosts, it’s an integral part of the standard set of features that we are offering with our shared website hosting packages. If you’d like to use a script-powered web app that needs InnoDB particularly, in order to be activated and to operate correctly, you will not come across any problems because the InnoDB database storage engine is available on our custom-developed cloud platform. No matter if you set up a brand new MySQL database and activate an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app needs it rather than MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also make regular database backups, so that we can easily restore any database in your shared website hosting account.