InnoDB is a very popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has plenty of advantages which have made it the engine of choice for lots of PHP script-based web applications, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding large data volumes will be faster with InnoDB, as it locks only one row to carry out a given operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is tackled. Simply put, appending new or modifying existent data will either be fully completed, or will be annulled and the operation will be rolled back in case a certain issue occurs during the process, which is why the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

You’ll be able to make use of any script-powered application that requires InnoDB if you have a Linux cloud web hosting service with our company, as the database engine is present on our innovative cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can run apps which use the MyISAM engine without encountering any difficulty as well and, again, the engine will be pre-selected, so you won’t need to modify anything manually at any point. In addition, we’ll also generate regular backups of all the MySQL databases that you have in your shared hosting account, so if 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

You can make use of a script-driven software application that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our leading-edge cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our 1-click app installer. Either way, the required engine will be chosen automatically the moment the installation of the application starts, so you will not need to configure anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to restore any of your MySQL databases in case you remove one by mistake, as we make a couple of database backups every day, each of which is saved for one week.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the default software package that will be installed on your Virtual Private Server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and run any open-source script-driven app that needs InnoDB when your VPS is up and running, which takes no more than one hour after the order submission procedure itself. A couple of engines are available, so anytime you set up a database via the Hepsia hosting Control Panel, a specific engine will be selected once the app installation begins and our system will automatically detect which engine is required by the app in question. If you need to use MyISAM, for example, you won’t have to do anything different than installing the app of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel come with a software package that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually in case you wish to run PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to start the setup process – once the script configuration wizard obtains access to the database in question and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you won’t need to update any settings on the server. This will allow you to use various scripts on one single physical machine and to use the latter to its fullest potential.