InnoDB is a database storage engine for MySQL databases, which is used by popular PHP script-powered apps such as Magento and Joomla™ 3. It’s ideal for scalable applications, as it works exceptionally well when handling enormous data volumes. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same period of time. In addition, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and updates should be treated. In case a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will stay undamaged and won’t be partially mixed with newly added content.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting by default, not upon request or as a paid upgrade, so you can install and manage any script-powered web application that needs the MySQL database engine without having to deal with any difficulty as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, no matter if you use our single-click installation tool or create the database and install the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will perform daily MySQL database backups, so you can be sure that you’ll never lose any content if you delete a database by accident or you overwrite some vital information – you just have to inform us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our Linux semi-dedicated hosting service by default, so once you order a new account, you can move on and install any PHP script-driven app that needs the MySQL database engine. A number of engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen depending on the requirements of the respective application. This will allow you to install and manage InnoDB-specific applications without having any complication and without needing to edit any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can swiftly retrieve it.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an integral part of the standard software pack that will be installed on your Virtual Private Server before we hand it over to you. You will not have to activate anything manually and you will be able to install and run any open-source script-driven software app that needs InnoDB as soon as your VPS server is set up, which takes no more than 1 hour after the order submission procedure itself. A couple of engines are offered, so every time you create a MySQL database via the Hepsia Control Panel, a particular engine will be picked once the app installation process commences and our system will detect the engine that is required by the app in question. If you have to use MyISAM, for example, you won’t need to do anything different from installing the preferred application, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to pick one of the three Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to add this MySQL database engine manually in order to be able to use PHP-powered apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you need in order to manage large-scale sites, it is very likely that you will resort to InnoDB. You will be able to use other engines as well, so if a given application requires MyISAM instead of InnoDB, you won’t run into any problem while managing it. The engine that will be used will be automatically recognized when the app installation process starts, so you won’t need to configure any setting manually whatsoever.