InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous developers that run highly scalable web apps, due to the fact that it works more effectively with huge data volumes, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any info should be updated, whereas many other engines lock the entire table and hence require more time to execute several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest Joomla™ versions are two instances of widely used open-source script-driven software applications that have switched to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it is part of the default set of features that we offer with our shared hosting packages. In case you want to use a PHP script-based software application that needs InnoDB in particular, in order to be installed and to work properly, you will not need to deal with any problems since the MySQL storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective application requires InnoDB instead of MyISAM. Besides the outstanding database crash recovery that InnoDB is offering, we also carry out daily database backups, so we can swiftly restore any database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can install a script-powered application that requires InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our innovative cloud hosting platform where the database engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our single-click app installer tool. In either case, the needed engine will be chosen automatically the moment the activation of the application starts, so you won’t have to edit anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you unintentionally delete one, as we generate a few MySQL database backups every day, each of which is preserved for one week.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an essential part of the software package that will be pre-installed on your server before we hand it over to you. You will not have to set up anything manually and you will be able to install and manage any PHP script-powered software app that needs InnoDB when your VPS is up and running, which takes no more than 60 minutes after the order submission procedure itself. A number of engines are available, so every time you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be activated once the app installation process starts and our system will automatically detect the engine that is required by the app in question. In case you have to use MyISAM, for instance, you won’t need to do anything different from installing the preferred application, whether manually or using our app installer.
InnoDB in Dedicated Servers
All Linux dedicated servers ordered with our custom-developed Hepsia hosting Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you wish to use PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup – as soon as the setup wizard gets access to the database in question and begins importing content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed 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 edit any settings on the server. This will allow you to activate different scripts on a single physical machine and to use the latter to its maximum capabilities.