InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of developers that build scalable apps, due to the fact that it works much better with immense data volumes, while it keeps the server processing load low. Also, it it locks only one row in the database in case any info should be updated, while lots of other engines lock the entire table and therefore require more time to carry out several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest Joomla editions are two instances of widely used script-powered software applications that have moved to InnoDB.

InnoDB in Cloud Hosting

You will be able to activate any script-based software application that needs InnoDB in case you’ve got a Linux cloud hosting with our company, as the MySQL storage engine is present on our advanced cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can install applications which require the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be selected automatically, so you won’t need to edit any setting manually at any time. On top of that, we’ll also generate regular backups of all the databases that you have in your shared web hosting account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting services come with InnoDB and you’ll be able to take advantage of all the features offered by this MySQL storage engine with any PHP script-driven web application that requires it. It is one of the engines that are available on our cloud platform, so the one that will be picked depends on the prerequisites of the particular app. You will not have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click application installer. To avoid any risk, we’ll make regular database backups, so if something goes wrong after an update or if you remove some data by accident, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS Web Hosting

All Linux VPS web hosting services that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-driven application that needs the MySQL storage engine without needing to set up anything manually. You can choose Hepsia on the VPS order form and your brand-new server will be set up within one hour, so you can log in and begin setting up your Internet sites right away. When you set up a brand new MySQL database and start the app installation process, our system will choose the engine for that database automatically. In this way, you can manage different applications simultaneously without the need to update anything on the server. You can set up a WordPress-powered personal journal that makes use of MyISAM – the default MySQL engine, and a Magento online shopping portal that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers Hosting

All dedicated servers hosting ordered with our custom-built Hepsia Control Panel include a software package that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to add it manually in case you need to use scripts that require it. All it takes to run such a script is to set up a new database and to initiate the installation process – once the installer wizard accesses the database and starts importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you will not need to configure any settings on the server. This will allow you to use various scripts on a single machine and to use it to its full capabilities.