InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP-based web apps such as Joomla 3 and Magento. It’s perfect for scalable apps, because it performs exceptionally well when handling immense data volumes. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same period of time. What’s more, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and updates should be treated. If a certain operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and won’t be partially merged with newly added content.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it is included in the standard set of services that we offer with our web hosting packages. If you’d like to make use of an open-source script-powered software app that requires InnoDB particularly, in order to be activated and to work correctly, you won’t encounter any impediments as the InnoDB database engine is available on our custom cloud platform. Regardless of whether you create a new MySQL database and activate an application manually or use our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the given app needs it rather than MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also keep daily database backups, so we can swiftly recover any database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you start installing a PHP script-based web app either manually or using our one-click app installer, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the specific application. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each application that requires it without the need for any manual intervention on your end at any time. To prevent any risk of losing data if you update an application or if you erase a database accidentally, we will make backups of all your MySQL databases every day, so if anything happens, we can recover your content.

InnoDB in VPS Web Hosting

If you obtain a virtual private server from our company, you will be able to take full advantage of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will permit you to activate any open-source script-driven app that requires InnoDB, as this database engine is part of the standard software bundle that will be pre-installed on the server during its configuration. When you create a brand new database using the Control Panel, you’ll simply need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question requires it, so you will not need to do anything else in your VPS account. Identically, if a certain application needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers Hosting

Our Hepsia Control Panel is among the options that you can choose on the server configuration page when you purchase a dedicated server from our company. Since this is the most powerful kind of website hosting, it is very likely that you will manage highly popular sites that will attract many individuals, and since InnoDB is one of the very best choices for such websites, we’ll activate it along with all the other software apps that come with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your account, there won’t be any activated database engine until you begin installing a script, whether manually through your browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The required engine will be recognized automatically and will be assigned to that database, so you can run scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having to cope with any problem.