InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has numerous pluses that have made it the preferred engine for lots of PHP script-powered software applications, including Joomla and Magento, which have switched to InnoDB for good. For example, adding large data volumes will be much faster with InnoDB, since it locks only a single row to carry out a given task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is treated. Simply put, adding new or editing existent data will either be fully completed, or will be annulled and the operation will be rolled back in case a certain issue shows up during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many website hosting service providers, it is an essential part of the default set of features offered with our shared website hosting plans. If you wish to make use of a script-powered software application that needs InnoDB particularly, in order to be installed and to function correctly, you won’t face any obstacles as the MySQL storage engine is available on our in-house developed cloud hosting platform. No matter if you set up a new MySQL database and install an app manually or use our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective application needs it instead of MyISAM. Besides the remarkable database failure recovery that InnoDB is offering, we also carry out daily database backups, so we can swiftly recover any database in your shared web hosting account.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to select one of the 3 Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to enable this MySQL database engine manually to be able to run script-based software apps that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the resources that you need to run large-scale sites, it is quite likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a certain application requires MyISAM rather than InnoDB, you will not have any problem while managing it. The engine that will be used will be automatically detected when the app installation process commences, so you won’t have to fine-tune any settings manually at any point.