InnoDB is a database storage engine for MySQL databases, which is used by famous PHP-powered web apps such as Magento and Joomla v3. It is ideal for scalable apps, since it performs very well when processing large data volumes. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same period of time. What’s more, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and updates should be treated. If a certain task hasn’t been entirely 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 entered content.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting plans by default, not upon request or as a paid upgrade, so you can install and run any script-driven web app that needs the database storage engine without any obstacles once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, regardless of whether you use our one-click installation tool or create the database and activate the app manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will store daily backups of all your databases, so you can rest assured that you will never lose any content if you delete a database accidentally or you overwrite some vital info – you simply have to get in touch with us and we will restore your database the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you can make the most of all the features of this database engine with any PHP-powered web app that needs it. It’s among the engines that we have on our cloud hosting platform, so the one that will be selected depends on the particular app’s requirements. You won’t have to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we will create daily MySQL database backups, so if anything goes wrong following some update or if you remove some content accidentally, we’ll be able to restore the database the way it was on any of the past seven days.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the signup process for your new VPS plans , InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you will not have to do anything if you decide to make use of open-source script-driven software apps that require this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and begin the app installation process manually or using our one-click installation tool. The system will detect the engine that the particular app requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can insert its data into that database. In this way, you can install apps with different prerequisites about the MySQL engine without the need to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s an essential part of the default software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is up and running, you will be able to log in and to activate any open-source script-based app that needs this particular MySQL database engine. When you create a new database through the Control Panel, there won’t be any active engine till you begin installing an app. As soon as the app setup wizard begins importing information into the newly created database, the engine will be picked automatically depending on the given app’s prerequisites, so you can use both MyISAM and InnoDB without selecting either one of them specifically at any moment. Therefore, you can make use of a huge selection of apps for your sites.