InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a significantly better overall performance and a faster crash recovery in comparison with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by lots of devs that build highly scalable software applications, because it works better with huge volumes of data, while it keeps the server processing load low. What’s more, it locks only a single row in the database in case any information should be edited, whereas lots of other engines lock the entire table and therefore need much more time to execute multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla™ are two examples of popular PHP script-based applications which have moved to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with many website hosting service providers, it is an integral part of the standard set of features that we offer with our shared website hosting packages. If you would like to use an open-source script-based app that requires InnoDB specifically, in order to be activated and to function properly, you will not need to deal with any obstacles because the InnoDB database storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an app manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires it instead of MyISAM. Besides the remarkable database crash recovery offered by InnoDB, we also store daily backups of all databases, so that we can quickly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database through the Control Panel coming with all our semi-dedicated server packages and you begin installing an open-source script-based application either manually or using our one-click application installer, the storage engine for the database will be set automatically depending on the requirements of the particular application. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without any manual action required on your end at any moment. To prevent any risk of losing information if you update an application or if you erase a database by accident, we’ll carry out backups of all your databases each and every day, so if anything goes wrong, we can restore your content.
InnoDB in VPS Servers
If you order a VPS server from our company, you will be able to make use of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to activate any open-source script-based app which requires InnoDB, as this particular MySQL storage engine is included in the software package that will be installed on your VPS server during its configuration. When you set up a new database through the hosting Control Panel, you simply need to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine in case the application in question requires it, so you will not need to do anything else in your account. Identically, if a given application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s included in the standard software bundle that will be installed on all Hepsia-managed servers, so once your physical machine is up and running, you’ll be able to sign in and to activate any type of open-source script-driven web app that requires this storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app installation wizard starts importing data into the newly created database, the engine will be set automatically on the basis of the prerequisites of the app in question, so you can use both InnoDB and MyISAM without the need to select either of them explicitly at any moment. Thus, you can make use of a broad variety of apps for your Internet sites.