InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by plenty of programmers that create highly scalable web apps, due to the fact that it works more efficiently with enormous data volumes, while it keeps the server processing load low. Furthermore, it locks only a single row in the database if any information should be updated, whereas many other engines lock the entire database table and hence need much more time to handle multiple consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest versions of Joomla are two examples of widely used PHP-powered web applications which have shifted over to InnoDB.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP-driven web app that requires the database storage engine without having to deal with any impediment as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation process, regardless of whether you take advantage of our 1-click installation tool or create the MySQL database and set up the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We’ll perform daily MySQL database backups, so you can rest assured that you will never lose any content in case you erase a database by accident or you overwrite some key info – you’ll simply need to contact us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database from the Control Panel provided with all our semi-dedicated server packages and you begin installing a PHP-powered application either manually or using our 1-click application installer tool, the storage engine for the database will be picked automatically based on the requirements of the specific application. As InnoDB is present on the cloud hosting platform where your new account will be created, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any point. To avoid any chance of losing info if you update an application or if you erase a database accidentally, we will generate a backup of all your MySQL databases every day, so if anything happens, we can recover your content.
InnoDB in Dedicated Hosting
InnoDB is included by default with all dedicated hosting that are ordered with the Hepsia Control Panel. It is part of the default software bundle that will be installed on all Hepsia-equipped dedicated servers, so once your machine is ready, you will be able to sign in and to install any PHP script-powered web app that needs this MySQL database storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard begins entering content into the database, the engine will be selected automatically on the basis of the prerequisites of the app in question, so you can use both InnoDB and MyISAM without the need to select either one of them explicitly at any time. Thus, you can make use of a wide collection of applications for your sites.