InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a much better overall performance and an improved crash recovery compared with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of devs that create scalable applications, due to the fact that it works much better with immense data volumes, while it keeps the server load low. Also, it locks only a single row in the database in case anything should be edited, while many other engines lock the entire database table and hence require more time to handle several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest releases of Joomla are two examples of popular PHP-based apps that have moved to InnoDB.

InnoDB in Cloud Hosting

Every PHP script-based app that requires InnoDB will function impeccably on our avant-garde cloud web hosting platform and the MySQL database storage engine is offered with all our cloud hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to update any setting in your hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We’ll carry out regular content backups, so in case you accidentally remove a database that’s important to you or you overwrite certain parts of it, we’ll be able to restore your content the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with all our Linux semi-dedicated packages by default, so as soon as you get a new semi-dedicated account, you can go on and activate any PHP-driven application that requires this storage engine. A few engines are installed on our cloud platform, so when you create a new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be set on the basis of the requirements of the particular app. This will permit you to install and manage InnoDB-specific applications without needing to cope with any complication and without needing to update any settings in your semi-dedicated account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you remove or change any content accidentally, we can easily retrieve it.

InnoDB in Dedicated Hosting

If you buy a new dedicated server, you will be able to select one of the 3 hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to install this database storage engine manually to be able to manage open-source script-powered apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you need to manage large-scale websites, it is quite possible that you will use InnoDB. You’ll be able to make use of other engines too, so in case a certain app needs MyISAM rather than InnoDB, you won’t need to deal with any impediment while using it. The engine that will be used will be automatically recognized the moment the app installation process starts, so you will not have to tweak any settings manually whatsoever.