InnoDB is a storage engine for MySQL relational databases, which is used by famous script-driven web apps like Joomla 3.x and Magento. It’s perfect for scalable applications, as it performs amazingly well when managing immense amounts of data. Rather than locking the whole table to append new information to a database like many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same length of time. Additionally, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. If a specific operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be preserved intact and won’t be partially mixed with newly added content.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it’s an integral part of the standard set of services that we’re offering with our website hosting plans. If you’d like to use a script-based application that needs InnoDB particularly, in order to be activated and to work correctly, you will not come across any difficulties as the storage engine is available on our custom-built cloud website hosting platform. No matter if you create a new MySQL database and activate an app manually or use our single-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the application requires it instead of MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also perform daily backups of all databases, so that we can swiftly recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database through the Control Panel offered with all our semi-dedicated server accounts and you begin installing a PHP script-based software app either manually or using our single-click application installer, the database storage engine will be set automatically on the basis of the prerequisites of the given app. As InnoDB is available on the cloud 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 intervention needed on your end at any time. To avoid any risk of losing info if you update an app or if you erase a database by accident, we will perform a backup of all your MySQL databases each day, so if anything happens, we can rescue your data.

InnoDB in VPS Hosting

If you get a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be an indivisible part of the standard software package that will be pre-installed on your Virtual Private Server before we give it to you. You won’t have to activate anything manually and you’ll be able to install and manage any script-based application that requires InnoDB as soon as your VPS server is set up, which takes no more than 60 minutes after the order submission process itself. A number of engines are offered, so whenever you create a MySQL database using the Hepsia hosting Control Panel, a particular engine will be activated when the app installation commences and our system will automatically detect the engine that is required by the application in question. If you need to use MyISAM, for example, you won’t need to do anything different from installing the chosen app, whether manually or using our app installer tool.

InnoDB in Dedicated Web Hosting

If you get a new dedicated server, you’ll be able to choose any of the three hosting Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to add this database storage engine manually so as to be able to run script-driven web apps that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you require to run large-scale sites, it is rather likely that you will use InnoDB. You will be able to use other engines too, so in case a given app needs MyISAM rather than InnoDB, you won’t have any problem while running it. The engine that will be used will be automatically recognized the moment the app installation process commences, so you will not need to update any settings manually at any time.