InnoDB is a database engine for MySQL databases, which is used by famous script-powered software applications like Joomla 3 and Magento. It’s excellent for scalable apps, as it performs exceptionally well when processing enormous amounts of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Plus, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and updates should be handled. In case a particular task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be kept undamaged and will not be partially merged with newly inserted content.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting plans by default, not as a paid upgrade or upon request, so you can install and run any PHP-powered application which needs the MySQL storage engine without any difficulty once you order your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, regardless of whether you take advantage of our 1-click installer or create the MySQL database and set up the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will store regular backups of all your MySQL databases, so you can rest assured that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some key information – you’ll just have to inform us and we will restore your content back to normal.

InnoDB in Semi-dedicated Servers

You can use a script-based software app that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our avant-garde cloud web hosting platform where the MySQL database storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you take advantage of our single-click application installer. In either case, the needed engine will be selected automatically the moment the installation of the app starts, so you won’t have to update anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to retrieve any of your databases if you remove one by accident, as we make several MySQL database backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the default software package that will be installed on your Virtual Private Server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and run any PHP-based web app that needs InnoDB when your VPS server is set up, which takes no more than 1 hour after the order submission procedure itself. A few engines are offered, so whenever you set up a database via the Hepsia hosting Control Panel, a particular engine will be selected once the app activation process begins and our system will detect which engine is required by the app in question. In case you have to use MyISAM, for example, you won’t have to do anything different than installing the chosen app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom Hepsia Control Panel come with a software bundle that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually if you want to use open-source scripts that require it. All it takes to run such a script is to create a new MySQL database and to initiate the setup – as soon as the script setup wizard gains access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to use scripts that require the other very popular MySQL engine, MyISAM, so you will not have to configure any settings on the dedicated server. This will permit you to install various scripts on a single machine and to use it to its maximum capacity.