InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got plenty of strengths which make it the engine of choice for numerous script-based applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For instance, importing enormous amounts of data will be much faster with InnoDB, as it locks only one database row to complete a specific task, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. In simpler words, adding new or editing existent data will either be entirely completed, or will be aborted and the procedure will be rolled back in case some issue occurs in the meantime, therefore the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting service providers, it is included in the standard set of features that we are offering with our cloud hosting plans. In case you’d like to make use of a PHP-powered web application that requires InnoDB particularly, in order to be installed and to function correctly, you won’t come across any impediments since the database storage engine is available on our custom-developed cloud platform. No matter if you create a brand-new MySQL database and activate an application manually or take advantage of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the application requires it instead of MyISAM. Besides the outstanding database crash recovery that InnoDB offers, we also carry out daily database backups, so that we can swiftly recover any database in your shared account.

InnoDB in VPS Web Hosting

When you order a virtual private server from us, you’ll be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to install any open-source script-based software app that needs InnoDB, as this particular MySQL storage engine is an essential part of the software bundle that will be pre-installed on the VPS server during its creation. When you set up a brand-new MySQL database via the Control Panel, you just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your VPS account. Equivalently, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers Hosting

InnoDB comes as standard with all dedicated servers hosting ordered with the Hepsia Control Panel. It is included in the standard software package that will be pre-installed on all Hepsia-managed servers, so once your machine is up and running, you’ll be able to sign in and to activate a various PHP script-based app that requires this MySQL storage engine. When you create a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app installation wizard starts inserting data into the database, the engine will be chosen automatically based on the prerequisites of the particular app, so you can run both InnoDB and MyISAM without selecting either one explicitly at any point. Thus, you can use a wide range of applications for your Internet sites.