InnoDB is a storage engine for MySQL relational databases, which is used by widely used open-source script-powered web apps like Joomla v3 and Magento. It is excellent for scalable apps, because it works really well when managing immense volumes of data. Rather than locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same period of time. Furthermore, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be treated. If a certain operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially merged with new content.

InnoDB in Cloud Hosting

Every script-based application that requires InnoDB will run flawlessly on our avant-garde cloud web hosting platform and the storage engine is available with all our cloud hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected on the basis of the app’s specifications without having to configure any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We will create regular content backups, so in case you accidentally remove a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore your content the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server plans and you begin installing an open-source script-powered software app either manually or using our one-click application installer tool, the storage engine for the MySQL database will be picked automatically depending on the particular app’s requirements. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any time. To prevent any risk of losing info if you update an application or if you delete a database unintentionally, we will perform a backup of all your MySQL databases each day, so if anything happens, we can restore your data.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you won’t need to activate it manually in case you need to run open-source scripts that need it. All it takes to use such a script is to set up a new database and to start the installation process – once the script setup wizard receives access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that require MyISAM, the other widely used MySQL engine, so you will not need to update any settings on the server. This will enable you to run various scripts on one single server and to use it to its fullest potential.