InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got plenty of pluses which make it the preferred engine for a lot of PHP-based software applications, such as Joomla and Magento, which have switched over to InnoDB for good. For example, importing large data volumes will be faster with InnoDB, due to the fact that it locks only a single row to perform a given operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. In simpler words, adding new or editing existent data will either be entirely completed, or will be annulled and the procedure will be rolled back if a given problem appears during the process, hence the content that remains in the database will not be damaged.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s an integral part of the default set of features that we’re offering with our website hosting plans. If you want to make use of a PHP-driven web app that requires InnoDB particularly, in order to be installed and to work properly, you won’t need to deal with any problems as the InnoDB storage engine is available on our in-house built cloud hosting platform. Regardless of whether you set up a new database and install an application manually or take advantage of our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application needs InnoDB instead of MyISAM. In addition to the excellent database failure recovery that InnoDB is offering, we also perform daily backups of all databases, so that we can swiftly restore any MySQL database in your shared website hosting account.