InnoDB is a storage engine for MySQL databases, which is used by well known script-powered apps like Joomla 3.x and Magento. It’s excellent for scalable applications, because it works unbelievably well when processing enormous volumes of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same period of time. Besides, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be treated. If a given task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially merged with newly appended content.

InnoDB in Web Hosting

Every open-source script-based web application that requires InnoDB will run impeccably on our cutting-edge cloud website hosting platform and the database storage engine is available 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 in question will use will be selected on the basis of the app’s specifications without the need to configure any setting in your account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will create daily backups of your content, so in case you unintentionally delete a database that is important to you or you overwrite certain parts of it, we’ll be able to restore the database the way it was only a few hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel offered with all our semi-dedicated server plans and you start installing a PHP-powered software application either manually or using our 1-click app installer tool, the storage engine for the database will be set automatically based on the requirements of the particular app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that requires it without any manual action required on your end at any time. To avoid any risk of losing information if you update an application or if you delete a database unintentionally, we’ll generate a backup of all your MySQL databases every day, so if something goes wrong, we can retrieve your data.

InnoDB in VPS Web Hosting

If our custom-built Hepsia Control Panel is picked during the signup process for a new Linux virtual private servers , InnoDB will be activated on the VPS server together with other essential pieces of software, so you won’t need to do anything if you decide to use open-source script-powered apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand new MySQL database and start the app installation procedure manually or using our single-click installer tool. The system will automatically detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can dump its data in that database. In this way, you can make use of apps with different prerequisites with regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our custom Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to add it manually in case you’d like to activate open-source PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the setup process – once the installer wizard acquires access to the database and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You will also be able to run scripts that need MyISAM – the other popular MySQL engine, so you won’t need to update any settings on the server. This will enable you to run different scripts on one single physical machine and to use the latter to its fullest capabilities.