InnoDB is a storage engine for MySQL relational databases, which is used by famous open-source script-driven applications such as Magento and Joomla™ v3. It is ideal for scalable applications, since it performs amazingly well when managing immense amounts of data. 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 process much more tasks for the same period of time. Besides, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be treated. If a certain operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and will not be partially merged with newly imported content.

InnoDB in Website Hosting

Any script-driven software app that requires InnoDB will run impeccably on our avant-garde cloud hosting platform and the MySQL database storage engine is available with all our website hosting packages. Every time you create a MySQL database manually or our app installer 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 requirements without having to configure any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We will generate regular backups of your content, so if you accidentally remove a database that is important to you or you overwrite certain parts of it, we will be able to restore everything the way it was just several hours earlier.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t have to activate it manually if you wish to activate PHP scripts that need it. All it takes to activate such a script is to create a new MySQL database and to begin the setup process – once the installer wizard gets access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to run scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to change any settings on the server. This will permit you to install a variety of scripts on one single machine and to use the latter to its fullest capacity.