InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP script-powered apps such as Joomla™ v3 and Magento. It’s excellent for scalable apps, as it works amazingly well when handling large volumes of data. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Moreover, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. If a given operation has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will remain undamaged and won’t be partially mixed with newly inserted content.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting packages by default, not as a paid upgrade or upon request, so you will be able to install and run any script-powered software application which requires the InnoDB storage engine without the need to deal with any obstacle as soon as you order your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app installation, regardless of whether you make use of our one-click installer or create the database and set up the application manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll maintain regular database backups, so you can be sure that you’ll never lose any content in case you delete a database by mistake or you overwrite some crucial info – you just need to touch base with us and we’ll restore your database the way it was.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia Control Panel include a software package that’s pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you want to use open-source PHP scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to begin the installation – as soon as the script setup wizard gains access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You will also be able to install scripts that require MyISAM, the other widely used MySQL engine, so you won’t need to edit any settings on the server. This will enable you to run a variety of scripts on a single physical machine and to use the latter to its maximum capabilities.