InnoDB is a storage engine for MySQL databases, which is used by popular open-source script-driven apps like Magento and Joomla™ 3.x. It is excellent for scalable applications, as it performs stunningly well when handling enormous 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 much more operations for the same period of time. Plus, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a certain task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will stay undamaged and won’t be partially mixed with newly appended content.

InnoDB in Shared Website Hosting

InnoDB is available with all our shared website hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP-driven app which requires the MySQL storage engine without encountering any problem as soon as you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, regardless of whether you use our single-click installer or create the MySQL database and activate the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We will generate regular database backups, so you can rest assured that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some key information – you just need to alert us and we will restore your data the way it was.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you will not have to activate it manually in case you wish to run PHP scripts that need it. All it takes to run such a script is to create a new database and to initiate the installation – once the setup wizard accesses the database in question and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You’ll also be able to use scripts that need MyISAM, the other very popular MySQL engine, so you won’t have to modify any settings on the server. This will allow you to activate different scripts on one single physical machine and to use it to its maximum capacity.