InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP-driven software apps like Joomla v3 and Magento. It is excellent for scalable applications, because it performs exceptionally well when handling large volumes of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same period of time. Also, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be handled. In case a certain task has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and will not be partially mixed with newly imported content.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any script-powered software app which requires the InnoDB storage engine without encountering any impediment once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app installation, regardless of whether you make use of our one-click installer or create the database and activate the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will make regular backups of all your MySQL databases, so you can be sure that you’ll never lose any content if you delete a database by accident or you overwrite some essential info – you’ll just need to contact us and we’ll restore your database back to normal.

InnoDB in Semi-dedicated Hosting

You can activate a PHP-driven web application that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our 1-click app installer. In either case, the needed engine will be selected automatically as soon as the activation of the app starts, so you will not need to modify anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. Also, we’ll always be able to restore any of your MySQL databases in case you accidentally delete one, as we perform a few database backups every day, each of which is saved for seven days.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia Control Panel is picked during the registration process for a new Linux virtual private servers , InnoDB will be installed on the server along with other necessary software, so you won’t need to do anything if you choose to manage open-source script-powered applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and start the app installation procedure manually or through our one-click installer. The system will recognize which engine the particular application needs and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the app can insert its content into that database. In this way, you can activate applications with different requirements regarding the MySQL engine without the need to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers Hosting

If you get a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this MySQL storage engine manually to be able to manage script-based software applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need to manage large-scale websites, it’s very possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a certain app requires MyISAM instead of InnoDB, you will not encounter any impediment while using it. The engine that will be used will be automatically detected the moment the app installation process commences, so you will not have to fine-tune any setting manually at any moment.