InnoDB is a database storage engine for MySQL databases, which is used by widespread open-source script-based apps like Magento and Joomla 3.x. It’s perfect for scalable apps, as it performs exceptionally well when processing huge volumes of data. Rather than locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. Moreover, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be handled. If a particular task has not been fully completed for any reason, the action will be rolled back. In this way, the content in the database will be preserved safe and sound and will not be partially merged with new content.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting packages by default, not as a paid upgrade or upon request, so you will be able to install and manage any script-based app which needs the MySQL storage engine without having to deal with any difficulty once you order your account. InnoDB will be selected automatically as the default engine for a particular database during the app activation, no matter if you take advantage of our 1-click installation tool or create the MySQL database and install the app manually, as long as the app requires it instead of the more famous MyISAM engine. We will perform regular backups of all your databases, so you can be sure that you won’t ever lose any content if you erase a database accidentally or you overwrite some vital information – you simply need to contact us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages include InnoDB and you’ll be able to make use of all the options offered by this database engine with any open-source script-powered software application that requires it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be picked depends on the requirements of the app in question. You will not need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll maintain regular database backups, so if anything goes wrong following an update or if you erase some data accidentally, we will be able to get your database back to the way it was on any of the past seven days.

InnoDB in VPS

When you obtain a virtual private server from us, you will be able to take full advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to run any PHP-based application that needs InnoDB, as this database storage engine is part of the software bundle that will be pre-installed on your Virtual Private Server during its configuration. When you set up a new MySQL database using the hosting Control Panel, you will simply need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine if the app in question needs it, so you won’t have to do anything else in your account. In the same manner, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Hosting

When you get a new dedicated server, you will be able to pick any of the three Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to activate this MySQL database engine manually so as to be able to manage script-powered applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need to manage large-scale sites, it’s very possible that you will use InnoDB. You’ll be able to use other engines too, so if a specific application needs MyISAM rather than InnoDB, you will not come across any impediment while managing it. The engine that will be used will be automatically detected the moment the app installation procedure begins, so you will not have to update any settings manually whatsoever.