InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based apps like Joomla 3.x and Magento. It is excellent for scalable apps, since it works really well when processing large amounts of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same length of time. Plus, InnoDB offers a faster database failure recovery and supports transactions and foreign keys – rules that prescribe how data imports and modifications should be handled. In case a certain task has not been entirely completed for some reason, the action will be rolled back. Thus, the database content will be retained safe and sound and will not be partially mixed with newly entered content.

InnoDB in Web Hosting

You will be able to install any PHP script-based web application that needs InnoDB in case you’ve got a web hosting with us, as the MySQL database engine is present on our innovative cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can activate applications which need the MyISAM engine without having to deal with any problem as well and, once again, the engine will be selected automatically, so you will not have to modify any setting manually at any time. Furthermore, we’ll also generate daily backups of all the databases that you’ve got in your shared account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t have to add it manually if you would like to run open-source scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup – once the installation wizard accesses the database in question and starts importing content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to run scripts that need the other popular MySQL engine – MyISAM, so you won’t have to modify any settings on the dedicated server. This will enable you to install various scripts on a single physical machine and to use it to its maximum potential.