InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and a faster database crash recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of developers that run scalable software applications, since it works much more effectively with immense amounts of data, while it keeps the server load low. Also, it locks only a single row in the database if any information should be modified, whereas many other engines lock the entire table and hence require much more time to accomplish several successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed for any reason, the action is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ versions are two instances of popular open-source script-based web applications which have moved to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an essential part of the default set of services that we offer with our hosting plans. In case you’d like to make use of an open-source script-driven app that requires InnoDB specifically, in order to be activated and to work correctly, you won’t face any difficulties since the InnoDB database storage engine is available on our custom cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. In addition to the amazing crash recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can easily restore any database in your shared web hosting account.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to pick any of the three Control Panels offered by us – Hepsia and cPanel. Any server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to activate this database engine manually in order to be able to run open-source script-based software apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require in order to manage large-size Internet sites, it is rather possible that you’ll resort to InnoDB. You’ll be able to use other engines too, so in case a given application needs MyISAM rather than InnoDB, you will not run into any difficulty while using it. The engine that will be used will be automatically recognized once the app installation commences, so you won’t have to change any setting manually at any time.