InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that write highly scalable applications, since it works better with huge amounts of data, while it keeps the server load low. Furthermore, it locks only one database row in case any information should be updated, whereas lots of other engines lock the entire database table and hence require more time to carry out multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest releases of Joomla are two examples of famous PHP-powered software apps which have switched over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many other hosting companies, it’s an integral part of the default set of features that we’re offering with our cloud hosting packages. If you wish to use a PHP script-driven software application that needs InnoDB in particular, in order to be activated and to function correctly, you won’t have any obstacles because the InnoDB database storage engine is available on our custom-built cloud hosting platform. Irrespective of whether you create a brand new database and install an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given app requires it rather than MyISAM. Besides the amazing crash recovery that InnoDB offers, we also make daily backups of all databases, so that we can quickly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting include InnoDB and you’ll be able to take full advantage of all the features of this database engine with any PHP-powered web application that requires it. It’s one of the engines that we have on our cloud hosting platform, so the one that will be used depends on the prerequisites of the particular app. You will not need to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To avoid any risk, we will keep daily database backups, so if something goes wrong following some update or if you delete some data accidentally, we will be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Web Hosting

In case our custom-built Hepsia hosting Control Panel is chosen during the registration process for a new Linux VPS web hosting packages , InnoDB will be activated on the Virtual Private Server along with other necessary software, so you won’t need to do anything if you choose to make use of PHP-driven software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a brand new MySQL database and begin the app installation procedure manually or through our one-click installation tool. The system will detect the engine that the particular app requires and will set it for the specific database, so the installation will proceed impeccably and the application can enter its data into that database. Thus, you can use apps with various prerequisites in regard to the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is among the features that you can choose on the server configuration page when you buy a dedicated server from us. Since this is the most powerful kind of hosting, it is pretty likely that you’ll manage popular Internet sites that will draw lots of people, and since InnoDB is among the best choices for such Internet sites, we will enable it together with all the other software applications that are available with a Hepsia-managed dedicated server. If you set up a brand new MySQL database in your dedicated account, there won’t be any active storage engine until you begin installing a PHP script, whether manually via your web browser or using the automatic script installation tool that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to the database in question, so you can activate scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without encountering any problem.