InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-based software applications like Joomla 3 and Magento. It’s ideal for scalable applications, as it works exceptionally well when processing huge volumes of data. Instead of locking the whole database table to append new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Additionally, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that indicate how data imports and updates should be treated. If a certain task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be retained safe and sound and will not be partially mixed with newly inserted content.
InnoDB in Cloud Hosting
While InnoDB is either not available or a paid upgrade with many web hosting companies, it is part of the standard set of features that we’re offering with our cloud hosting plans. In case you’d like to use an open-source script-based software application that needs InnoDB in particular, in order to be installed and to work correctly, you won’t encounter any problems as the storage engine is available on our in-house built cloud website hosting platform. No matter if you set up a brand-new MySQL database and activate an application manually or take advantage of our single-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the application needs InnoDB rather than MyISAM. Besides the amazing database failure recovery that InnoDB is offering, we also perform regular database backups, so that we can easily restore any database in your shared account.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the hosting Control Panel provided with all our semi-dedicated server accounts and you start installing a script-based app either manually or using our 1-click app installer tool, the MySQL database storage engine will be selected automatically depending on the given app’s prerequisites. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual action required on your end at any time. To prevent any chance of losing data if you update an application or if you erase a database by mistake, we’ll perform backups of all your MySQL databases each day, so if anything goes wrong, we can recover your content.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is picked during the registration process for a new VPS hosting plans , InnoDB will be activated on the server along with other essential software, so you will not need to do anything if you choose to install PHP script-based applications that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated too. You can set up a brand new MySQL database and start installing the app manually or through our one-click installer. The system will automatically recognize the engine that the application in question requires and will assign it to the specific database, so the installation process will continue flawlessly and the app can dump its content in that database. In this way, you can use applications with various requirements about the MySQL engine without making any modifications on your VPS.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans ordered with our in-house built Hepsia Control Panel include a software package that is pre-installed and among everything else, you will get the InnoDB database engine, so you won’t have to install it manually in case you need to run open-source scripts that require it. All it takes to run such a script is to set up a new database and to initiate the installation – as soon as the script configuration wizard obtains access to the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not have to update any settings on the dedicated server. This will enable you to activate various scripts on one single machine and to use it to its maximum capacity.