InnoDB is a database engine for MySQL relational databases, which is used by widespread PHP-based web apps like Magento and Joomla™ v3. It is excellent for scalable apps, since it works amazingly well when managing immense amounts of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same length of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and updates should be handled. If a specific task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will remain intact and will not be partially merged with newly imported content.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any open-source script-driven web app which requires the database storage engine without any problem once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, no matter if you make use of our single-click installation tool or create the database and install the app manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll perform daily database backups, so you can be sure that you won’t ever lose any content in case you erase a database by mistake or you overwrite some vital info – you just have to contact us and we will restore your data back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is available with all our Linux semi-dedicated hosting by default, so as soon as you buy a new semi-dedicated account, you can go ahead and activate any script-driven software app that needs this particular database engine. A couple of engines are installed on our cloud platform, so when you create a new MySQL database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen depending on the requirements of the app in question. This will permit you to activate and manage InnoDB-specific applications without any complication and without needing to edit any settings in your semi-dedicated account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you erase or alter any content accidentally, we can easily retrieve it.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to add it manually in case you need to use PHP scripts that require it. All it takes to run such a script is to set up a new database and to begin the installation process – once the setup wizard obtains access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to activate 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 permit you to use various scripts on one single server and to use it to its full capacity.