InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-driven apps such as Magento and Joomla™ 3. It is excellent for scalable applications, because it performs unbelievably well when processing large data volumes. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. What’s more, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be handled. In case a particular task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the database content will remain intact and will not be partially merged with newly added content.

InnoDB in Shared Hosting

You will be able to use any open-source script-based software application that requires InnoDB in case you have a Linux shared hosting with our company, as the database engine is present on our advanced cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate applications that require the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t need to modify anything manually at any moment. What’s more, we’ll also carry out regular backups of all the MySQL databases that you’ve got in your account, so if you erase 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 Servers

InnoDB is available with all our semi-dedicated service by default, so the moment you buy a new semi-dedicated account, you can go ahead and activate any script-based application that requires this particular database storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a brand-new database and start installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen depending on the specific app’s prerequisites. This will permit you to activate and run InnoDB-specific apps without running into any difficulty and without the need to edit any settings in your account. To avoid any risk, we will always have a seven-day-old backup of all your MySQL databases, so if you erase or alter any content by accident, we can quickly rescue it.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the software bundle that will be installed on your server before we give it to you. You won’t have to set up anything manually and you’ll be able to install and use any open-source script-driven web app that needs InnoDB when your VPS server is set up, which takes no more than 60 minutes after the order submission itself. A few engines are available, so anytime you create a database using the Hepsia Control Panel, a particular engine will be picked when the app installation begins and our system will detect the engine that is required by the app in question. If you need to use MyISAM, for example, you will not need to do anything different from installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

All dedicated service that are ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database engine, so you won’t need to install it manually in case you’d like to run open-source PHP scripts that need it. All it takes to install such a script is to create a new database and to initiate the installation process – once the script setup wizard acquires access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to install scripts that need MyISAM, the other widely used MySQL engine, so you won’t have to configure any settings on the server. This will allow you to activate a variety of scripts on a single server and to use it to its maximum potential.