InnoDB is a database engine for MySQL databases, which is used by widely used script-based applications like Magento and Joomla v3. It is ideal for scalable applications, since it works incredibly well when processing enormous data volumes. 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 complete much more tasks for the same length of time. In addition, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data inserts and modifications should be treated. In case a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will stay intact and won’t be partially merged with newly added content.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it is an integral part of the standard set of features that we offer with our shared web hosting packages. If you would like to use a PHP script-driven software app that needs InnoDB specifically, in order to be activated and to operate properly, you won’t experience any obstacles since the MySQL storage engine is available on our custom-built cloud hosting platform. Regardless of whether you create a brand new MySQL database and install an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app requires it instead of MyISAM. In addition to the excellent crash recovery offered by InnoDB, we also store daily backups of all databases, so we can swiftly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated servers by default, so once you order a new account, you can go ahead and activate any script-powered app that needs the storage engine. A number of engines are installed on our cloud web hosting platform, so when you set up a brand new database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected in accordance with the prerequisites of the app in question. This will permit you to install and run InnoDB-specific apps without running into any problem and without having to configure any settings in your semi-dedicated account. To be on the safe side, we’ll always have a seven-day-old backup of all your databases, so if you erase or edit any content accidentally, we can swiftly restore it.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom Hepsia Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually if you want to run PHP scripts that need it. All it takes to install such a script is to set up a new MySQL database and to begin the setup process – as soon as the script configuration wizard obtains access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require the other very popular MySQL engine – MyISAM, so you will not need to modify any settings on the dedicated server. This will enable you to use a variety of scripts on a single physical server and to use it to its full capacity.