InnoDB is a storage engine for MySQL databases, which is used by widespread open-source script-based software applications such as Magento and Joomla 3.x. It’s ideal for scalable apps, as it works unbelievably well when processing huge data volumes. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. What’s more, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – a set of rules that define how data imports and updates should be treated. If a particular operation has not been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be kept safe and sound and will not be partially merged with newly imported content.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many other hosting companies, it is part of the standard set of features that we’re offering with our shared hosting plans. If you want to use an open-source script-based web application that needs InnoDB specifically, in order to be activated and to operate properly, you will not have to deal with any impediments since the database engine is available on our in-house built cloud web hosting platform. No matter if you set up a brand-new database and install an app manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application needs it instead of MyISAM. Besides the remarkable database crash recovery offered by InnoDB, we also maintain daily backups of all databases, so that we can easily restore any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our Linux semi-dedicated services by default, so once you purchase a new account, you can go on and activate any script-driven app that needs the storage engine. Several engines are installed on our cloud web hosting platform, so when you set up a new MySQL database and start installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the requirements of the app in question. This will permit you to activate and run InnoDB-specific applications without having to cope with any obstacle and without needing to change any settings in your semi-dedicated account. To take no chances, we will always have a one-week-old backup of all your MySQL databases, so if you remove or edit any content unintentionally, we can quickly rescue it.
InnoDB in VPS Hosting
If our custom-built Hepsia hosting Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the VPS server along with other necessary pieces of software, so you will not have to do anything if you decide to make use of script-driven apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand-new database and start the app installation procedure manually or through our 1-click installer tool. The system will recognize which engine the application in question requires and will set it for the specific MySQL database, so the installation will proceed flawlessly and the application can insert its data into that database. Thus, you can install applications with different requirements regarding the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Web Hosting
All dedicated web hosting that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually in case you wish to use open-source PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to begin the installation – as soon as the script configuration wizard acquires access to the database and begins importing content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to edit any settings on the dedicated server. This will permit you to install various scripts on a single server and to use the latter to its fullest capabilities.