InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP-powered web apps such as Joomla 3.x and Magento. It is perfect for scalable applications, because it works amazingly well when processing immense volumes of data. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same period of time. Plus, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be handled. If a certain operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be kept intact and won’t be partially merged with newly appended content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is part of the default set of features that we are offering with our cloud web hosting packages. In case you wish to use a PHP-powered web application that requires InnoDB particularly, in order to be activated and to operate correctly, you won’t need to deal with any difficulties as the MySQL storage engine is available on our custom-built cloud website hosting platform. Irrespective of whether you set up a new database and activate an application manually or take advantage of our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application needs it instead of MyISAM. In addition to the amazing database crash recovery that InnoDB offers, we also carry out daily database backups, so that we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the hosting Control Panel included with each of our semi-dedicated server packages and you start installing a script-based web application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the given app’s prerequisites. As InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any time. To avoid any risk of losing data if you update an app or if you delete a database by accident, we’ll generate a backup of all your MySQL databases each day, so if something happens, we can restore your content.

InnoDB in Dedicated Web Hosting

InnoDB comes as standard with all Linux dedicated web hosting ordered with the Hepsia hosting Control Panel. It is part of the default software bundle that will be installed on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you’ll be able to sign in and to activate a various script-driven software app that requires this particular MySQL storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app configuration wizard starts entering content into the database, the engine will be chosen automatically based on the requirements of the respective application, so you can use both MyISAM and InnoDB without the need to select either of them explicitly at any moment. Therefore, you can make use of a large collection of apps for your Internet sites.