Find out about InnoDB and find out why it’s been selected as the default MySQL database engine.
InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got lots of pluses that make it the preferred engine for lots of PHP-based web applications, including Joomla™ and Magento, which have switched to InnoDB for good. For instance, adding huge amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to perform a certain task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. Simply put, adding new or updating existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any issue shows up in the meantime, thus the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many web hosts, it’s an integral part of the default set of services that we’re offering with our shared hosting
packages. In case you’d like to make use of a script-based software application that requires InnoDB particularly, in order to be installed and to perform correctly, you will not encounter any problems because the MySQL database engine is available on our in-house built cloud website hosting platform. No matter if you create a brand-new MySQL database and activate an application manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB instead of MyISAM. Besides the excellent database failure recovery that InnoDB is offering, we also carry out regular database backups, so that we can quickly recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
You can install a PHP script-powered web application that needs InnoDB with any of our semi-dedicated server
plans, since all the accounts are created on our advanced cloud hosting platform where the database storage engine is installed. A new 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 1-click application installer. Either way, the needed engine will be selected automatically the moment the installation of the app begins, so you will not need to edit anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases in case you erase one by accident, as we make a few backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
When you buy a VPS server
from us, you’ll be able to take full advantage of our custom Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to activate any open-source script-powered app that needs InnoDB, as the MySQL storage engine is included in the standard software package that will be pre-installed on the VPS server during its creation. When you create a new MySQL database through the hosting Control Panel, you simply need to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine as long as the app in question needs it, so you will not need to do anything else in your account. Analogously, if a given app needs MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Servers
When you buy a new dedicated server
, you will be able to choose any of the three Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to activate this database storage engine manually so as to be able to use open-source script-powered web apps that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the system resources that you need to manage large-scale Internet sites, it’s quite possible that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a certain app requires MyISAM rather than InnoDB, you won’t need to deal with any difficulty while managing it. The engine that will be used will be detected automatically the moment the app installation process starts, so you won’t have to edit any setting manually at any point.