InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software applications such as Magento and Joomla 3.x. It’s excellent for scalable applications, as it performs amazingly well when handling huge data volumes. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same length of time. What’s more, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and updates should be treated. If a given operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will be retained undamaged and will not be partially merged with newly imported content.

InnoDB in Cloud Hosting

You’ll be able to activate any open-source script-driven application that requires InnoDB in case you’ve got a cloud plan with us, as the MySQL database engine is available on our cutting-edge cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run apps that require the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t have to update any setting manually at any time. In addition, we’ll also make daily backups of all the databases that you have in your shared web hosting account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated hosting plans by default, so once you get a new account, you can go on and activate any PHP-powered application that needs this MySQL database engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you set up a brand new MySQL database and begin installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected in accordance with the requirements of the particular app. This will allow you to install and run InnoDB-specific apps without any complications and without having to modify any settings in your account. To avoid any risk, we will always have a one-week-old backup of all your MySQL databases, so if you remove or alter any content unintentionally, we can easily rescue it.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is picked during the registration process for a new VPS plans , InnoDB will be installed on the Virtual Private Server along with other required software, so you won’t have to do anything if you choose to use PHP script-powered software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin the app installation manually or using our 1-click installer tool. The system will automatically recognize which engine the application in question needs and will set it for the specific database, so the installation process will continue impeccably and the app can import its content into that database. Thus, you can use apps with different prerequisites in regard to the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB comes as standard with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It is an integral part of the default software bundle that we install on all Hepsia-equipped servers, so as soon as your machine is set up, you’ll be able to sign in and to activate any kind of open-source script-based web application that needs this particular MySQL storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an app. As soon as the app configuration wizard begins dumping content in the newly created database, the engine will be picked automatically on the basis of the requirements of the specific application, so you can run both InnoDB and MyISAM without selecting either one specifically at any point. In this way, you can make use of a broad variety of apps for your sites.