InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven software apps such as Joomla 3 and Magento. It is ideal for scalable applications, because it works unbelievably well when managing immense data volumes. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same period of time. Furthermore, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be handled. In case a particular operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved intact and won’t be partially mixed with newly imported content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosting companies, it’s included in the standard set of services offered with our cloud web hosting plans. If you would like to make use of a script-powered software application that needs InnoDB in particular, in order to be installed and to perform correctly, you will not encounter any obstacles as the MySQL database engine is available on our custom-built cloud hosting platform. No matter if you create a brand-new MySQL database and install an application manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires it rather than MyISAM. In addition to the excellent crash recovery that InnoDB offers, we also keep regular backups of all databases, so that we can easily restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-powered web application that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our leading-edge cloud hosting platform where the database storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our one-click application installer. Either way, the required engine will be picked automatically once the installation of the app starts, so you will not have to edit anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to restore any of your databases in case you unintentionally erase one, as we carry out a few backups every day, each of which is saved for one whole week.

InnoDB in VPS

In case our custom-developed Hepsia hosting Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be installed on the server along with other necessary software, so you won’t need to do anything if you choose to manage PHP-driven software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a brand new database and start the app installation procedure manually or through our 1-click installer tool. The system will automatically detect which engine the particular application requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can enter its content into that database. Thus, you can run apps with various prerequisites regarding the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Hosting

InnoDB is available as standard with all Linux dedicated hosting that are ordered with the Hepsia hosting Control Panel. It is part of the software package that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is up and running, you will be able to log in and to activate any PHP script-based app that requires this particular storage engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you begin installing an application. As soon as the app installation wizard starts entering data into the database, the engine will be picked automatically in accordance with the prerequisites of the respective application, so you can run both InnoDB and MyISAM without selecting either of them specifically at any moment. Therefore, you can make use of a vast collection of applications for your sites.