InnoDB is a database engine for MySQL relational databases, which is used by popular script-driven web applications like Magento and Joomla 3.x. It’s excellent for scalable applications, as it performs stunningly well when processing immense volumes of data. Instead of locking the whole database table to insert new information in a database as 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 database crash recovery and supports transactions and foreign key constraints – rules that indicate how data inserts and modifications should be handled. In case a given task hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the database content will be kept undamaged and won’t be partially mixed with newly imported content.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server packages and you start installing a script-driven software app either manually or using our 1-click application installer, the MySQL database storage engine will be selected automatically on the basis of the given app’s requirements. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without any manual action required on your end at any point. To prevent any risk of losing data if you update an application or if you erase a database by mistake, we will generate a backup of all your databases every day, so if anything goes wrong, we can recover your content.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is chosen during the registration process for your new VPS plans , InnoDB will be activated on the server together with other required software, so you won’t have to do anything if you decide to run PHP script-based web apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed too. You can create a new database and start the app installation process manually or through our single-click installer. The system will automatically detect the engine that the particular application requires and will set it for the specific database, so the installation process will continue impeccably and the application can insert its data into that database. Thus, you can run applications with different requirements concerning the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an integral part of the software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is assembled, you’ll be able to sign in and to activate any open-source script-driven application that requires this particular MySQL database engine. When you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an app. As soon as the app setup wizard begins importing information into the newly created database, the engine will be picked automatically in accordance with the prerequisites of the respective application, so you can use both MyISAM and InnoDB without having to select either one specifically at any point. In this way, you can use a wide range of applications for your sites.