InnoDB is a database engine for MySQL databases, which is used by widely used PHP-powered apps such as Joomla v3 and Magento. It’s excellent for scalable applications, since it works stunningly well when managing huge volumes of data. Instead of locking the whole table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Moreover, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and modifications should be handled. If a particular task has not been fully completed for some reason, the action will be rolled back. In this way, the information in the database will be retained safe and sound and will not be partially merged with newly appended content.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting plans by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP-driven software application that requires the database storage engine without any problem once you activate your account. InnoDB will be selected automatically as the default engine for a particular database during the app installation, irrespective of whether you make use of our 1-click installation tool or create the database and set up the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will carry out regular backups of all your MySQL databases, so you can be sure that you won’t ever lose any content if you erase a database unintentionally or you overwrite some important information – you will simply need to contact us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated plans by default, so once you purchase a new semi-dedicated account, you can move on and install any script-powered web application that needs this particular MySQL storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you set up a brand-new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked in accordance with the requirements of the particular app. This will allow you to install and manage InnoDB-specific applications without having any difficulty and without updating any settings in your semi-dedicated account. To be on the safe side, we will always keep a seven-day-old backup of all your MySQL databases, so if you delete or change any content by accident, we can easily retrieve it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to run any open-source script-driven application that requires this MySQL storage engine without the need to activate anything manually. You can choose Hepsia on the VPS configuration page and your brand-new server will be set up within sixty minutes, so you can sign in and begin creating your websites right away. Once you set up a new MySQL database and start the app activation process, our system will choose the engine for this database automatically. In this way, you can use different applications simultaneously without configuring anything on the server. You can set up a WordPress-powered weblog that uses MyISAM – the default MySQL engine, and a Magento-based e-commerce website that uses InnoDB, for instance.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually in case you want to run scripts that require it. All it takes to use such a script is to set up a new MySQL database and to initiate the installation process – once the installation wizard acquires access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you will not need to change any settings on the server. This will permit you to activate a variety of scripts on a single server and to use the latter to its fullest capacity.