InnoDB is a database engine for MySQL databases, which is used by widespread open-source script-driven software apps such as Magento and Joomla 3. It’s ideal for scalable applications, because it performs exceptionally well when processing huge data volumes. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same length of time. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be treated. In case a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the content in the database will be retained safe and sound and will not be partially merged with new content.

InnoDB in Shared Website Hosting

Every PHP script-powered application that needs InnoDB will function flawlessly on our avant-garde cloud hosting platform and the MySQL database storage engine comes with all our shared website hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to update any setting in your shared account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We will make regular content backups, so in case you accidentally remove a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore the database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our Linux semi-dedicated hosting service by default, so the moment you get a new account, you can go ahead and install any open-source script-powered application that needs this MySQL storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a new database and begin installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected depending on the particular app’s requirements. This will allow you to install and manage InnoDB-specific apps without needing to deal with any problem and without needing to modify any settings in your account. To avoid any risk, we will always have a 7-day-old backup of all your MySQL databases, so if you delete or alter any content by accident, we can swiftly recover it.

InnoDB in VPS Servers

All VPS web hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any PHP-powered web application that needs this MySQL storage engine without needing to set up anything manually. You can select Hepsia on the VPS order form and your new VPS server will be up and running within sixty minutes, so you can log in and begin creating your websites right away. When you create a new database and start the app activation process, our system will set the engine for this MySQL database automatically. Thus, you can activate different apps at the same time without updating anything on the Virtual Private Server. You can have a WordPress weblog that makes use of the default MySQL engine – MyISAM, and a Magento Internet shop that uses InnoDB, for example.

InnoDB in Dedicated Servers

When you get a new dedicated server, you will be able to select any of the three Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this database storage engine manually in order to be able to manage PHP-based software apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require to manage very large websites, it is very likely that you will resort to InnoDB. You will be able to make use of other engines too, so in case a particular app requires MyISAM instead of InnoDB, you will not need to deal with any predicament while managing it. The engine that will be used will be automatically detected the moment the app installation procedure commences, so you won’t have to alter any setting manually at any moment.