InnoDB is a database storage engine for MySQL databases, which is used by popular open-source script-driven web apps like Joomla v3 and Magento. It is ideal for scalable apps, since it performs remarkably well when processing enormous volumes of data. Rather than locking the entire table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that define how data inserts and modifications should be handled. In case a particular operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and will not be partially mixed with new content.

InnoDB in Cloud Hosting

InnoDB is available with all our cloud hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-based software application which needs the database engine without any impediments once you activate your shared account. InnoDB will be selected automatically as the default engine for a given database during the app activation process, no matter if you make use of our 1-click installation tool or create the database and activate the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will store regular backups of all your databases, so you can be certain that you’ll never lose any content if you delete a database unintentionally or you overwrite some crucial info – you will just need to touch base with us and we will restore your content the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you’ll be able to take advantage of all the features offered by this MySQL storage engine with any PHP script-driven app that needs it. InnoDB is one of the engines that are available on our cloud platform, so the one that will be used depends on the particular app’s requirements. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we’ll generate regular backups of all your databases, so if anything goes wrong after an upgrade or if you erase some data by mistake, we will be able to get the database back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to activate it manually if you wish to activate PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to begin the setup – as soon as the installer wizard obtains access to the database and starts importing 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 particular script. You will also be able to use scripts that require the other popular MySQL engine, MyISAM, so you will not need to change any settings on the dedicated server. This will allow you to run various scripts on a single machine and to use it to its fullest potential.