InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by numerous programmers that build scalable software apps, since it works much more effectively with enormous amounts of data, while it keeps the server processing load low. What’s more, it it locks only one row in the database if any info should be edited, whereas many other engines lock the entire table and hence need more time to handle multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest Joomla™ editions are two examples of widespread PHP-driven software apps that have moved to InnoDB.

InnoDB in Web Hosting

You can run any open-source script-based software application that requires InnoDB if you have a web hosting plan with us, as the MySQL database storage engine is present on our innovative cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can install apps which require the MyISAM engine without encountering any obstacle as well and, once again, the engine will be selected automatically, so you won’t have to change anything manually at any point. On top of that, we’ll also create daily backups of all the MySQL databases that you’ve got in your shared account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

If you order a new dedicated server, you’ll be able to pick one of the three Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to enable this database engine manually to be able to manage PHP-based applications that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require in order to run very large sites, it’s rather likely that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a particular application requires MyISAM instead of InnoDB, you won’t experience any complication while managing it. The engine that will be used will be detected automatically as soon as the app installation procedure begins, so you will not need to update any settings manually at any point.