InnoDB is a storage engine for MySQL databases, which is used by famous script-driven apps like Magento and Joomla 3. It’s excellent for scalable applications, because it works exceptionally well when managing immense data volumes. Instead of locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. Besides, InnoDB offers a better crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be treated. In case a certain operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially merged with newly entered content.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting services by default, not as a paid upgrade or upon request, so you will be able to install and run any open-source script-powered application which needs the storage engine without encountering any impediment as soon as you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, no matter if you make use of our one-click installation tool or create the database and activate the app manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll carry out regular backups of all your MySQL databases, so you can rest assured that you will never lose any data if you delete a database by accident or you overwrite some vital info – you will simply need to inform us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Hosting

You can use a PHP script-based software application that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud web hosting platform where the MySQL database storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click app installer. Either way, the needed engine will be selected automatically the moment the app’s installation begins, so you will not have to configure anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. On top of that, we will always be able to recover any of your databases if you unintentionally erase one, as we perform a couple of backups every day, each of which is kept for 1 week.

InnoDB in VPS Hosting

In case our in-house built Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be activated on the server together with other essential pieces of software, so you will not have to do anything if you choose to activate script-based software apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a new MySQL database and start the app installation manually or using our 1-click installer. The system will automatically recognize the engine that the particular app requires and will assign it to the specific database, so the installation process will continue impeccably and the application can dump its content in that database. Therefore, you can manage apps with various prerequisites with regard to the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Web Hosting

All Linux dedicated hosting services that are ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to activate it manually if you need to run open-source PHP scripts that need it. All it takes to install such a script is to create a new MySQL database and to begin the installation – once the installation wizard receives access to the database and begins inserting data into 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 will also be able to activate scripts that require MyISAM, the other very popular MySQL engine, so you will not need to update any settings on the dedicated server. This will permit you to install various scripts on a single physical machine and to use the latter to its full potential.