InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has many pluses which make it the engine of choice for lots of PHP-driven software apps, including Joomla and Magento, which have switched to InnoDB permanently. For example, importing huge volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a certain operation, 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 data is treated. Simply put, adding new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back in case any problem shows up in the meantime, which is why the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with other website hosting service providers, it is part of the default set of features that we’re offering with our cloud hosting packages. In case you’d like to make use of a PHP script-driven web application that needs InnoDB particularly, in order to be installed and to operate correctly, you will not encounter any obstacles as the InnoDB database storage engine is available on our custom-built cloud Internet hosting platform. Irrespective of whether you set up a brand-new MySQL database and install an application manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs it instead of MyISAM. In addition to the outstanding database failure recovery that InnoDB offers, we also carry out daily database backups, so we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated plans include InnoDB and you’ll be able to make the most of all the options offered by this MySQL database storage engine with any PHP script-driven software app that needs it. It is one of the engines that we have on our cloud hosting platform, so the one that will be used depends on the requirements of the app in question. You will not 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 single-click app installer tool. To avoid any risk, we will maintain regular backups of all your MySQL databases, so if anything goes wrong after some update or if you remove some data by mistake, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is picked during the signup process for a new VPS plans , InnoDB will be activated on the VPS server together with other essential software, so you will not have to do anything if you choose to manage script-based applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a brand new MySQL database and begin the app installation manually or through our single-click installer tool. The system will recognize the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can enter its content into that database. In this way, you can manage apps with various requirements about the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

If you order a new dedicated server, you’ll be able to pick one of the 3 Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this storage engine manually so as to be able to use script-based web applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you require to run large-size sites, it’s quite likely that you will use InnoDB. You will be able to use other engines as well, so in case a given application needs MyISAM instead of InnoDB, you won’t need to deal with any complication while using it. The engine that will be used will be automatically detected when the app installation process commences, so you will not have to edit any settings manually at any point.