InnoDB is a database engine for MySQL relational databases, which is used by widespread open-source script-based software applications such as Magento and Joomla™ 3. It is perfect for scalable apps, as it performs amazingly well when handling huge amounts of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same length of time. Furthermore, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be handled. In case a certain task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially merged with newly appended content.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud plans by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any script-based web app which requires the InnoDB database engine without encountering any obstacle once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our 1-click installation tool or create the database and set up the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll keep daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data if you delete a database unintentionally or you overwrite some essential info – you simply have to notify us and we’ll restore your content the way it was.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually in case you need to run open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to begin the installation process – once the installer wizard gains access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that require MyISAM – the other popular MySQL engine, so you won’t have to modify any settings on the server. This will enable you to use a variety of scripts on one single physical machine and to use the latter to its fullest capacity.