InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved crash recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is endorsed by many devs that run scalable apps, as it works more efficiently with huge amounts of data, while it keeps the server load low. In addition, it locks only a single row in the database in case anything should be edited, whereas lots of other engines lock the entire database table and therefore require more time to carry out multiple sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for some reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest Joomla versions are two instances of famous open-source script-powered software platforms that have switched over to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting providers, it is an integral part of the default set of services that we’re offering with our website hosting plans. If you wish to use a PHP script-driven software app that needs InnoDB in particular, in order to be activated and to function properly, you won’t encounter any impediments as the MySQL database engine is available on our custom cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or make use of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the excellent crash recovery that InnoDB is offering, we also keep regular backups of all databases, so we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel provided with all our semi-dedicated server packages and you begin installing a PHP-powered software application either manually or using our one-click application installer tool, the storage engine for the database will be picked automatically on the basis of the specific app’s prerequisites. As InnoDB is present on the cloud platform where your new account will be created, it will be set as the default engine for each application that requires it without any manual action required on your end at any point. To avoid any risk of losing information if you update an app or if you remove a database accidentally, we’ll perform backups of all your MySQL databases every day, so if anything goes wrong, we can restore your data.

InnoDB in VPS

All Linux VPS packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to run any open-source script-driven web app that needs this storage engine without configuring anything manually. You can choose Hepsia on the VPS order page and your brand-new VPS server will be up and running within the hour, so you can log in and start setting up your websites right away. Once you set up a new database and begin the app activation process, our system will pick the engine for this database automatically. In this way, you can activate different applications at the same time without the need to configure anything on the VPS server. You can have a WordPress personal journal that uses MyISAM – the default MySQL engine, and a Magento-powered e-store that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Hosting

InnoDB is available as standard with all dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s part of the default software package that we install on all Hepsia-managed servers, so as soon as your physical machine is ready, you’ll be able to log in and to activate any script-driven app that requires this particular MySQL database storage engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine until you begin installing an app. Once the app setup wizard starts entering information into the newly created database, the engine will be selected automatically on the basis of the prerequisites of the specific app, so you can use both InnoDB and MyISAM without selecting either of them explicitly at any moment. Thus, you can use an immense selection of applications for your sites.