Find out more about InnoDB and see why it’s recently been selected as the default MySQL database engine.
InnoDB is a very popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has plenty of advantages that have made it the engine of choice for numerous script-driven software apps, such as Magento and Joomla™, which have switched over to InnoDB for good. For instance, importing large volumes of data will be faster with InnoDB, because it locks only one row to perform a certain task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. Simply put, appending new or editing existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case any problem appears in the meantime, which is why the content that remains in the database won’t be lost.
InnoDB in Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it is included in the standard set of services that we are offering with our website hosting
plans. If you’d like to make use of a script-powered application that needs InnoDB in particular, in order to be installed and to work properly, you will not need to deal with any impediments since the InnoDB storage engine is available on our in-house built cloud web hosting platform. Regardless of whether you create a brand new database and activate an application manually or use our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular application requires InnoDB rather than MyISAM. In addition to the outstanding database crash recovery that InnoDB is offering, we also carry out regular database backups, so that we can swiftly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
come with InnoDB and you can make use of all the features of this database storage engine with any PHP-based web application that needs it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the particular app’s prerequisites. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To avoid any risk, we will maintain daily backups of all your databases, so if anything goes wrong following some update or if you remove some content by accident, we’ll be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Servers
If you get a VPS server
from us, you’ll be able to make use of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to activate any open-source script-powered web app which needs InnoDB, as this MySQL database engine is an integral part of the default software package that will be pre-installed on your Virtual Private Server during its configuration. When you create a brand new MySQL database through the hosting Control Panel, you simply need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you will not need to do anything else in your VPS account. Correspondingly, if an app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers
When you acquire a new dedicated server
, you’ll be able to choose one of the 3 hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to add this database storage engine manually so as to be able to manage open-source script-driven apps that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you require in order to run large-size sites, it’s pretty possible that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain app requires MyISAM instead of InnoDB, you will not need to deal with any problem while using it. The engine that will be used will be detected automatically once the app installation starts, so you will not need to change any setting manually at any moment.