InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-powered apps such as Joomla™ 3 and Magento. It’s excellent for scalable applications, as it performs remarkably well when handling large volumes of data. Instead of locking the whole table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same period of time. What’s more, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be handled. If a given task has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

InnoDB is available with all our cloud hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-driven web application that requires the InnoDB database engine without any problem once you order your shared account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, regardless of whether you make use of our 1-click installer or create the MySQL database and activate the application manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will create daily database backups, so you can be certain that you will never lose any data in case you delete a database accidentally or you overwrite some essential information – you simply need to touch base with us and we’ll restore the database back to normal.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually if you need to run scripts that require it. All it takes to use such a script is to create a new database and to begin the installation process – once the installation wizard acquires access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that require MyISAM – the other popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will enable you to activate different scripts on one single machine and to use it to its maximum capacity.