InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP script-based apps such as Magento and Joomla™ 3.x. It’s perfect for scalable apps, as it performs incredibly well when processing large volumes of data. Rather than locking the entire table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. What’s more, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be handled. In case a certain task has not been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will remain undamaged and will not be partially merged with newly imported content.

InnoDB in Website Hosting

You’ll be able to install any PHP-driven software application that needs InnoDB if you’ve got a website hosting service with our company, as the MySQL storage engine is present on our advanced cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can run applications which require the MyISAM engine without any difficulty as well and, again, the engine will be selected automatically, so you will not have to modify anything manually at any time. Furthermore, we’ll also perform regular backups of all the MySQL databases that you’ve got in the shared web hosting account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our semi-dedicated services by default, so as soon as you get a new semi-dedicated account, you can move on and activate any script-driven app that requires this database engine. A few engines are installed on our cloud website hosting platform, so when you create a new database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked in accordance with the concrete app’s requirements. This will permit you to activate and manage InnoDB-specific applications without any obstacle and without having to update any settings in your account. To be on the safe side, we will always keep a one-week-old backup of all your databases, so if you remove or alter any content by accident, we can easily restore it.

InnoDB in VPS

If you choose a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the standard software package that will be installed on your VPS server before we hand it over to you. You won’t have to set up anything manually and you’ll be able to enable and manage any PHP script-powered software app that needs InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order process itself. A few engines are available, so whenever you set up a MySQL database using the Hepsia hosting Control Panel, a specific engine will be activated once the app installation process begins and our system will automatically recognize which engine is required by the app in question. In case you need to use MyISAM, for example, you will not have to do anything different from installing the app of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Hosting

If you buy a new dedicated server, you will be able to pick one of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to add this storage engine manually so as to be able to manage open-source script-powered web apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you require in order to manage very large websites, it is very likely that you’ll resort to InnoDB. You will be able to use other engines too, so if a specific app requires MyISAM rather than InnoDB, you won’t encounter any problem while using it. The engine that will be used will be automatically recognized as soon as the app installation process starts, so you will not have to edit any settings manually at any moment.