What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by well known script-powered web apps like Joomla™ 3 and Magento. It’s perfect for scalable applications, since it performs really well when processing immense volumes of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. What’s more, InnoDB offers a much faster database failure recovery and supports database transactions and foreign key constraints – rules that define how data imports and modifications should be treated. In case a specific operation has not been fully completed for any reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and won’t be partially mixed with newly imported content.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared hosting plans
by default, not as a paid upgrade or upon request, so you can activate and manage any open-source script-driven software application which needs the storage engine without the need to deal with any obstacle as soon as you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation process, no matter if you use our 1-click installer or create the database and install the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily database backups, so you can be sure that you’ll never lose any data in case you delete a database by mistake or you overwrite some key information – you’ll simply need to notify us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Servers
You can run a PHP-driven web application that needs InnoDB with all of our semi-dedicated server
packages, because all the accounts are created on our leading-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click app installer. Either way, the needed engine will be picked automatically once the application’s activation starts, so you won’t need to edit anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you erase one by mistake, as we make a couple of MySQL database backups every day, each of which is preserved for one week.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is picked during the registration process for your new VPS web hosting plans
, InnoDB will be activated on the Virtual Private Server together with other essential software, so you won’t have to do anything if you decide to install open-source script-driven apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new MySQL database and begin installing the application manually or using our one-click installation tool. The system will detect which engine the particular app needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the app can insert its data into that database. In this way, you can run apps with various requirements about the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options which you can choose on the server configuration page when you purchase a dedicated server
from our company. Since this is the most powerful kind of hosting, it’s quite likely that you’ll manage popular websites that will draw plenty of visitors, and since InnoDB is one of the best choices for such websites, we’ll install it along with all the other software apps that are available with a Hepsia-managed dedicated server. If you set up a brand new database in your dedicated server account, there won’t be any activated MySQL database engine till you begin installing an open-source PHP script, whether manually via your browser or using the automatic script installation tool that is integrated into the hosting Control Panel. The necessary engine will be recognized and will be set for that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without any complication.