InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-based web apps such as Joomla™ v3 and Magento. It’s perfect for scalable apps, since it works really well when managing huge volumes of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. In addition, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – a set of rules that determine how data inserts and updates should be treated. If a given task has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will be kept undamaged and will not be partially mixed with new content.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it’s an integral part of the standard set of services that we’re offering with our shared website hosting packages. In case you wish to make use of an open-source script-driven web application that requires InnoDB particularly, in order to be installed and to work properly, you won’t have any problems since the InnoDB database storage engine is available on our custom cloud web hosting platform. Irrespective of whether you set up a new MySQL database and activate an application manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app needs it instead of MyISAM. In addition to the remarkable crash recovery that InnoDB is offering, we also generate daily database backups, so that we can easily recover any database in your shared web hosting account.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not need to add it manually if you need to run scripts that need it. All it takes to install such a script is to set up a new database and to start the installation – as soon as the script configuration wizard gets access to the database and starts importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to edit any settings on the dedicated server. This will permit you to activate various scripts on a single server and to use the latter to its fullest capacity.