InnoDB is a storage engine for MySQL databases, which is used by well known script-powered software apps such as Magento and Joomla™ 3. It’s excellent for scalable applications, since it excels in managing immense volumes of data. Instead of locking the whole database table to append new information to 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. In addition, InnoDB offers a faster database failure recovery and supports transactions and foreign keys – a set of rules that define how data imports and modifications should be treated. In case a particular task hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved undamaged and will not be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting service by default, not as a paid upgrade or upon request, so you can install and manage any script-based application which needs the MySQL storage engine without the need to deal with any difficulty as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, irrespective of whether you take advantage of our one-click installation tool or create the database and activate the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data if you erase a database unintentionally or you overwrite some important info – you will just need to notify us and we will restore your database back to normal.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting service include InnoDB and you will be able to use all the features of this database storage engine with any open-source script-based software app that needs it. It’s among the engines that we have on our cloud platform, so the one that will be picked depends on the prerequisites of the respective app. You won’t need to do anything manually to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To avoid any risk, we will store regular MySQL database backups, so if anything goes wrong following an update or if you remove some data by accident, we’ll be able to get your database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the software pack that will be installed on your server before we hand it over to you. You won’t need to set up anything manually and you will be able to install and run any open-source script-powered application that needs InnoDB when your VPS server is ready, which takes no more than one hour after the order submission procedure itself. A couple of engines are offered, so anytime you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be selected once the app activation commences and our system will automatically detect the engine that is required by the app in question. If you have to use MyISAM, for example, you won’t need to do anything different than installing the chosen application, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
All Linux dedicated servers ordered with our custom-built Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually if you wish to run open-source PHP scripts that need it. All it takes to run such a script is to set up a new database and to initiate the installation – once the installer wizard gets access to the database in question and begins entering content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to run scripts that require the other popular MySQL engine – MyISAM, so you won’t need to edit any settings on the server. This will permit you to use various scripts on a single server and to use it to its fullest potential.