InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP script-driven software apps such as Joomla 3 and Magento. It’s excellent for scalable apps, as it performs unbelievably well when handling large amounts of data. Rather than locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can process a lot more operations for the same length of time. Additionally, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – rules that specify how data inserts and modifications should be handled. In case a certain task has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will remain intact and won’t be partially mixed with newly imported content.

InnoDB in Shared Hosting

You can run any open-source script-based application that requires InnoDB if you’ve got a shared service with our company, as the database storage engine is present on our advanced cloud hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is required. You can install apps which require the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you won’t need to change anything manually at any time. Furthermore, we will also make daily backups of all the databases that you’ve got in your shared hosting account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel included with all our semi-dedicated server plans and you start installing a script-based software application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be set automatically depending on the requirements of the given application. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any time. To avoid any chance of losing information if you update an application or if you delete a database by accident, we will carry out a backup of all your MySQL databases each and every day, so if anything goes wrong, we can restore your data.

InnoDB in VPS

If you pick a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the standard software pack that will be installed on your VPS server before we hand it over to you. You will not need to activate anything manually and you will be able to enable and manage any script-powered app that needs InnoDB as soon as your VPS server is ready, which takes no more than one hour after the order procedure itself. Several engines are offered, so anytime you set up a database via the Hepsia Control Panel, a specific engine will be selected once the app installation begins and our system will detect the engine that is required by the app in question. In case you need to use MyISAM, for instance, you won’t have to do anything different from installing the chosen app, whether manually or using our application installer.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually in case you’d like to activate PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to start the setup – as soon as the script configuration wizard gets access to the database in question and begins entering 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 script. You’ll also be able to use scripts that need MyISAM, the other widely used MySQL engine, so you will not need to modify any settings on the dedicated server. This will permit you to install various scripts on a single server and to use it to its fullest capacity.