InnoDB is a database engine for MySQL databases, which is used by well known PHP-driven software applications like Magento and Joomla v3. It’s perfect for scalable applications, since it performs stunningly well when managing immense amounts of data. Rather than locking the entire table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same length of time. What’s more, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and updates should be treated. If a certain operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be kept intact and will not be partially merged with newly entered content.

InnoDB in Cloud Hosting

Any PHP script-powered application that requires InnoDB will run impeccably on our advanced cloud platform and the MySQL storage engine is offered with all our cloud hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to modify any setting in your account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll perform daily content backups, so in case you unintentionally remove a database that is important to you or you overwrite a certain part of it, we will be able to restore the database the way it was just several hours ago.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans support InnoDB and you will be able to get the most out of all the features of this MySQL database engine with any PHP script-based software app that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the given application. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To be on the safe side, we will perform regular backups of all your MySQL databases, so if anything goes wrong following an update or if you remove some content by mistake, we’ll be able to get your database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is picked during the registration process for a new VPS plans , InnoDB will be activated on the Virtual Private Server along with other needed pieces of software, so you won’t need to do anything if you decide to run open-source script-driven web applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a new database and start the app installation process manually or through our 1-click installer tool. The system will detect which engine the particular app needs and will set it for the specific database, so the installation process will proceed impeccably and the application can enter its data into that database. Thus, you can manage apps with various prerequisites in regard to the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can choose on the order form when you buy a dedicated server from us. Since this is the most powerful kind of hosting, it’s very likely that you’ll run highly popular websites that will draw a lot of visitors, and since InnoDB is among the best options for such Internet sites, we’ll activate it along with all the other software applications that are offered with a Hepsia-managed dedicated server. If you set up a brand-new database in your dedicated account, there won’t be any active database engine till you begin installing a script, whether manually via your Internet browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The necessary engine will be detected automatically and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without having to cope with any obstacle.