InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has a number of advantages which make it the preferred engine for many PHP script-powered apps, such as Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding enormous volumes of data will be faster with InnoDB, since it locks only one row to carry out a specific operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. Put simply, adding new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some issue appears in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

You’ll be able to activate any PHP-powered web application that needs InnoDB if you have a Linux shared web hosting with our company, as the database storage engine is present on our leading-edge cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can run applications which require the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you won’t need to modify anything manually at any time. What’s more, we will also perform daily backups of all the databases that you’ve got in your shared web hosting account, so in case you delete or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

You can make use of an open-source script-based web application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our leading-edge cloud platform where the MySQL storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our one-click application installer tool. In either case, the needed engine will be selected automatically the moment the application’s installation starts, so you will not need to change anything manually, regardless of whether the application needs InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases in case you delete one by mistake, as we make several MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Hosting

If you obtain a virtual private server from our company, you’ll be able to make use of our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to run any script-powered web application which needs InnoDB, as this MySQL database engine is an essential part of the default software bundle that will be installed on the Virtual Private Server during its creation. When you set up a new MySQL database using the Control Panel, you will simply need to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question needs it, so you will not have to do anything else in your VPS account. Analogously, if an application needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our custom Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually if you need to activate PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the setup process – once the script setup wizard receives access to the database in question and begins dumping content in 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 activate scripts that need MyISAM – the other popular MySQL engine, so you will not need to update any settings on the server. This will allow you to use different scripts on a single machine and to use the latter to its fullest capabilities.