InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got a lot of strengths which have made it the engine of choice for plenty of PHP-powered software applications, among them Joomla and Magento, which have shifted over to InnoDB permanently. For instance, adding huge amounts of data will be much faster with InnoDB, because it locks only a single database row to accomplish a particular operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. In simpler words, adding new or modifying existent data will either be entirely completed, or will be canceled and the procedure will be rolled back if some issue shows up during the process, therefore the content that remains in the database won’t be damaged.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many web hosting providers, it’s an integral part of the standard set of features that we’re offering with our hosting plans. If you’d like to use an open-source script-driven application that needs InnoDB particularly, in order to be installed and to work correctly, you won’t need to deal with any obstacles as the storage engine is available on our in-house built cloud web hosting platform. Regardless of whether you set up a new MySQL database and activate an application manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the incredible database failure recovery that InnoDB is offering, we also carry out regular backups of all databases, so we can easily restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you begin installing an open-source script-based web application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically depending on the requirements of the specific app. As InnoDB is present on the cloud platform where your new account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any moment. To prevent any chance of losing information if you update an app or if you erase a database by accident, we will generate backups of all your MySQL databases each day, so if something happens, we can recover your content.

InnoDB in Dedicated Servers Hosting

InnoDB is included by default with all Linux dedicated servers hosting ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software package that will be pre-installed on all Hepsia-equipped servers, so as soon as your physical machine is ready, you will be able to log in and to activate any type of open-source script-driven web app that needs this particular database engine. When you create a new database via the Control Panel, there won’t be any activated engine until you start installing an app. Once the app setup wizard begins inserting information into the newly created database, the engine will be selected automatically based on the prerequisites of the respective application, so you can use both InnoDB and MyISAM without having to select either of them specifically at any point. Thus, you can make use of a wide variety of apps for your sites.