InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-based web apps like Magento and Joomla™ 3. It’s perfect for scalable applications, because it performs amazingly well when processing enormous volumes of data. Rather than 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 process much more tasks for the same period of time. In addition, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. If a given task has not been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be retained intact and won’t be partially merged with newly appended content.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it is an integral part of the standard set of features that we are offering with our website hosting packages. In case you want to use a PHP script-powered app that requires InnoDB particularly, in order to be installed and to work properly, you won’t have to deal with any obstacles as the InnoDB database storage engine is available on our custom cloud website hosting platform. No matter if you set up a brand-new database and activate an app manually or use our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the specific application needs it instead of MyISAM. In addition to the exceptional crash recovery that InnoDB offers, we also keep regular database backups, so that we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database from the Control Panel offered with all our semi-dedicated server accounts and you start installing a PHP-driven software app either manually or using our one-click application installer, the MySQL database storage engine will be selected automatically based on the requirements of the particular app. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any moment. To prevent any risk of losing info if you update an app or if you erase a database unintentionally, we will carry out backups of all your MySQL databases every day, so if anything goes wrong, we can restore your data.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to select one of the three hosting Control Panels that we offer – Hepsia and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to enable this database storage engine manually in order to be able to run open-source script-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the system resources that you need to run large-scale websites, it’s quite possible that you will use InnoDB. You’ll be able to make use of other engines as well, so if a particular app needs MyISAM rather than InnoDB, you won’t have any complication while using it. The engine that will be used will be recognized automatically once the app installation process starts, so you will not have to change any settings manually at any time.