InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has a lot of pluses which have made it the preferred engine for numerous script-driven software apps, among them Magento and Joomla, which have switched over to InnoDB for good. For instance, importing huge volumes of data will be much faster with InnoDB, as it locks only one row to perform an operation, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is treated. Simply put, adding new or updating existing data will either be fully completed, or will be annulled and the operation will be rolled back in case some problem appears in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
You will be able to activate any open-source script-driven web application that requires InnoDB if you’ve got a Linux shared hosting service with our company, as the MySQL storage engine is present on our cutting-edge cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is required. You can run applications which use the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t need to edit any setting manually at any moment. On top of that, we will also carry out regular backups of all the databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server plans and you begin installing a script-driven application either manually or using our single-click application installer tool, the storage engine for the database will be set automatically based on the particular app’s requirements. As InnoDB is present on the cloud platform where your new account will be set up, it will be set as the default engine for any app that needs it without any manual intervention needed on your end at any time. To prevent any chance of losing information if you update an app or if you erase a database unintentionally, we’ll make a backup of all your MySQL databases every day, so if something goes wrong, we can retrieve your data.
InnoDB in VPS Servers
When you buy a VPS server from us, you will be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to manage any PHP-based application which requires InnoDB, as the database engine is an integral part of the standard software package that will be pre-installed on your VPS server during its configuration. When you create a brand-new MySQL database using the Control Panel, you simply need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the app in question needs it, so you won’t need to do anything else in your account. In the same manner, if a certain app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers
All Linux dedicated service ordered with our custom Hepsia Control Panel include a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually if you want to use open-source PHP scripts that require it. All it takes to activate such a script is to set up a new database and to start the installation process – as soon as the script setup wizard acquires access to the database and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You will also be able to install scripts that need MyISAM – the other very popular MySQL engine, so you will not have to update any settings on the server. This will enable you to run various scripts on a single physical machine and to use it to its fullest potential.