InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved crash recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of developers that build scalable web apps, because it works much more efficiently with large volumes of data, while it keeps the server processing load low. Additionally, it uses row-level locking if any information should be modified, while lots of other engines lock the entire table and hence require more time to handle several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest Joomla™ versions are two instances of widely used script-driven web apps that have switched to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it is part of the default set of features that we are offering with our shared hosting packages. In case you would like to make use of a PHP script-based web app that requires InnoDB specifically, in order to be activated and to perform properly, you won’t encounter any difficulties since the InnoDB database engine is available on our custom cloud platform. Regardless of whether you set up a brand new database and activate an application manually or take advantage of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the app requires InnoDB instead of MyISAM. In addition to the incredible crash recovery offered by InnoDB, we also perform regular backups of all databases, so that we can easily restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel included with each of our semi-dedicated server accounts and you begin installing a PHP-driven software application either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically based on the requirements of the given app. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any application that needs it without the need for any manual action on your end at any moment. To prevent 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 MySQL databases each day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Web Hosting

If our in-house built Hepsia Control Panel is picked during the registration process for your new Linux VPS web hosting packages , InnoDB will be activated on the VPS server together with other needed software, so you won’t need to do anything if you decide to run script-driven apps that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a brand new database and begin the app installation process manually or through our single-click installation tool. The system will recognize which engine the app in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can insert its content into that database. Therefore, you can use apps with different requirements about the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

InnoDB comes as standard with all dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is ready, you will be able to sign in and to install any kind of PHP script-powered application that needs this database storage engine. If you set up a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. As soon as the app configuration wizard begins entering information into the newly created database, the engine will be chosen automatically on the basis of the requirements of the given app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any point. Thus, you can use an immense variety of apps for your Internet sites.