InnoDB is a storage engine for MySQL databases, which is used by famous PHP-driven apps such as Joomla 3.x and Magento. It’s ideal for scalable apps, because it works stunningly well when processing large volumes of data. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. Additionally, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be handled. In case a specific task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will stay undamaged and won’t be partially merged with newly imported content.

InnoDB in Web Hosting

You can use any script-powered software application that requires InnoDB if you have a Linux web hosting package with our company, as the MySQL database engine is available on our cutting-edge cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can run applications which require the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you will not have to configure any setting manually at any point. Furthermore, we’ll also make regular backups of all the databases that you’ve got in your account, so if you erase or overwrite anything, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

You can activate a PHP-based web application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our advanced cloud hosting platform where the MySQL database storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our single-click application installer. Either way, the required engine will be picked automatically as soon as the application’s activation starts, so you won’t need to change anything manually, no matter if the application requires InnoDB or the more regularly used MyISAM. Also, we will always be able to recover any of your MySQL databases in case you remove one by mistake, as we perform several MySQL database backups every day, each of which is preserved for one week.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually if you would like to activate open-source scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup process – once the setup wizard gets access to the database and begins inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to modify any settings on the dedicated server. This will permit you to run a variety of scripts on a single machine and to use it to its full potential.