InnoDB is a database engine for MySQL databases, which is used by widely used script-powered web applications such as Magento and Joomla 3. It’s perfect for scalable applications, because it works astonishingly well when managing large amounts of data. Instead of locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same length of time. Plus, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that determine how data imports and modifications should be treated. If a certain operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and won’t be partially merged with new content.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting providers, it’s included in the default set of services that we are offering with our web hosting plans. If you would like to use a PHP script-driven app that needs InnoDB in particular, in order to be activated and to operate correctly, you won’t come across any impediments because the InnoDB storage engine is available on our in-house developed cloud web hosting platform. No matter if you set up a brand new database and activate an app manually or use our one-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it instead of MyISAM. In addition to the remarkable crash recovery that InnoDB is offering, we also carry out daily database backups, so we can quickly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting support InnoDB and you’ll be able to take advantage of all the features offered by this database engine with any script-driven application that requires it. It is among the engines that we have on our cloud hosting platform, so the one that will be used depends on the particular app’s requirements. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To be on the safe side, we’ll keep daily MySQL database backups, so if anything goes wrong after an update or if you delete some content by mistake, we will be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Hosting

If you buy a virtual private server from us, you’ll be able to take advantage of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to activate any open-source script-driven application which needs InnoDB, as the storage engine is part of the standard software package that will be pre-installed on your Virtual Private Server during its creation. When you set up a brand new database using the hosting Control Panel, you’ll just need to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine if the application in question requires it, so you will not need to do anything else in your account. Analogously, if an application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Web Hosting

When you order a new dedicated server, you’ll be able to select any of the three Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this storage engine manually to be able to run PHP script-driven software applications that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the resources that you require to manage large-scale Internet sites, it’s quite likely that you will resort to InnoDB. You will be able to use other engines too, so in case a particular application needs MyISAM rather than InnoDB, you will not need to deal with any impediment while using it. The engine that will be used will be automatically detected once the app installation starts, so you will not have to update any settings manually at any point.