InnoDB is a storage engine for MySQL relational databases, which is used by well known open-source script-driven applications such as Magento and Joomla v3. It is excellent for scalable applications, since it performs really well when handling huge 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 carry out a lot more operations for the same period of time. Additionally, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. If a certain operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain intact and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

You will be able to use any PHP script-powered app that needs InnoDB in case you have a Linux cloud hosting service with our company, as the storage engine is present on our advanced cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run apps which use the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be pre-selected, so you won’t need to change anything manually at any time. What’s more, we’ll also make daily backups of all the databases that you have in your account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel offered with all our semi-dedicated server plans and you start installing a PHP script-driven app either manually or using our single-click app installer, the storage engine for the database will be set automatically on the basis of the requirements of the particular application. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that needs it without any manual action required on your end at any moment. To prevent any chance of losing info if you update an application or if you erase a database accidentally, we’ll carry out backups of all your MySQL databases each day, so if anything happens, we can recover your data.

InnoDB in VPS

In case our in-house built Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers , InnoDB will be activated on the VPS server along with other necessary software, so you will not have to do anything if you choose to install open-source script-driven software apps that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand-new MySQL database and begin installing the application manually or using our single-click installer tool. The system will detect the engine that the particular app requires and will set it for the specific database, so the installation process will proceed impeccably and the application can enter its content into that database. In this way, you can manage apps with various requirements in regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our in-house built Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually in case you would like to use open-source 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 – as soon as the installation wizard gets access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to install scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to modify any settings on the server. This will enable you to install a variety of scripts on one single physical machine and to use it to its full potential.