InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-based software applications such as Joomla v3 and Magento. It’s excellent for scalable applications, because it works exceptionally well when handling enormous data volumes. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can process much more operations for the same length of time. Plus, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that determine how data imports and modifications should be handled. In case a certain task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the content in the database will remain safe and sound and will not be partially merged with newly entered content.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other website hosting service providers, it’s an essential part of the default set of features that we are offering with our website hosting packages. If you’d like to make use of an open-source script-powered web app that needs InnoDB particularly, in order to be activated and to operate correctly, you won’t encounter any impediments since the MySQL database storage engine is available on our custom-developed cloud website hosting platform. Regardless of whether you create a brand-new MySQL database and activate an app manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also store regular database backups, so that we can swiftly recover any database in your shared website hosting account.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is one of the features which you can pick on the server order page when you buy a dedicated server from us. As this is the most powerful type of website hosting, it’s very likely that you will run popular Internet sites that will attract a lot of visitors, and since InnoDB is one of the very best choices for such sites, we will activate it together with all the other software apps that are available with a Hepsia-managed server. When you set up a new MySQL database in your dedicated account, there won’t be any activated storage engine until you start installing a PHP script, whether manually via your Internet browser or using the automatic script installer tool that is included in the Control Panel. The necessary engine will be automatically recognized and will be assigned to the database in question, so you can make use of scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to cope with any problem.