InnoDB is a storage engine for MySQL databases, which is used by popular PHP-driven applications like Magento and Joomla™ 3. It’s perfect for scalable applications, as it performs astonishingly well when processing enormous volumes of data. Rather than locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Also, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. If a certain task has not been fully completed for some reason, the action will be rolled back. In this way, the content in the database will be kept intact and will not be partially mixed with newly inserted content.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosting providers, it is an essential part of the default set of services offered with our shared hosting plans. If you wish to make use of a PHP script-based app that requires InnoDB in particular, in order to be installed and to function correctly, you won’t need to deal with any difficulties as the InnoDB database storage engine is available on our custom cloud hosting platform. Regardless of whether you set up a brand-new MySQL database and activate an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the app requires it rather than MyISAM. In addition to the remarkable crash recovery that InnoDB is offering, we also store regular backups of all databases, so we can easily restore any database in your shared hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our semi-dedicated hosting plans by default, so the moment you obtain a new account, you can go on and activate any script-based software app that needs the database storage engine. A number of engines are pre-installed on our cloud web hosting platform, so when you set up a new MySQL database and begin installing an app manually, or decide to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the requirements of the respective application. This will allow you to activate and manage InnoDB-specific applications without any predicaments and without the need to update any settings in your account. To avoid any risk, we’ll always have a 1-week-old backup of all your MySQL databases, so if you remove or alter any content by mistake, we can quickly retrieve it.
InnoDB in VPS Servers
If you order a VPS server from us, you will be able to use our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to run any open-source script-driven web application which requires InnoDB, as this particular storage engine is an essential part of the standard software bundle that will be installed on the Virtual Private Server during its configuration. When you set up a brand-new database through the hosting Control Panel, you just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the app in question requires it, so you won’t have to do anything else in your VPS account. Correspondingly, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
If you obtain a new dedicated server, you will be able to select any of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to add this storage engine manually to be able to use script-driven web apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage large-size Internet sites, it’s very likely that you will use InnoDB. You will be able to use other engines as well, so in case a certain application requires MyISAM instead of InnoDB, you won’t have to deal with any difficulty while managing it. The engine that will be used will be automatically recognized the moment the app installation starts, so you will not have to configure any settings manually whatsoever.