InnoDB is a storage engine for MySQL relational databases, which is used by famous script-driven applications like Magento and Joomla 3.x. It is excellent for scalable applications, as it works amazingly well when managing enormous amounts of data. Rather than locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. In addition, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that determine how data imports and modifications should be handled. If a certain task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and won’t be partially mixed with new content.
InnoDB in Shared Website Hosting
Every PHP-based software application that needs InnoDB will function flawlessly on our advanced cloud web hosting platform and the MySQL storage engine comes with all our shared website hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without having to configure any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We’ll create regular backups of your content, so in case you unintentionally erase a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore everything the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database through the Control Panel provided with all our semi-dedicated server plans and you begin installing a script-driven web application either manually or using our single-click application installer tool, the storage engine for the MySQL database will be set automatically on the basis of the prerequisites of the app in question. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any time. To avoid any chance of losing info if you update an app or if you erase a database by mistake, we’ll generate a backup of all your databases each and every day, so if anything goes wrong, we can recover your data.
InnoDB in VPS
When you purchase a virtual private server from us, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to install any PHP-driven web application that needs InnoDB, as the MySQL database storage engine is an integral part of the standard software bundle that will be installed on the server during its creation. When you set up a new database through the Control Panel, you will just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question needs it, so you will not have to do anything else in your account. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Hosting
All Linux dedicated hosting ordered with our in-house developed Hepsia Control Panel include a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not have to install it manually if you wish to activate open-source scripts that require it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup – as soon as the script setup wizard acquires access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to use scripts that require MyISAM – the other popular MySQL engine, so you will not have to update any settings on the dedicated server. This will allow you to run different scripts on a single physical server and to use it to its fullest capacity.