InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP-based software apps such as Joomla v3 and Magento. It is perfect for scalable applications, as it works remarkably well when processing huge data volumes. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be treated. In case a specific operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the database content will remain undamaged and won’t be partially mixed with newly added content.

InnoDB in Web Hosting

Any script-driven application that needs InnoDB will function flawlessly on our avant-garde cloud platform and the MySQL storage engine is offered with all our web hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected based on the app’s prerequisites without having to modify any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We will create regular backups of your content, so in case you unintentionally erase a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore the database the way it was just several hours ago.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB database engine, so you will not have to activate it manually if you wish to activate open-source PHP scripts that require it. All it takes to run such a script is to set up a new database and to start the setup – once the installer wizard accesses 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 required by the script. You will also be able to use scripts that require the other popular MySQL engine, MyISAM, so you won’t need to modify any settings on the dedicated server. This will enable you to activate different scripts on one single machine and to use it to its fullest potential.