InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it offers a much better overall performance and an improved database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is endorsed by lots of programmers that write highly scalable web apps, since it works much more efficiently with immense data volumes, while it keeps the server processing load low. Additionally, it it locks only one row in the database if any information should be modified, while many other engines lock the entire database table and hence require more time to execute several sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for any reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest versions of Joomla™ are two instances of widespread PHP script-powered web applications that have switched to InnoDB.

InnoDB in Shared Web Hosting

You will be able to use any PHP-based web app that needs InnoDB if you have a Linux shared web hosting package with us, as the MySQL database storage engine is available on our leading-edge cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can activate applications that use the MyISAM engine without encountering any impediment as well and, again, the engine will be pre-selected, so you won’t have to modify any setting manually at any time. In addition, we will also create daily backups of all the databases that you have in your shared web hosting account, so if you delete or overwrite anything, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the hosting Control Panel offered with all our semi-dedicated server accounts and you start installing an open-source script-based web app either manually or using our 1-click application installer, the storage engine for the database will be selected automatically on the basis of the prerequisites of the given app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that needs it without any manual action required on your end at any time. To prevent any chance of losing information if you update an app or if you delete a database accidentally, we will generate a backup of all your MySQL databases each and every day, so if something happens, we can recover your content.

InnoDB in Dedicated Hosting

InnoDB is included as standard with all Linux dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It’s an essential part of the software package that will be installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is up and running, you will be able to sign in and to activate any type of PHP script-powered app that needs this storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app activation wizard begins entering data into the newly created database, the engine will be selected automatically depending on the prerequisites of the app in question, so you can run both InnoDB and MyISAM without having to select either one of them explicitly at any point. In this way, you can make use of an extensive selection of apps for your Internet sites.