InnoDB is a popular database storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has plenty of pluses which have made it the engine of choice for lots of PHP-based software applications, including Magento and Joomla, which have switched over to InnoDB for good. For example, importing large volumes of data will be faster with InnoDB, because it locks only a single database row to complete a specific operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. In simpler words, importing new or editing existent data will either be fully completed, or will be canceled and the operation will be rolled back in case any issue appears during the process, hence the content that remains in the database won’t be damaged.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it is an integral part of the standard set of features that we are offering with our hosting plans. If you’d like to use a PHP script-driven web app that requires InnoDB specifically, in order to be installed and to operate properly, you will not encounter any impediments because the InnoDB database engine is available on our in-house built cloud platform. Irrespective of whether you create a brand new database and activate an app manually or use our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the application requires it instead of MyISAM. Besides the amazing database failure recovery that InnoDB is offering, we also make daily database backups, so that we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans include InnoDB and you can make use of all the options offered by this MySQL database storage engine with any PHP-powered web app that needs it. InnoDB is one of the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the app in question. You won’t need to do anything manually to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To be on the safe side, we’ll maintain regular database backups, so if something goes wrong following an update or if you remove some data by accident, we will be able to restore the database the way it was on any of the past seven days.

InnoDB in VPS Servers

If our in-house developed Hepsia Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server together with other necessary software, so you will not need to do anything if you choose to activate script-driven applications that require this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand-new MySQL database and begin installing the application manually or using our 1-click installer. The system will detect the engine that the app in question requires and will set it for the specific MySQL database, so the installation process will continue impeccably and the application can dump its content in that database. Thus, you can activate apps with different prerequisites with regard to the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated servers ordered with the Hepsia Control Panel. It is included in the default software package that will be pre-installed on all Hepsia-equipped servers, so once your physical machine is set up, you will be able to log in and to activate any type of open-source script-powered software application that needs this particular database engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine until you start installing an app. Once the app activation wizard starts importing data into the newly created database, the engine will be set automatically on the basis of the requirements of the application in question, so you can run both InnoDB and MyISAM without selecting either of them explicitly at any time. In this way, you can use a broad collection of applications for your sites.