InnoDB is a database engine for MySQL databases, which is used by well known script-powered software applications like Magento and Joomla v3. It is excellent for scalable apps, because it performs stunningly well when handling large data volumes. 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 handle a lot more tasks for the same length of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and updates should be handled. If a specific task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any open-source script-powered software app that requires the storage engine without any impediments once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, irrespective of whether you take advantage of our single-click installation tool or create the database and install the app manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll perform daily backups of all your databases, so you can rest assured that you’ll never lose any data if you erase a database accidentally or you overwrite some important info – you’ll simply need to notify us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting services support InnoDB and you can take full advantage of all the features offered by this database engine with any open-source script-driven software application that requires it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the particular app. You won’t have to do anything manually to activate InnoDB, as 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 will perform regular backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you erase some data by mistake, we’ll be able to get your database back to the way it was on any of the past seven days.

InnoDB in VPS Hosting

When you buy a virtual private server from our company, you will be able to take advantage of our in-house built Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to activate any script-driven software application which requires InnoDB, as this database storage engine is an essential part of the standard software bundle that will be pre-installed on your server during its configuration. When you set up a brand new MySQL database via the hosting Control Panel, you simply need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question needs it, so you will not need to do anything else in your VPS account. Equivalently, if an application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Web Hosting

All dedicated web hosting ordered with our in-house built Hepsia hosting Control Panel come with a software package that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not have to add it manually in case you want to activate scripts that require it. All it takes to install such a script is to set up a new MySQL database and to start the installation – as soon as the script configuration wizard accesses the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that need the other popular MySQL engine – MyISAM, so you will not have to configure any settings on the dedicated server. This will enable you to install various scripts on one single physical server and to use the latter to its full capacity.