InnoDB
What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it offers a much better overall performance and a faster crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of web developers that build scalable web apps, due to the fact that it works much more efficiently with huge data volumes, while it keeps the server processing load low. Also, it uses row-level locking in case any information should be updated, whereas many other engines lock the entire database table and hence need much more time to fulfill several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest Joomla™ editions are two examples of famous open-source script-driven software applications that have moved to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with many web hosts, it’s an essential part of the standard set of services that we offer with our shared website hosting plans. In case you’d like to make use of a PHP-powered web application that requires InnoDB in particular, in order to be installed and to operate properly, you won’t have to deal with any obstacles as the MySQL storage engine is available on our custom-developed cloud web hosting platform. Regardless of whether you set up a brand-new MySQL database and install an application manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the outstanding crash recovery offered by InnoDB, we also keep daily backups of all databases, so we can swiftly restore any database in your shared account.