Learn what a database engine is, what are the benefits of the InnoDB engine and why it is gaining a huge amount of worldwide popularity.
InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-driven web applications such as Magento and Joomla™ v3. It’s perfect for scalable applications, as it performs amazingly well when managing immense volumes of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same length of time. Also, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and updates should be handled. In case a given operation hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved intact and won’t be partially mixed with newly imported content.
InnoDB in Cloud Hosting
InnoDB is offered with all our Linux cloud hosting
by default, not upon request or as a paid upgrade, so you’ll be able to install and run any script-driven app that requires the InnoDB storage engine without having any problem as soon as you activate your shared account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation process, irrespective of whether you make use of our one-click installer or create the MySQL database and set up the app manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll perform daily backups of all your MySQL databases, so you can be sure that you will never lose any data in case you delete a database accidentally or you overwrite some crucial information – you will just have to touch base with us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
You can activate an open-source script-driven web application that requires InnoDB with all of our semi-dedicated server
packages, since all the accounts are set up on our avant-garde cloud web hosting platform where the database engine is installed. A new MySQL database can be created in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our single-click application installer. Either way, the needed engine will be selected automatically as soon as the activation of the app begins, so you will not have to edit anything manually, regardless of whether the application needs InnoDB or the more widely used MyISAM. Furthermore, we will always be able to restore any of your databases if you accidentally remove one, as we create several backups every day, each of which is preserved for one whole week.
InnoDB in Dedicated Servers Hosting
If you buy a new dedicated server
, you’ll be able to pick any of the three hosting Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to activate this MySQL database storage engine manually so as to be able to use PHP-driven web apps that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the system resources that you need to run large-size websites, it’s quite possible that you will use InnoDB. You’ll be able to make use of other engines as well, so in case a given application needs MyISAM instead of InnoDB, you will not encounter any complication while using it. The engine that will be used will be automatically detected as soon as the app installation procedure begins, so you won’t have to change any settings manually at any time.