InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a much better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by plenty of web developers that run highly scalable applications, as it works more effectively with immense volumes of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case anything should be updated, while many other engines lock the entire table and therefore need more time to perform multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest editions of Joomla are two instances of famous PHP-powered apps that have moved to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s an essential part of the standard set of features that we are offering with our shared website hosting packages. In case you would like to use an open-source script-driven software app that requires InnoDB in particular, in order to be activated and to function properly, you will not need to deal with any problems as the MySQL database storage engine is available on our custom-built cloud website hosting platform. Irrespective of whether you create a brand new database and activate an application manually or make use of our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires it rather than MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also generate daily database backups, so that we can swiftly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our Linux semi-dedicated servers by default, so the moment you buy a new account, you can go on and activate any script-driven app that needs this MySQL storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a brand new database and begin installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked depending on the respective app’s requirements. This will allow you to install and manage InnoDB-specific applications without running into any complication and without the need to edit any settings in your semi-dedicated account. To take no chances, we’ll always have a one-week-old backup of all your MySQL databases, so if you delete or alter any content by mistake, we can quickly retrieve it.

InnoDB in VPS Servers

If our in-house developed Hepsia Control Panel is selected during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server together with other essential software, so you won’t have to do anything if you choose to manage script-driven software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new database and start the app installation manually or through our single-click installation tool. The system will recognize which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its content into that database. Thus, you can activate apps with various requirements in regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is included in the default software package that will be installed on all Hepsia-managed servers, so once your machine is ready, you’ll be able to sign in and to activate a various open-source script-based web app that needs this storage engine. If you create a new database via the Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app setup wizard begins inserting information into the database, the engine will be selected automatically depending on the particular app’s requirements, so you can run both InnoDB and MyISAM without selecting either of them specifically at any time. Thus, you can use a wide selection of applications for your Internet sites.