InnoDB is a database engine for MySQL databases, which is used by widespread script-powered software apps such as Joomla 3 and Magento. It’s perfect for scalable applications, because it performs remarkably well when handling huge amounts of data. Instead of locking the whole 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. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be treated. If a specific operation has not been entirely completed for any reason, the action will be rolled back. Thus, the database content will be kept safe and sound and won’t be partially merged with newly added content.

InnoDB in Cloud Hosting

You’ll be able to run any PHP-driven software application that requires InnoDB if you have a cloud hosting with us, as the 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 continue flawlessly in case this engine is needed. You can run apps which use the MyISAM engine without encountering any difficulty as well and, once again, the engine will be selected automatically, so you will not need to modify anything manually at any moment. In addition, we will also create regular backups of all the MySQL databases that you have in the shared account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated hosting plans by default, so once you purchase a new semi-dedicated account, you can go ahead and install any script-powered app that requires the MySQL storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen based on the prerequisites of the given app. This will allow you to install and manage InnoDB-specific apps without any impediment and without the need to configure any settings in your semi-dedicated account. To take no chances, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can easily rescue it.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software pack that will be installed on your Virtual Private Server before we give it to you. You won’t need to activate anything manually and you’ll be able to enable and manage any script-powered software app that requires InnoDB as soon as your VPS is up and running, which takes no more than sixty minutes after the order submission procedure itself. A couple of engines are offered, so anytime you set up a database using the Hepsia hosting Control Panel, a particular engine will be selected when the app installation process begins and our system will detect the engine that is required by the app in question. In case you need to use MyISAM, for example, you will not need to do anything different from installing the preferred app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom Hepsia hosting Control Panel include a software package that is pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually if you’d like to use open-source PHP scripts that require it. All it takes to run such a script is to create a new database and to begin the setup – as soon as the installation wizard acquires access to the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to install scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to configure any settings on the server. This will allow you to run a variety of scripts on one single physical server and to use the latter to its full capabilities.