InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-powered applications like Magento and Joomla v3. It is perfect for scalable apps, because it works astonishingly well when processing huge data volumes. Instead of locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same length of time. Plus, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and updates should be treated. In case a particular operation hasn’t been fully completed for some reason, the action will be rolled back. In this way, the database content will remain undamaged and won’t be partially merged with newly appended content.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting companies, it is an integral part of the default set of services that we are offering with our cloud hosting plans. In case you’d like to make use of a PHP script-based web app that requires InnoDB particularly, in order to be installed and to function correctly, you will not encounter any impediments since the MySQL database storage engine is available on our in-house developed cloud web hosting platform. Irrespective of whether you set up a new MySQL database and activate an application manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. In addition to the excellent database crash recovery that InnoDB offers, we also keep daily backups of all databases, so we can easily restore any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the Control Panel included with each of our semi-dedicated server packages and you start installing a script-powered web app either manually or using our single-click application installer tool, the storage engine for the MySQL database will be selected automatically based on the requirements of the particular app. Since 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 each application that needs it without the need for any manual intervention on your end at any point. To avoid any risk of losing information if you update an application or if you delete a database by mistake, we’ll generate backups of all your MySQL databases each day, so if anything happens, we can recover your data.

InnoDB in VPS Servers

When you get a VPS server from our company, you will be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to install any open-source script-driven web app that requires InnoDB, as this MySQL storage engine is part of the default software package that will be installed on your server during its setup. When you create a brand new database using the Control Panel, you just need to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you will not need to do anything else in your account. Equivalently, if an app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t have to add it manually in case you need to use PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to start the installation – as soon as the script setup wizard accesses the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You will also be able to run scripts that need MyISAM – the other popular MySQL engine, so you will not need to update any settings on the dedicated server. This will permit you to install various scripts on one single server and to use it to its maximum capacity.