InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP script-driven software apps such as Joomla v3 and Magento. It is ideal for scalable apps, since it performs remarkably well when handling huge volumes of data. Rather than locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. Besides, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – rules that indicate how data imports and modifications should be treated. In case a particular task has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially merged with newly imported content.

InnoDB in Web Hosting

Every PHP-driven web application that requires InnoDB will function impeccably on our innovative cloud platform and the MySQL database engine comes with all our web hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected on the basis of the app’s prerequisites without the need to modify any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll carry out daily content backups, so if you unintentionally delete a database that is important to you or you overwrite specific parts of it, we will be able to restore your content the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the Control Panel provided with each of our semi-dedicated server plans and you begin installing a PHP script-driven web app either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the prerequisites of the given application. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that requires it without the need for any manual action on your end at any time. To avoid any risk of losing information if you update an app or if you remove a database unintentionally, we will make backups of all your MySQL databases each day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the server along with other needed pieces of software, so you won’t need to do anything if you choose to activate open-source script-driven web applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can create a brand new MySQL database and begin installing the application manually or through our single-click installer. The system will automatically detect the engine that the particular application requires and will set it for the specific database, so the installation process will continue impeccably and the application can dump its data in that database. Thus, you can make use of apps with different requirements regarding the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can choose on the server order page when you buy a dedicated server from us. Since this is the most powerful type of website hosting, it is rather likely that you will run popular Internet sites that will attract plenty of visitors, and since InnoDB is among the best options for such websites, we’ll enable it together with all the other software apps that are available with a Hepsia-equipped dedicated server. If you create a brand-new database in your dedicated account, there won’t be any activated MySQL database storage engine till you start installing an open-source script, whether manually through your web browser or using the automatic script installer tool that is included in the hosting Control Panel. The needed engine will be recognized and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having to cope with any impediment.