InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has many strengths that have made it the preferred engine for numerous PHP script-based software applications, including Magento and Joomla™, which have moved to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, as it locks only a single row to accomplish a given operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Simply put, adding new or modifying existent data will either be fully completed, or will be canceled and the operation will be rolled back if some issue shows up in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting companies, it is included in the standard set of features that we are offering with our cloud web hosting plans. In case you would like to use a script-powered web application that requires InnoDB particularly, in order to be installed and to perform properly, you will not have to deal with any difficulties since the InnoDB storage engine is available on our custom-built cloud platform. Regardless of whether you create a brand new MySQL database and install an app manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs InnoDB rather than MyISAM. In addition to the incredible database crash recovery that InnoDB is offering, we also maintain regular database backups, so we can swiftly restore any database in your shared web hosting account.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s part of the software bundle that we install on all Hepsia-managed servers, so as soon as your physical machine is set up, you will be able to sign in and to install any script-based application that needs this MySQL database engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine till you start installing an application. As soon as the app configuration wizard begins importing data into the database, the engine will be selected automatically based on the prerequisites of the app in question, so you can run both InnoDB and MyISAM without having to select either of them explicitly at any time. Therefore, you can make use of a huge collection of applications for your Internet sites.