InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and an improved database crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by numerous programmers that write highly scalable applications, since it works much more efficiently with large data volumes, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case anything should be edited, whereas lots of other engines lock the entire table and thus require much more time to execute several successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest versions of Joomla are two examples of widely used PHP-driven software platforms which have switched to InnoDB.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many other web hosts, it is included in the default set of services that we’re offering with our cloud website hosting packages. If you wish to use a script-driven app that requires InnoDB specifically, in order to be activated and to work correctly, you will not face any obstacles as the database engine is available on our custom cloud hosting platform. Regardless of whether you set up a brand-new MySQL database and install an app manually or take advantage of our single-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the application needs it instead of MyISAM. Besides the amazing database failure recovery offered by InnoDB, we also keep regular database backups, so that we can easily restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans include InnoDB and you can use all the options offered by this MySQL database storage engine with any open-source script-driven web application that needs it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be picked depends on the requirements of the specific application. You won’t have to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll carry out regular MySQL database backups, so if anything goes wrong following an update or if you erase some data accidentally, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is chosen during the registration process for your new VPS hosting plans , InnoDB will be installed on the VPS server together with other needed software, so you won’t have to do anything if you decide to use script-based web apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand new database and start the app installation process manually or using our one-click installer. The system will automatically detect the engine that the app in question needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the app can enter its content into that database. Thus, you can make use of applications with various prerequisites about the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to select any of the 3 hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to install this database storage engine manually so as to be able to run PHP-based software applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the resources that you need in order to manage very large websites, it’s pretty possible that you will resort to InnoDB. You’ll be able to use other engines as well, so if a specific app needs MyISAM instead of InnoDB, you won’t run into any problem while running it. The engine that will be used will be automatically recognized once the app installation begins, so you will not need to alter any settings manually at any time.