What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by well known open-source script-powered web apps such as Magento and Joomla™ 3.x. It is excellent for scalable applications, as it performs unbelievably well when processing huge data volumes. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same period of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that indicate how data imports and modifications should be treated. If a certain operation has not been entirely completed for any reason, the action will be rolled back. In this way, the database content will remain safe and sound and will not be partially merged with new content.
InnoDB in Shared Hosting
Every PHP script-powered web app that requires InnoDB will run flawlessly on our advanced cloud website hosting platform and the MySQL storage engine is available with all our shared hosting
plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s requirements without having to change any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll keep regular content backups, so in case you accidentally erase a database that is important to you or you overwrite some part of it, we’ll be able to restore the database the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the Control Panel included with all our semi-dedicated server
packages and you start installing a PHP-based web application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically depending on the given app’s requirements. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without the need for any manual action on your end at any time. To prevent any chance of losing info if you update an application or if you remove a database unintentionally, we’ll perform backups of all your MySQL databases each and every day, so if anything happens, we can retrieve your content.
InnoDB in VPS Servers
In case our in-house developed Hepsia hosting Control Panel is picked during the signup process for your new VPS plans
, InnoDB will be installed on the server together with other needed pieces of software, so you won’t have to do anything if you decide to run open-source script-driven software apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a new database and begin the app installation procedure manually or using our single-click installer. The system will automatically detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the app can dump its data in that database. Therefore, you can run applications with various prerequisites about the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans
that are ordered with our custom-built 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 will not need to install it manually if you wish to activate open-source scripts that require it. All it takes to activate such a script is to create a new database and to initiate the setup – once the installation wizard accesses the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to activate scripts that need the other widely used MySQL engine – MyISAM, so you will not have to update any settings on the server. This will allow you to use a variety of scripts on one single physical server and to use the latter to its maximum capacity.