InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is preferred by lots of devs that run scalable applications, as it works much better with enormous data volumes, while it keeps the server load at a minimum. Also, it locks only one database row if any info should be edited, while many other engines lock the entire table and therefore require much more time to perform several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest releases of Joomla are two instances of popular open-source script-based applications that have moved to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting companies, it is included in the standard set of features that we’re offering with our cloud hosting plans. In case you want to make use of a PHP-powered app that needs InnoDB in particular, in order to be activated and to work correctly, you will not experience any difficulties because the MySQL database engine is available on our in-house developed cloud Internet hosting platform. Irrespective of whether you set up a brand new database and install an app manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires InnoDB rather than MyISAM. In addition to the exceptional database crash recovery offered by InnoDB, we also perform daily database backups, so we can swiftly recover any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server accounts and you start installing a PHP-driven software app either manually or using our one-click application installer tool, the database storage engine will be picked automatically based on the prerequisites of the particular app. As InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual action needed on your end at any time. To avoid any risk of losing information if you update an app or if you delete a database accidentally, we’ll generate a backup of all your databases each and every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Servers

When you acquire a VPS server from us, you will be able to take full advantage of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to activate any PHP-based app that needs InnoDB, as the MySQL storage engine is part of the default software bundle that will be pre-installed on your Virtual Private Server during its creation. When you set up a brand-new MySQL database through the Control Panel, you simply need to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine as long as the app in question needs it, so you won’t have to do anything else in your VPS account. Likewise, if an application requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features which you can choose on the order page when you purchase a dedicated server from us. As this is the most powerful type of website hosting, it’s rather likely that you will run popular sites that will attract plenty of individuals, and since InnoDB is one of the best choices for such sites, we’ll activate it along with all the other software applications that are available with a Hepsia-equipped server. If you set up a new MySQL database in your dedicated account, there won’t be any activated MySQL storage engine till you start installing a script, whether manually through your browser or using the automatic script installer tool that is integrated into the Control Panel. The needed engine will be automatically recognized and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without any problem.