InnoDB is a storage engine for MySQL databases, which is used by widespread PHP-driven software applications such as Joomla™ 3 and Magento. It’s excellent for scalable applications, because it works amazingly well when handling huge volumes of data. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same period of time. Besides, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. If a certain operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be kept intact and won’t be partially mixed with newly inserted content.
InnoDB in Hosting
InnoDB is available with all our hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-based application that needs the database storage engine without any obstacles once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation process, regardless of whether you take advantage of our single-click installation tool or create the database and install the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will store regular backups of all your MySQL databases, so you can be certain that you won’t ever lose any data if you erase a database accidentally or you overwrite some vital info – you will just have to alert us and we’ll restore the database back to normal.
InnoDB in Semi-dedicated Servers
You can make use of an open-source script-based web application that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our advanced cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our single-click app installer. Either way, the required engine will be chosen automatically once the installation of the app starts, so you will not have to configure anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you accidentally erase one, as we create a couple of backups every day, each of which is saved for 7 days.
InnoDB in VPS Servers
If you buy a VPS server from us, you’ll be able to take full advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to run any PHP script-powered app which requires InnoDB, as this database storage engine is an essential part of the default software bundle that will be pre-installed on your VPS server during its creation. When you create a brand-new database through the hosting Control Panel, you’ll simply need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the app in question requires it, so you will not have to do anything else in your account. Equivalently, if a given application needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually in case you want to use PHP scripts that require it. All it takes to activate such a script is to create a new database and to initiate the installation process – as soon as the installer wizard gains access to the database in question and starts entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that need the other popular MySQL engine – MyISAM, so you won’t have to update any settings on the dedicated server. This will enable you to use various scripts on one single physical server and to use the latter to its fullest capacity.