InnoDB is a database engine for MySQL databases, which is used by popular PHP script-powered web apps like Joomla 3.x and Magento. It’s excellent for scalable applications, because it performs really well when managing enormous amounts of data. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can complete much more operations for the same period of time. Besides, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be treated. If a given operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved undamaged and won’t be partially mixed with newly inserted content.
InnoDB in Hosting
InnoDB is offered with all our hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any PHP-based web app which needs the storage engine without having to deal with any impediment once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation process, regardless of whether you use our 1-click installation tool or create the database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will generate daily backups of all your databases, so you can be sure that you’ll never lose any data if you erase a database unintentionally or you overwrite some essential information – you simply need to inform us and we will restore everything back to normal.
InnoDB in Semi-dedicated Servers
You can make use of a PHP script-driven software application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our cutting-edge cloud hosting platform where the database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer. In either case, the needed engine will be selected automatically the moment the application’s activation starts, so you will not need to configure anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. On top of that, we will always be able to restore any of your MySQL databases if you unintentionally erase one, as we generate a few database backups every day, each of which is stored for one week.
InnoDB in VPS Servers
In case our custom-developed Hepsia hosting Control Panel is picked during the signup process for your new VPS servers , InnoDB will be installed on the Virtual Private Server together with other essential pieces of software, so you will not have to do anything if you decide to run script-based applications that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a brand new database and begin the app installation manually or using our single-click installer. The system will detect the engine that the application in question needs and will set it for the specific database, so the installation will continue impeccably and the application can import its data into that database. In this way, you can make use of applications with different requirements concerning the MySQL engine without having to make any changes on your VPS.
InnoDB in Dedicated Servers
All dedicated servers ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually in case you would like to activate open-source PHP scripts that require it. All it takes to install such a script is to set up a new database and to start the installation process – once the installer wizard acquires access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to use scripts that need MyISAM, the other popular MySQL engine, so you won’t need to change any settings on the dedicated server. This will permit you to run various scripts on a single machine and to use the latter to its full capacity.