InnoDB is a database engine for MySQL databases, which is used by widely used script-powered web applications such as Joomla 3.x and Magento. It’s excellent for scalable applications, as it works incredibly well when handling large data volumes. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same length of time. Also, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that indicate how data imports and updates should be handled. In case a given operation has not been fully completed for some reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and will not be partially merged with newly inserted content.

InnoDB in Shared Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosts, it is an integral part of the default set of services that we are offering with our shared web hosting packages. In case you’d like to make use of an open-source script-driven app that needs InnoDB in particular, in order to be activated and to work correctly, you will not have any impediments because the MySQL database storage engine is available on our in-house developed cloud web hosting platform. Regardless of whether you set up a brand-new MySQL database and install an application manually or make use of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs it instead of MyISAM. In addition to the excellent crash recovery that InnoDB offers, we also maintain regular database backups, so that we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated packages include InnoDB and you’ll be able to use all the features of this storage engine with any script-driven web application that requires it. It’s one of the engines that are available on our cloud website hosting platform, so the one that will be selected depends on the requirements of the given app. You will not have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To avoid any risk, we’ll make regular backups of all your databases, so if something goes wrong following an update or if you remove some content accidentally, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers Hosting

If you get a new dedicated server, you will be able to pick any of the 3 Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this database storage engine manually so as to be able to run PHP-based applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require to manage large-scale Internet sites, it’s rather likely that you’ll use InnoDB. You’ll be able to use other engines too, so if a specific app requires MyISAM rather than InnoDB, you will not encounter any complication while managing it. The engine that will be used will be recognized automatically once the app installation procedure commences, so you won’t have to tweak any setting manually at any time.