InnoDB is a storage engine for MySQL databases, which is used by popular script-driven web applications such as Magento and Joomla v3. It’s perfect for scalable applications, since it works remarkably well when processing huge volumes of data. Rather than locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. In addition, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and updates should be handled. If a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will remain undamaged and won’t be partially merged with newly imported content.

InnoDB in Cloud Website Hosting

You can make use of any PHP script-based software app that needs InnoDB in case you have a cloud website hosting with our company, as the MySQL database storage engine is present on our leading-edge cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can install apps that need the MyISAM engine without the need to deal with any difficulty as well and, once again, the engine will be pre-selected, so you will not have to configure anything manually at any time. In addition, we’ll also make daily backups of all the databases that you’ve got in your shared account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting come with InnoDB and you will be able to take advantage of all the options offered by this database engine with any PHP script-based web app that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the given app. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our 1-click application installer. To be on the safe side, we’ll carry out daily backups of all your MySQL databases, so if something goes wrong following some update or if you delete some data by mistake, we will be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Web Hosting

When you obtain a virtual private server from us, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to activate any PHP script-driven app that needs InnoDB, as this particular MySQL storage engine is included in the software package that will be installed on the VPS server during its configuration. When you create a brand-new MySQL database using the hosting Control Panel, you just have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the app in question requires it, so you won’t have to do anything else in your account. Analogously, if an app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers Hosting

If you purchase a new dedicated server, you will be able to pick one of the three hosting Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to install this storage engine manually so as to be able to use PHP script-driven software applications that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require in order to manage large-size websites, it is rather possible that you’ll use InnoDB. You’ll be able to use other engines too, so in case a specific application requires MyISAM rather than InnoDB, you will not have any difficulty while managing it. The engine that will be used will be recognized automatically once the app installation procedure begins, so you won’t need to configure any settings manually at any moment.