InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-based software applications like Magento and Joomla 3.x. It’s perfect for scalable applications, as it performs unbelievably well when handling huge amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. Also, InnoDB offers a better crash recovery and supports database transactions and foreign keys – rules that determine how data inserts and modifications should be treated. In case a specific operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain intact and will not be partially mixed with new content.

InnoDB in Cloud Web Hosting

InnoDB is offered with all our Linux cloud web hosting service by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP-based application which requires the storage engine without any problems once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation process, regardless of whether you make use of our 1-click installation tool or create the MySQL database and activate the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you erase a database unintentionally or you overwrite some essential information – you’ll simply need to touch base with us and we’ll restore your database back to normal.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the Control Panel included with each of our semi-dedicated server accounts and you start installing a script-driven software app either manually or using our single-click app installer tool, the MySQL database storage engine will be set automatically on the basis of the prerequisites of the specific app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without any manual intervention required on your end at any time. To avoid any risk of losing info if you update an app or if you erase a database by accident, we’ll generate a backup of all your MySQL databases each and every day, so if something goes wrong, we can rescue your data.

InnoDB in VPS Servers

When you buy a VPS server from us, you will be able to use our custom Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to run any PHP-based software application which needs InnoDB, as this database storage engine is an integral part of the default software package that will be installed on your Virtual Private Server during its creation. When you set up a brand new MySQL database through the Control Panel, you will just have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question needs it, so you won’t have to do anything else in your VPS account. Analogously, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you want to activate open-source scripts that need it. All it takes to use such a script is to set up a new database and to begin the setup – as soon as the script configuration wizard gets access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that require the other widely used MySQL engine – MyISAM, so you will not have to modify any settings on the dedicated server. This will permit you to install a variety of scripts on one single physical server and to use it to its fullest capacity.