InnoDB is a database storage engine for MySQL databases, which is used by well known open-source script-based web apps such as Magento and Joomla v3. It’s ideal for scalable apps, because it performs very well when processing immense volumes of data. Rather than locking the entire table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same length of time. Also, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that define how data imports and updates should be handled. If a given operation hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will remain intact and won’t be partially merged with newly appended content.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting providers, it is an integral part of the standard set of services that we are offering with our web hosting plans. If you want to make use of a script-powered web application that requires InnoDB in particular, in order to be activated and to operate properly, you will not experience any impediments since the InnoDB storage engine is available on our custom-built cloud Internet hosting platform. Regardless of whether you set up a brand-new database and install an app manually or use our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular application needs InnoDB rather than MyISAM. In addition to the amazing database failure recovery that InnoDB is offering, we also store regular database backups, so that we can swiftly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you begin installing an open-source script-powered web app either manually or using our single-click application installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the particular application. As InnoDB is available 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 any app that needs it without any manual action needed on your end at any point. To prevent any risk of losing info if you update an application or if you erase a database unintentionally, we’ll make backups of all your MySQL databases each day, so if anything happens, we can retrieve your content.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is part of the standard software package that will be installed on all Hepsia-equipped dedicated servers, so once your physical machine is up and running, you will be able to log in and to install any type of script-based software application that needs this particular database storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you start installing an app. Once the app installation wizard begins importing content into the newly created database, the engine will be selected automatically depending on the prerequisites of the respective application, so you can run both InnoDB and MyISAM without having to select either of them specifically at any moment. Therefore, you can use a vast variety of apps for your Internet sites.