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 crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by numerous developers that build scalable web apps, as it works more efficiently with immense volumes of data, while it keeps the server load low. Furthermore, it locks only one database row if any info should be edited, whereas many other engines lock the entire database table and hence require much more time to handle multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla editions are two instances of popular PHP-driven web apps which have moved to InnoDB.

InnoDB in Shared Hosting

Any PHP script-based web application that needs InnoDB will run flawlessly on our avant-garde cloud hosting platform and the MySQL database engine comes with all our shared hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll perform regular content backups, so in case you accidentally delete a MySQL database that you need or you overwrite some part of it, we will be able to restore your database the way it was just a couple of hours earlier.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other needed pieces of software, so you won’t have to do anything if you decide to manage script-based software apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and start installing the application manually or using our single-click installer tool. The system will recognize which engine the app in question requires and will set it for the specific database, so the installation process will continue impeccably and the app can enter its data into that database. Thus, you can activate apps with different requirements in regard to the MySQL engine without making any modifications on your server.