InnoDB is a storage engine for MySQL relational databases, which is used by famous script-driven software applications like Joomla™ v3 and Magento. It is ideal for scalable applications, because it performs unbelievably well when processing large volumes of data. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be handled. If a certain operation hasn’t been fully completed for some reason, the action will be rolled back. In this way, the information in the database will stay undamaged and won’t be partially mixed with newly imported content.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an essential part of the default set of features that we’re offering with our shared website hosting packages. If you’d like to make use of a PHP script-powered application that requires InnoDB particularly, in order to be installed and to operate properly, you will not face any difficulties as the MySQL storage engine is available on our custom-developed cloud hosting platform. Regardless of whether you set up a brand-new database and activate an application manually or take advantage of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it rather than MyISAM. In addition to the outstanding database crash recovery that InnoDB offers, we also keep regular database backups, so we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so the moment you create a new account, you can go on and install any PHP-based application that needs the database storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a brand-new MySQL database and start installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen in accordance with the prerequisites of the application in question. This will allow you to install and run InnoDB-specific apps without having to deal with any difficulty and without having to change any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or change any content accidentally, we can easily retrieve it.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers , InnoDB will be installed on the VPS server together with other essential pieces of software, so you will not have to do anything if you choose to use script-driven apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand-new MySQL database and begin installing the application manually or using our 1-click installer. The system will recognize the engine that the particular app needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can insert its data into that database. Thus, you can manage applications with various requirements concerning the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers Hosting

InnoDB is included by default with all Linux dedicated servers hosting ordered with the Hepsia Control Panel. It is an integral part of the software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so once your physical machine is up and running, you will be able to log in and to install any PHP-powered app that needs this MySQL database engine. When you create a new database through the hosting Control Panel, there won’t be any activated engine till you start installing an application. Once the app activation wizard starts dumping information in the database, the engine will be selected automatically depending on the prerequisites of the particular app, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any point. Thus, you can make use of a large range of applications for your Internet sites.