What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous devs that write scalable web apps, due to the fact that it works more efficiently with huge volumes of data, while it keeps the server processing load at a minimum. In addition, it uses row-level locking in case anything should be updated, while many other engines lock the entire table and thus need much more time to fulfill multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ versions are two instances of widely used PHP-powered applications which have shifted over to InnoDB.
InnoDB in Hosting
Any PHP-powered application that needs InnoDB will run impeccably on our cutting-edge cloud hosting platform and the database storage engine is available with all our hosting
packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without the need to modify any setting in your account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to get the most out of its full potential. We will maintain regular backups of your content, so in case you unintentionally remove a database that you need or you overwrite a certain part of it, we’ll be able to restore everything the way it was only a couple of hours ago.
InnoDB in Dedicated Servers
If you acquire a new dedicated server
, you will be able to choose one of the three hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to install this database storage engine manually in order to be able to manage PHP-powered apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you need to manage very large websites, it is quite likely that you’ll use InnoDB. You will be able to make use of other engines as well, so if a particular app requires MyISAM rather than InnoDB, you won’t encounter any problem while running it. The engine that will be used will be automatically recognized as soon as the app installation procedure begins, so you won’t have to fine-tune any setting manually whatsoever.