InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a better overall performance and a faster crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by many developers that build scalable applications, because it works more effectively with huge volumes of data, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any info should be modified, while lots of other engines lock the entire table and thus require more time to fulfill multiple successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla editions are two instances of widespread PHP script-driven applications that have shifted over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it is included in the default set of features offered with our shared hosting packages. In case you’d like to use a PHP-based web app that requires InnoDB specifically, in order to be installed and to function correctly, you will not need to deal with any difficulties as the InnoDB database storage engine is available on our in-house built cloud platform. Irrespective of whether you create a new database and install an app manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also make regular backups of all databases, so that we can easily restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

You can use an open-source script-driven web application that requires InnoDB with all of our semi-dedicated server plans, as all the accounts are created on our avant-garde cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our 1-click application installer. Either way, the required engine will be selected automatically once the activation of the application begins, so you won’t have to change anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to recover any of your databases if you delete one by mistake, as we create several MySQL database backups every day, each of which is preserved for 1 week.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to pick one of the three hosting Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to enable this MySQL database engine manually so as to be able to manage script-powered software applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you require to manage very large Internet sites, it is quite possible that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a certain app requires MyISAM rather than InnoDB, you will not have any difficulty while managing it. The engine that will be used will be detected automatically once the app installation procedure starts, so you won’t need to tweak any setting manually whatsoever.