InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by plenty of devs that create highly scalable web applications, because it works much more efficiently with enormous volumes of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case any info should be modified, while many other engines lock the entire table and hence require more time to process multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest Joomla versions are two instances of widely used open-source script-powered software platforms which have shifted over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it is an integral part of the default set of services offered with our shared hosting packages. If you’d like to use an open-source script-driven application that requires InnoDB in particular, in order to be activated and to operate properly, you won’t have any problems because the InnoDB storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a new database and activate an application manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app requires InnoDB instead of MyISAM. Besides the outstanding database crash recovery that InnoDB offers, we also generate daily backups of all databases, so that we can easily recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you start installing a PHP-powered web application either manually or using our single-click application installer tool, the MySQL database storage engine will be selected automatically on the basis of the particular app’s requirements. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without any manual intervention required on your end at any time. To avoid any risk of losing information if you update an application or if you remove a database by accident, we’ll make a backup of all your databases each day, so if something goes wrong, we can restore your content.
InnoDB in VPS Servers
All VPS web hosting plans that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any PHP-based software application that needs the storage engine without needing to install anything manually. You can choose Hepsia on the VPS configuration page and your brand-new VPS server will be up and running within 60 minutes, so you can log in and start setting up your web sites straight away. When you create a brand new database and begin the app activation process, our system will select the engine for this MySQL database automatically. In this way, you can install various applications simultaneously without the need to configure anything on the Virtual Private Server. You can create a WordPress-based personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-powered e-commerce website that uses the InnoDB engine, for instance.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It’s an essential part of the standard software package that will be installed on all Hepsia-equipped servers, so as soon as your machine is set up, you’ll be able to sign in and to activate any PHP-driven app that requires this particular database storage engine. When you set up a new database through the Control Panel, there won’t be any active engine until you start installing an app. Once the app installation wizard starts inserting content into the database, the engine will be selected automatically based on the prerequisites of the specific app, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any time. Therefore, you can make use of an immense variety of applications for your sites.