InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-powered web applications such as Magento and Joomla v3. It’s perfect for scalable apps, because it works remarkably well when handling enormous amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more tasks for the same period of time. Plus, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be treated. In case a given task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the content in the database will remain undamaged and won’t be partially merged with new content.

InnoDB in Shared Web Hosting

InnoDB is available with all our Linux shared web hosting services by default, not as a paid upgrade or upon request, so you can activate and manage any script-driven software app that needs the MySQL storage engine without encountering any problem as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app activation process, regardless of whether you take advantage of our single-click installer or create the MySQL database and activate the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will make daily database backups, so you can rest assured that you won’t ever lose any data in case you delete a database accidentally or you overwrite some important information – you will simply need to alert us and we will restore your content back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is included with all our Linux semi-dedicated hosting services by default, so the moment you create a new semi-dedicated account, you can move on and install any PHP-driven web app that needs this MySQL database storage engine. Several engines are installed on our cloud hosting platform, so when you set up a brand-new MySQL database and start installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be picked in accordance with the respective app’s requirements. This will allow you to activate and run InnoDB-specific apps without the need to deal with any impediment and without the need to edit any settings in your account. To take no chances, we’ll always have a seven-day-old backup of all your databases, so if you erase or alter any content accidentally, we can easily restore it.

InnoDB in VPS

When you obtain a virtual private server from us, you will be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to use any open-source script-driven web app that requires InnoDB, as this MySQL database storage engine is an integral part of the default software bundle that will be installed on your server during its creation. When you create a brand-new database through the Control Panel, you will just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the app in question requires it, so you won’t have to do anything else in your account. Likewise, if a given app requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Hosting

All dedicated hosting services ordered with our in-house built Hepsia hosting Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you want to run open-source PHP scripts that require it. All it takes to run such a script is to set up a new database and to begin the setup process – as soon as the installer wizard gets access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not have to change any settings on the dedicated server. This will allow you to activate different scripts on one single machine and to use the latter to its full capacity.