InnoDB is a database engine for MySQL relational databases, which is used by famous PHP-based web apps like Joomla™ 3.x and Magento. It is perfect for scalable applications, as it performs incredibly well when handling large amounts of data. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. Plus, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that determine how data inserts and modifications should be treated. In case a particular operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will stay undamaged and will not be partially mixed with newly added content.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not as a paid upgrade or upon request, so you can install and manage any script-powered software app which needs the database storage engine without any obstacles once you open your account. InnoDB will be selected automatically as the default engine for a particular 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 application manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will generate daily backups of all your databases, so you can be certain that you won’t ever lose any data in case you delete a database by accident or you overwrite some key info – you just have to touch base with us and we’ll restore your database back to normal.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to install it manually in case you wish to use PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation – once the installation wizard receives access to the database in question and starts entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to run scripts that require MyISAM – the other popular MySQL engine, so you will not have to update any settings on the dedicated server. This will allow you to run a variety of scripts on one single server and to use it to its maximum capacity.