InnoDB is a database engine for MySQL databases, which is used by famous script-powered apps such as Magento and Joomla 3. It’s perfect for scalable applications, as it works very well when processing huge data volumes. Rather than locking the entire database table to import 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 length of time. Also, InnoDB offers a faster crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. In case a specific task has not been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be retained intact and will not be partially merged with new content.
InnoDB in Shared Web Hosting
Any PHP-based app that needs InnoDB will run flawlessly on our leading-edge cloud web hosting platform and the MySQL storage engine is available with all our shared web hosting plans. Every time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without having to modify any setting in your shared account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to take advantage of its full capacity. We’ll store daily content backups, so in case you unintentionally erase a MySQL database that you need or you overwrite certain parts of it, we will be able to restore everything the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
You can activate a PHP-driven software app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our avant-garde cloud platform where the database engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click app installer tool. Either way, the needed engine will be picked automatically the moment the installation of the app begins, so you won’t have to edit anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. On top of that, we will always be able to restore any of your databases if you delete one by mistake, as we carry out several MySQL database backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be part of the standard software pack that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not have to activate anything manually and you will be able to install and use any PHP script-powered software application that needs InnoDB when your VPS is up and running, which takes no more than one hour after the order submission itself. A few engines are available, so every time you set up a database via the Hepsia hosting Control Panel, a specific engine will be selected when the app activation process commences and our system will recognize which engine is required by the application in question. In case you need to use MyISAM, for example, you won’t need to do anything different than installing the desired app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
All Linux dedicated service ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually if you would like to run open-source scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to start the installation process – once the script setup wizard acquires access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that require MyISAM – the other popular MySQL engine, so you will not need to configure any settings on the dedicated server. This will enable you to use different scripts on a single physical server and to use the latter to its full capabilities.