InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-powered software applications such as Magento and Joomla 3.x. It is ideal for scalable applications, because it works exceptionally well when handling huge volumes of data. Rather than locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more tasks for the same length of time. Moreover, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – rules that specify how data inserts and updates should be handled. If a specific operation hasn’t been fully completed for some reason, the action will be rolled back. Thus, the database content will stay undamaged and will not be partially mixed with newly inserted content.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting providers, it’s an integral part of the default set of features that we are offering with our shared hosting plans. In case you would like to make use of a script-driven software application that requires InnoDB particularly, in order to be activated and to perform correctly, you won’t experience any obstacles as the InnoDB database engine is available on our custom-developed cloud hosting platform. Regardless of whether you create a new MySQL database and install an application manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs it instead of MyISAM. In addition to the outstanding crash recovery that InnoDB is offering, we also carry out daily database backups, so we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can use a script-powered web application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our advanced cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our one-click application installer. In either case, the required engine will be picked automatically the moment the application’s activation starts, so you will not need to edit anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. In addition, we will always be able to restore any of your databases if you unintentionally remove one, as we carry out a few backups every day, each of which is saved for one week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the software package that will be pre-installed on your VPS server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and use any open-source script-based web app that needs InnoDB when your VPS server is up and running, which takes no more than 1 hour after the order submission procedure itself. A couple of engines are available, so anytime you create a database using the Hepsia hosting Control Panel, a specific engine will be selected once the app installation process commences and our system will recognize the engine that is required by the app in question. In case you need MyISAM, for example, you will not have to do anything different than installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not have to install it manually if you would like to activate open-source PHP scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to start the setup – as soon as the setup wizard accesses the database in question and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to install scripts that need the other popular MySQL engine – MyISAM, so you will not have to edit any settings on the dedicated server. This will permit you to run a variety of scripts on one single machine and to use the latter to its maximum potential.