What?s InnoDB? Why has it been selected as the standard MySQL storage 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 to the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by numerous programmers that create scalable web applications, as it works much more efficiently with immense volumes of data, while it keeps the server load at a minimum. Furthermore, it locks only a single database row if any info should be modified, while lots of other engines lock the entire database table and therefore need much more time to execute multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification cannot be completed for whatever reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest Joomla™ editions are two examples of widespread PHP script-driven applications which have switched over to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it is an integral part of the standard set of services offered with our shared website hosting packages. In case you want to use an open-source script-driven app that needs InnoDB in particular, in order to be activated and to perform correctly, you will not experience any impediments as the storage engine is available on our custom-developed cloud hosting platform. No matter if you set up a new database and install an application manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB rather than MyISAM. In addition to the exceptional crash recovery that InnoDB offers, we also keep daily database backups, so we can quickly recover any database in your shared hosting account.