InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got plenty of pluses which make it the preferred engine for plenty of PHP script-driven web applications, including Joomla and Magento, which have shifted over to InnoDB for good. For example, importing large volumes of data will be faster with InnoDB, as it locks only one database row to accomplish a given operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is handled. In simpler words, importing new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a given issue appears during the process, which means that the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting companies, it is part of the default set of services offered with our shared web hosting packages. In case you would like to make use of a PHP script-based software application that requires InnoDB specifically, in order to be installed and to perform correctly, you won’t need to deal with any difficulties since the InnoDB database storage engine is available on our custom-built cloud platform. Regardless of whether you create a new MySQL database and activate an application manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also generate regular backups of all databases, so that we can easily recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can run a PHP-based software application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click app installer. Either way, the needed engine will be picked automatically the moment the activation of the app starts, so you won’t have to edit anything manually, no matter if the application requires InnoDB or the more regularly used MyISAM. Also, we will always be able to restore any of your MySQL databases if you delete one by accident, as we generate several MySQL database backups every day, each of which is preserved for 1 whole week.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you’ll be able to pick one of the 3 Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to activate this MySQL database engine manually to be able to manage script-driven software applications that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you need in order to run large-size Internet sites, it is pretty likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a particular app needs MyISAM rather than InnoDB, you will not encounter any complication while using it. The engine that will be used will be detected automatically as soon as the app installation process starts, so you won’t have to change any setting manually at any moment.