InnoDB is a storage engine for MySQL databases, which is used by widespread PHP-driven software apps such as Magento and Joomla v3. It is excellent for scalable apps, as it works exceptionally well when processing large data volumes. Rather than locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same period of time. What’s more, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that prescribe how data imports and updates should be treated. If a certain task hasn’t been fully completed for some reason, the action will be rolled back. In this way, the content in the database will remain undamaged and will not be partially merged with newly added content.

InnoDB in Hosting

Every PHP-driven application that needs InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the MySQL storage engine comes with all our hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected on the basis of the app’s prerequisites without having to edit any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We’ll store regular backups of your content, so in case you unintentionally erase a database that you need or you overwrite specific parts of it, we’ll be able to restore everything the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated servers by default, so as soon as you buy a new semi-dedicated account, you can go on and activate any PHP script-driven app that needs this storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you set up a brand new database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen in accordance with the specific app’s requirements. This will permit you to install and run InnoDB-specific applications without coming across any obstacle and without needing to update any settings in your semi-dedicated account. To take no chances, we will always have a seven-day-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can quickly recover it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to take advantage of any open-source script-based software app that needs this database storage engine without having to set up anything manually. You can choose Hepsia on the VPS configuration page and your brand new server will be ready within one hour, so you can log in and start setting up your websites right away. When you set up a brand new MySQL database and begin the app activation process, our system will pick the engine for that database automatically. Thus, you can run various applications at the same time without having to modify anything on the VPS server. You can set up a WordPress-powered online journal that uses the default MySQL engine – MyISAM, and a Magento-powered Internet shop that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not have to add it manually in case you want to activate open-source PHP scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the setup process – once the script setup wizard accesses the database and starts inserting content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the script. You’ll also be able to use scripts that need MyISAM – the other popular MySQL engine, so you will not have to edit any settings on the server. This will allow you to install various scripts on one single physical server and to use it to its full capabilities.