InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it offers a better overall performance and an improved database crash recovery compared with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many web developers that run scalable applications, due to the fact that it works more efficiently with huge amounts of data, while it keeps the server load low. Furthermore, it locks only a single row in the database if any info should be edited, while lots of other engines lock the entire database table and thus need much more time to perform several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification process cannot be completed for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest editions of Joomla are two instances of widely used PHP script-based software applications that have moved to InnoDB.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with many web hosting providers, it’s part of the default set of services offered with our web hosting packages. If you want to make use of a script-based application that needs InnoDB in particular, in order to be installed and to operate correctly, you won’t have to deal with any obstacles as the MySQL database storage engine is available on our custom-built cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application requires it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also maintain daily database backups, so that we can swiftly recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can make use of an open-source script-powered web application that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud platform where the database engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our single-click app installer. Either way, the needed engine will be picked automatically as soon as the installation of the app starts, so you won’t have to configure anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to recover any of your MySQL databases if you erase one by accident, as we create a few database backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
When you get a VPS server from our company, you will be able to use our custom-built Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to use any PHP script-driven software app which needs InnoDB, as this particular database storage engine is an integral part of the default software package that will be pre-installed on the VPS server during its setup. When you set up a brand new database through the hosting Control Panel, you simply have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine given that the app in question requires it, so you will not need to do anything else in your account. Similarly, if a certain app requires MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the default software bundle that will be pre-installed on all Hepsia-equipped servers, so once your machine is ready, you will be able to sign in and to activate any type of PHP script-powered software application that requires this database storage engine. When you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine until you begin installing an application. Once the app configuration wizard starts dumping information in the database, the engine will be picked automatically in accordance with the requirements of the respective application, so you can use both MyISAM and InnoDB without selecting either one specifically at any moment. Thus, you can use an extensive selection of apps for your websites.