InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got numerous upsides that make it the preferred engine for a lot of PHP script-driven applications, among them Magento and Joomla, which have moved to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to execute a particular operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Put simply, appending new or modifying existing data will either be entirely completed, or will be aborted and the operation will be rolled back if any issue appears during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our Linux cloud website hosting service by default, not upon request or as a paid upgrade, so you can activate and run any open-source script-powered software application which requires the MySQL database storage engine without any problems as soon as you order your account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, irrespective of whether you take advantage of our one-click installer or create the MySQL database and install the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will make daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content in case you erase a database by accident or you overwrite some crucial information – you will just have to get in touch with us and we will restore the database the way it was.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you can take advantage of all the features of this storage engine with any PHP script-driven software application that needs it. InnoDB is among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the specific application. You will not have to do anything manually in order to enable InnoDB, as it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To be on the safe side, we’ll create daily MySQL database backups, so if something goes wrong after an upgrade or if you erase some data by mistake, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software pack that will be pre-installed on your Virtual Private Server before we hand it over to you. You won’t need to set up anything manually and you will be able to install and use any script-based web application that needs InnoDB as soon as your VPS is ready, which takes no more than one hour after the order submission itself. Several engines are available, so anytime you set up a database via the Hepsia Control Panel, a specific engine will be activated once the app activation process begins and our system will automatically detect the engine that is required by the app in question. If you need to use MyISAM, for example, you will not need to do anything different from installing the chosen app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All Linux dedicated service ordered with our custom Hepsia Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually if you need to run open-source PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to start the setup – as soon as the script setup wizard gets access to the database and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to run scripts that need the other very popular MySQL engine – MyISAM, so you will not have to update any settings on the dedicated server. This will enable you to activate a variety of scripts on one single physical machine and to use the latter to its full potential.