InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based software apps such as Joomla 3.x and Magento. It is excellent for scalable applications, as it performs incredibly well when processing large amounts of data. Instead of locking the entire database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same length of time. Moreover, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be treated. In case a certain operation has not been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be retained safe and sound and will not be partially merged with newly appended content.

InnoDB in Cloud Hosting

Every open-source script-powered web application that needs InnoDB will function flawlessly on our avant-garde cloud hosting platform and the database storage engine comes with all our cloud hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s specifications without having to configure any setting in your account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll store regular content backups, so in case you accidentally delete a MySQL database that is important to you or you overwrite a specific part of it, we will be able to restore the database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server plans and you start installing a script-powered application either manually or using our 1-click application installer tool, the database storage engine will be picked automatically based on the requirements of the app in question. As InnoDB is available on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that requires it without any manual intervention needed on your end at any point. To prevent any risk of losing info if you update an application or if you erase a database by accident, we’ll generate a backup of all your MySQL databases every day, so if anything goes wrong, we can restore your data.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house developed Hepsia hosting Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not need to add it manually in case you want to activate scripts that need it. All it takes to install such a script is to create a new database and to start the setup process – as soon as the script configuration wizard accesses the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to activate scripts that need MyISAM, the other popular MySQL engine, so you won’t have to change any settings on the server. This will enable you to install different scripts on one single server and to use it to its full potential.