InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database failure recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of web developers that run scalable web applications, because it works better with enormous volumes of data, while it keeps the server processing load at a minimum. What’s more, it locks only a single row in the database if any information should be updated, whereas lots of other engines lock the entire database table and hence need much more time to accomplish multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest editions of Joomla™ are two instances of famous PHP script-based applications that have switched over to InnoDB.

InnoDB in Shared Web Hosting

Any open-source script-based software application that needs InnoDB will function impeccably on our cutting-edge cloud website hosting platform and the database storage engine is offered with all our shared web hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s requirements without having to change any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We’ll generate regular content backups, so in case you unintentionally erase a MySQL database that you need or you overwrite specific parts of it, we will be able to restore your data the way it was just a few hours ago.

InnoDB in VPS Hosting

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