InnoDB is a storage engine for MySQL databases, which is used by well known PHP script-driven software applications such as Joomla 3 and Magento. It’s perfect for scalable apps, as it performs stunningly well when managing huge amounts of data. Instead of locking the whole database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can handle much more operations for the same period of time. Plus, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. In case a specific task hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved safe and sound and won’t be partially merged with newly appended content.

InnoDB in Shared Web Hosting

Every script-based software application that requires InnoDB will function impeccably on our advanced cloud web hosting platform and the MySQL database engine comes with all our shared web hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without the need to configure any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to get the most out of its full potential. We’ll keep daily backups of your content, so if you accidentally remove a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server packages and you start installing a script-based application either manually or using our single-click application installer, the storage engine for the MySQL database will be set automatically on the basis of the requirements of the specific application. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without any manual action needed on your end at any time. To prevent any risk of losing data if you update an app or if you erase a database unintentionally, we’ll generate backups of all your databases each day, so if something happens, we can recover your data.

InnoDB in VPS Web Hosting

All Linux VPS web hosting services that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to use any script-driven web application that requires the MySQL database storage engine without having to activate anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be ready within one hour, so you can log in and begin creating your Internet sites straight away. Once you set up a brand-new MySQL database and begin the app activation process, our system will choose the engine for that database automatically. Thus, you can manage different applications at the same time without having to configure anything on the Virtual Private Server. You can set up a WordPress-driven weblog that makes use of MyISAM – the default MySQL engine, and a Magento-based e-commerce site that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not have to install it manually if you need to use open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the installation – once the installer wizard acquires access to the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to activate scripts that need the other popular MySQL engine – MyISAM, so you will not have to configure any settings on the server. This will allow you to run a variety of scripts on one single machine and to use it to its maximum capabilities.