InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it offers a significantly better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by lots of web developers that build scalable software apps, due to the fact that it works more effectively with immense amounts of data, while it keeps the server load low. Moreover, it locks only a single row in the database in case anything should be edited, while lots of other engines lock the entire database table and therefore require much more time to carry out several successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest releases of Joomla are two instances of widespread script-driven software apps which have shifted over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it’s included in the standard set of services offered with our cloud hosting plans. If you’d like to use an open-source script-based application that needs InnoDB in particular, in order to be installed and to function correctly, you will not experience any impediments as the storage engine is available on our custom cloud website hosting platform. Irrespective of whether you set up a brand-new database and activate an application manually or make use of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular application needs it instead of MyISAM. Besides the remarkable database crash recovery offered by InnoDB, we also maintain regular database backups, so that we can easily restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database from the Control Panel included with all our semi-dedicated server packages and you start installing a script-powered app either manually or using our 1-click app installer, the database storage engine will be set automatically on the basis of the particular app’s prerequisites. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any point. To avoid any risk of losing information if you update an app or if you remove a database by accident, we’ll carry out backups of all your MySQL databases every day, so if anything goes wrong, we can retrieve your content.

InnoDB in Dedicated Web Hosting

If you order a new dedicated server, you will be able to select one of the 3 hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to enable this MySQL database storage engine manually to be able to use PHP-driven web apps that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you need in order to manage very large websites, it is quite likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a certain application needs MyISAM instead of InnoDB, you will not need to deal with any difficulty while using it. The engine that will be used will be recognized automatically the moment the app installation procedure begins, so you won’t need to change any settings manually at any point.