InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a better overall performance and a faster database failure recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is used by many programmers that create highly scalable software applications, due to the fact that it works much more efficiently with immense volumes of data, while it keeps the server load low. Also, it uses row-level locking if anything should be updated, whereas many other engines lock the entire table and hence need more time to accomplish several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to prevent scrambling or data loss. Magento and the newest Joomla editions are two instances of popular open-source script-based software applications that have moved to InnoDB.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with other web hosts, it is included in the default set of services that we offer with our cloud website hosting plans. In case you wish to make use of an open-source script-powered web app that needs InnoDB specifically, in order to be activated and to perform correctly, you will not have to deal with any problems as the database engine is available on our custom-developed cloud web hosting platform. Regardless of whether you create a new database and install an application manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB instead of MyISAM. Besides the excellent database crash recovery that InnoDB offers, we also store regular backups of all databases, so we can quickly restore any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated servers by default, so once you purchase a new semi-dedicated account, you can go ahead and activate any PHP-based software application that requires this particular database storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a brand-new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be set depending on the prerequisites of the particular application. This will permit you to activate and manage InnoDB-specific applications without having any difficulty and without updating any settings in your account. To be on the safe side, we’ll always have a 1-week-old backup of all your databases, so if you remove or change any content accidentally, we can quickly retrieve it.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to select any of the 3 Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually in order to be able to use open-source script-based software applications that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require in order to run large-scale websites, it is very possible that you’ll use InnoDB. You’ll be able to use other engines too, so in case a specific application needs MyISAM rather than InnoDB, you won’t run into any difficulty while running it. The engine that will be used will be automatically recognized the moment the app installation process begins, so you will not have to fine-tune any settings manually whatsoever.