InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a significantly better overall performance and an improved database crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous devs that run scalable web apps, due to the fact that it works much more effectively with large data volumes, while it keeps the server processing load at a minimum. Furthermore, it locks only a single row in the database in case anything should be edited, while many other engines lock the entire database table and thus require more time to accomplish several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for whatever reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest Joomla editions are two examples of widely used PHP-based web apps which have moved to InnoDB.

InnoDB in Shared Website Hosting

Every PHP script-based application that requires InnoDB will run flawlessly on our advanced cloud hosting platform and the MySQL database engine is offered with all our shared website hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s requirements without having to modify any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to take advantage of its full potential. We’ll perform regular backups of your content, so if you accidentally delete a database that’s important to you or you overwrite a certain part of it, we will be able to restore your content the way it was only several hours earlier.

InnoDB in VPS

If you purchase a virtual private server from us, you will be able to take full advantage of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to install any PHP-powered web application which needs InnoDB, as this MySQL database storage engine is an essential part of the standard software package that will be installed on the server during its setup. When you create a brand-new MySQL database through the Control Panel, you will just need to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine as long as the app in question requires it, so you will not need to do anything else in your VPS account. Likewise, if a given app needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is among the options that you can choose on the server order page when you purchase a dedicated server from our company. As this is the most powerful type of website hosting, it is very likely that you will run highly popular websites that will attract a lot of individuals, and since InnoDB is one of the best choices for such sites, we will enable it along with all the other software applications that are offered with a Hepsia-managed server. If you set up a brand-new database in your account, there won’t be any activated MySQL storage engine until you start installing a PHP script, whether manually via your Internet browser or using the automatic scripts installer tool that is included in the Control Panel. The necessary engine will be recognized and will be set for the database in question, so you can activate scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without the need to cope with any problem.