InnoDB is a storage engine for MySQL databases, which is used by famous script-powered web apps like Joomla v3 and Magento. It’s ideal for scalable apps, as it performs amazingly well when processing huge volumes of data. Rather than 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 a lot more operations for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. In case a specific operation has not been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will remain undamaged and won’t be partially mixed with new content.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many web hosts, it’s included in the default set of services that we are offering with our hosting plans. If you want to make use of a PHP-powered software application that requires InnoDB particularly, in order to be installed and to work correctly, you will not have to deal with any obstacles since the MySQL database storage engine is available on our custom-developed cloud hosting platform. Irrespective of whether you set up a brand-new MySQL database and activate an app manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective application needs it rather than MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also make regular backups of all databases, so that we can quickly recover any database in your shared account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated hosting plans come with InnoDB and you can make the most of all the features of this MySQL database engine with any PHP-driven software app that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be used depends on the particular app’s prerequisites. You won’t have to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we’ll store daily database backups, so if anything goes wrong following some update or if you erase some content unintentionally, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

When you obtain a VPS server from our company, you’ll be able to make use of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to run any PHP-powered software app that needs InnoDB, as this particular MySQL database engine is an integral part of the standard software bundle that will be installed on your server during its setup. When you create a brand new MySQL database through the hosting Control Panel, you’ll simply need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine as long as the application in question requires it, so you won’t have to do anything else in your account. Likewise, if an app requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you will be able to pick any of the three hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to activate this database storage engine manually to be able to run script-powered apps that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you need to manage large-scale sites, it is very possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a specific application requires MyISAM instead of InnoDB, you won’t experience any impediment while using it. The engine that will be used will be recognized automatically the moment the app installation process begins, so you will not need to tweak any settings manually whatsoever.