InnoDB is a very popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got a number of pluses that have made it the preferred engine for lots of script-powered web applications, including Joomla and Magento, which have moved to InnoDB permanently. For instance, importing huge volumes of data will be faster with InnoDB, since it locks only one row to execute a given task, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, importing new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back in case a given problem shows up during the process, thus the content that remains in the database won’t be lost.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it is included in the standard set of features that we offer with our shared website hosting packages. In case you want to make use of a PHP script-powered software app that needs InnoDB in particular, in order to be activated and to perform correctly, you won’t have any impediments as the database engine is available on our custom-built cloud hosting platform. No matter if you set up a brand-new database and install an app manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it instead of MyISAM. Besides the remarkable crash recovery that InnoDB is offering, we also generate daily backups of all databases, so that we can quickly recover any database in your shared website hosting account.