InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has a number of advantages which have made it the engine of choice for lots of PHP-powered software applications, such as Joomla and Magento, which have switched over to InnoDB for good. For instance, importing large data volumes will be much faster with InnoDB, because it locks only a single row to carry out a given task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, importing new or editing existing data will either be fully completed, or will be canceled and the operation will be rolled back if any issue occurs during the process, so the content that remains in the database won’t be lost.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s an integral part of the standard set of services that we are offering with our hosting packages. If you would like to use an open-source script-powered software app that needs InnoDB in particular, in order to be installed and to function correctly, you will not experience any problems because the MySQL database engine is available on our in-house built cloud web hosting platform. No matter if you create a brand-new database and activate an application manually or take advantage of our single-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the particular app needs InnoDB instead of MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also store daily database backups, so that we can quickly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can activate a PHP-driven software application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud hosting platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click app installer tool. In either case, the required engine will be picked automatically as soon as the application’s installation begins, so you won’t have to update anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you erase one by accident, as we perform several database backups every day, each of which is kept for one whole week.

InnoDB in VPS Servers

When you obtain a VPS server from our company, you will be able to take advantage of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to install any PHP script-driven app which needs InnoDB, as the database engine is an essential part of the standard software package that will be pre-installed on the VPS server during its creation. When you create a new database through the Control Panel, you just need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine as long as the application in question requires it, so you will not need to do anything else in your account. Correspondingly, if an application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to add this database engine manually in order to be able to manage open-source script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need to manage large-size Internet sites, it is quite likely that you will use InnoDB. You will be able to make use of other engines too, so in case a specific app requires MyISAM instead of InnoDB, you won’t need to deal with any difficulty while managing it. The engine that will be used will be automatically recognized once the app installation procedure starts, so you won’t have to modify any setting manually at any point.