InnoDB is a database engine for MySQL relational databases, which is used by well known script-based apps like Magento and Joomla 3.x. It is excellent for scalable applications, because it performs unbelievably well when managing enormous volumes of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Additionally, InnoDB offers a much better crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be treated. If a certain operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the database content will stay undamaged and won’t be partially mixed with newly appended content.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting providers, it is an integral part of the standard set of features offered with our hosting plans. In case you would like to make use of a PHP script-based software app that needs InnoDB specifically, in order to be activated and to perform properly, you won’t face any problems since the database engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a brand-new MySQL database and activate an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given app needs it instead of MyISAM. In addition to the amazing crash recovery that InnoDB offers, we also keep daily database backups, so we can easily recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server packages and you begin installing a PHP-driven software application either manually or using our one-click application installer, the MySQL database storage engine will be selected automatically on the basis of the requirements of the specific app. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action required on your end at any moment. To prevent any risk of losing info if you update an application or if you delete a database by accident, we’ll make backups of all your MySQL databases each day, so if something happens, we can recover your content.

InnoDB in Dedicated Hosting

All Linux dedicated hosting services that are ordered with our in-house built Hepsia Control Panel include a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not need to add it manually in case you need to run PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation – as soon as the installer wizard obtains access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to run scripts that require the other popular MySQL engine – MyISAM, so you won’t need to change any settings on the server. This will allow you to activate different scripts on one single machine and to use it to its maximum capabilities.