InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved database failure recovery compared to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of programmers that create scalable web applications, as it works much better with immense volumes of data, while it keeps the server processing load at a minimum. Also, it locks only one database row if anything should be edited, while lots of other engines lock the entire table and hence need more time to process several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ versions are two examples of famous PHP-driven apps which have shifted over to InnoDB.
InnoDB in Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it’s included in the standard set of features that we offer with our website hosting packages. If you’d like to make use of a PHP-powered software app that requires InnoDB specifically, in order to be installed and to operate correctly, you will not encounter any obstacles as the database engine is available on our in-house developed cloud Internet hosting platform. Irrespective of whether you create a new MySQL database and activate an application manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the given application needs InnoDB instead of MyISAM. In addition to the remarkable crash recovery that InnoDB is offering, we also make daily backups of all databases, so we can quickly restore any database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
You can run a PHP-based application that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our leading-edge cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click app installer tool. Either way, the needed engine will be chosen automatically the moment the activation of the app begins, so you will not need to configure anything manually, irrespective of whether the application requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to restore any of your databases in case you erase one by mistake, as we make a couple of MySQL database backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the standard software pack that will be pre-installed on your VPS server before we hand it over to you. You will not need to set up anything manually and you’ll be able to enable and manage any open-source script-driven app that requires InnoDB when your Virtual Private Server is set up, which takes no more than 60 minutes after the order submission itself. Several engines are available, so anytime you create a database via the Hepsia hosting Control Panel, a particular engine will be picked when the app activation begins and our system will detect which engine is required by the application in question. In case you need MyISAM, for instance, you won’t have to do anything different from installing the app of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
If you acquire a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to install this database engine manually in order to be able to use open-source script-powered software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you need in order to manage very large sites, it’s pretty possible that you’ll use InnoDB. You’ll be able to use other engines too, so in case a given application requires MyISAM instead of InnoDB, you won’t have any difficulty while running it. The engine that will be used will be automatically recognized once the app installation process begins, so you will not need to change any settings manually at any moment.