InnoDB is a very popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has got lots of advantages that have made it the preferred engine for a lot of PHP-based web apps, among them Joomla and Magento, which have shifted over to InnoDB permanently. For instance, importing large volumes of data will be much faster with InnoDB, since it locks only a single row to complete a certain 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 tackled. To put it simply, appending new or updating existing data will either be entirely completed, or will be aborted and the procedure will be rolled back in case a given issue appears in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting companies, it’s an essential part of the default set of services that we’re offering with our hosting packages. In case you want to use an open-source script-driven web app that requires InnoDB particularly, in order to be installed and to operate properly, you won’t encounter any problems since the InnoDB database engine is available on our in-house developed cloud Internet hosting platform. Irrespective of whether you set up a new MySQL database and activate an app manually or use our 1-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the remarkable database failure recovery that InnoDB is offering, we also maintain daily backups of all databases, so we can easily recover any MySQL database in your shared website hosting account.