InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous web developers that build highly scalable web applications, because it works much more efficiently with enormous data volumes, while it keeps the server processing load low. Additionally, it uses row-level locking in case any information should be modified, whereas many other engines lock the entire table and thus need much more time to execute multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification cannot be completed for any reason, the operation is rolled back to prevent scrambling or losing data. Magento and the latest releases of Joomla are two instances of famous open-source script-based applications that have switched to InnoDB.

InnoDB in Hosting

Any PHP-driven web app that requires InnoDB will run impeccably on our innovative cloud web hosting platform and the MySQL database engine is offered with all our hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected based on the app’s prerequisites without the need to change any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We’ll perform daily content backups, so in case you unintentionally delete a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore the database the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database through the Control Panel included with each of our semi-dedicated server packages and you start installing a script-driven application either manually or using our one-click application installer, the database storage engine will be set automatically depending on the prerequisites of the particular application. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any moment. To avoid any chance of losing information if you update an application or if you delete a database by accident, we will make a backup of all your MySQL databases every day, so if something goes wrong, we can recover your content.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any PHP script-driven software application that requires this particular database storage engine without the need to configure anything manually. You can pick Hepsia on the VPS order form and your new Virtual Private Server will be ready within 60 minutes, so you can sign in and begin creating your web sites right away. Once you set up a new database and start the app installation process, our system will choose the engine for that database automatically. In this way, you can run different applications simultaneously without editing anything on the VPS server. You can have a WordPress-driven personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-powered e-commerce site that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

InnoDB is included by default with all Linux dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s an essential part of the standard software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is up and running, you’ll be able to log in and to activate any open-source script-driven application that requires this storage engine. When you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you start installing an application. Once the app installation wizard starts dumping content in the newly created database, the engine will be selected automatically depending on the requirements of the given app, so you can run both MyISAM and InnoDB without the need to select either one of them explicitly at any time. Therefore, you can make use of a huge variety of applications for your websites.