InnoDB is a storage engine for MySQL databases, which is used by popular open-source script-based software applications like Joomla 3.x and Magento. It is excellent for scalable applications, as it works unbelievably well when handling large data volumes. Rather than locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Also, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be treated. In case a specific operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an essential part of the default set of services that we’re offering with our cloud hosting packages. If you wish to use an open-source script-based application that requires InnoDB specifically, in order to be installed and to perform properly, you will not encounter any difficulties since the MySQL database engine is available on our in-house developed cloud hosting platform. Regardless of whether you set up a brand-new database and install an app manually or make use of our single-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given app requires it instead of MyISAM. In addition to the outstanding database crash recovery offered by InnoDB, we also carry out daily backups of all databases, so we can quickly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can run a PHP script-driven web app that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our advanced cloud platform where the MySQL database storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our one-click application installer tool. In either case, the needed engine will be chosen automatically once the application’s activation begins, so you won’t have to modify anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your MySQL databases if you remove one by mistake, as we generate a couple of backups every day, each of which is saved for 7 days.

InnoDB in VPS Hosting

If you buy a virtual private server from us, you will be able to make use of our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to install any PHP-powered software application that requires InnoDB, as this MySQL database engine is included in the standard software package that will be pre-installed on the Virtual Private Server during its configuration. When you set up a brand new MySQL database using the Control Panel, you’ll just have to start installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the app in question requires it, so you will not have to do anything else in your account. In the same manner, if a certain application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Web Hosting

If you order a new dedicated server, you’ll be able to pick any of the three hosting Control Panels that we are offering – Hepsia and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this MySQL database storage engine manually to be able to run PHP script-based applications that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you require in order to run large-size websites, it’s very possible that you’ll resort to InnoDB. You will be able to use other engines as well, so if a certain app needs MyISAM instead of InnoDB, you will not have to deal with any obstacle while using it. The engine that will be used will be detected automatically the moment the app installation procedure commences, so you will not need to configure any settings manually whatsoever.