Learn more about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP-based web applications like Joomla™ 3.x and Magento. It’s excellent for scalable apps, since it works incredibly well when processing large volumes of data. Rather than locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same period of time. Furthermore, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be treated. In case a specific operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will remain undamaged and won’t be partially mixed with new content.
InnoDB in Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it’s an integral part of the standard set of services that we offer with our hosting
plans. If you would like to make use of a script-based software app that requires InnoDB specifically, in order to be installed and to work correctly, you won’t experience any difficulties because the database engine is available on our in-house developed cloud web hosting platform. No matter if you create a new MySQL database and activate an app manually or use our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it rather than MyISAM. Besides the exceptional database crash recovery that InnoDB offers, we also keep regular backups of all databases, so that we can easily restore any MySQL database in your shared hosting account.
InnoDB in VPS
In case our custom Hepsia hosting Control Panel is picked during the registration process for your new Linux virtual private servers
, InnoDB will be installed on the Virtual Private Server along with other needed pieces of software, so you will not have to do anything if you choose to make use of open-source script-driven software apps that require this MySQL storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a new database and begin the app installation manually or using our single-click installation tool. The system will automatically recognize which engine the particular app requires and will assign it to the specific database, so the installation process will proceed impeccably and the app can dump its content in that database. In this way, you can use applications with different requirements with regard to the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is one of the options which you can pick on the server order page when you buy a dedicated server
from us. Since this is the most powerful kind of web hosting, it is rather likely that you will run popular websites that will attract many visitors, and since InnoDB is one of the best options for such websites, we’ll activate it along with all the other software apps that come with a Hepsia-managed server. If you create a brand new MySQL database in your dedicated account, there won’t be any active storage engine until you begin installing a PHP script, whether manually through your Internet browser or using the automatic script installer tool that is available in the hosting Control Panel. The required engine will be detected and will be set for that database, so you can run scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without running into any difficulty.