InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got a lot of advantages which make it the engine of choice for numerous script-based web apps, among them Joomla and Magento, which have shifted over to InnoDB permanently. For instance, adding immense data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to carry out an operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. 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 during the process, therefore the content that remains in the database will not be lost.
InnoDB in Shared Hosting
Every script-powered software application that requires InnoDB will run flawlessly on our avant-garde cloud web hosting platform and the database storage engine is offered with all our shared hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to modify any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to make the most of its full capacity. We’ll carry out daily content backups, so in case you accidentally erase a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore the database the way it was just several hours earlier.
InnoDB in Semi-dedicated Hosting
You can use an open-source script-driven app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our advanced cloud hosting platform where the database engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our 1-click application installer tool. Either way, the needed engine will be selected automatically as soon as the activation of the application starts, so you won’t need to update anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you delete one by accident, as we create a couple of backups every day, each of which is kept for one whole week.
InnoDB in VPS
If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be included in the software bundle that will be pre-installed on your VPS server before we give it to you. You will not need to configure anything manually and you will be able to install and manage any open-source script-based software app that requires InnoDB when your VPS is up and running, which takes no more than sixty minutes after the order submission itself. Several engines are offered, so anytime you create a database using the Hepsia hosting Control Panel, a particular engine will be selected when the app activation process starts and our system will automatically recognize which engine is required by the application in question. If you need MyISAM, for example, you will not need to do anything different from installing the chosen application, whether manually or using our app installer tool.
InnoDB in Dedicated Hosting
All dedicated servers hosting packages that are ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to activate it manually in case you need to activate open-source scripts that need it. All it takes to install such a script is to create a new MySQL database and to start the installation – as soon as the installer wizard receives access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you will not have to configure any settings on the dedicated server. This will enable you to activate various scripts on one single physical server and to use the latter to its fullest potential.