InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP script-driven web apps like Joomla 3.x and Magento. It’s ideal for scalable applications, as it works exceptionally well when managing enormous data volumes. Instead of locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. Moreover, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that define how data inserts and modifications should be treated. If a particular task has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved safe and sound and will not be partially mixed with newly appended content.

InnoDB in Shared Website Hosting

InnoDB is offered with all our shared website hosting by default, not upon request or as a paid upgrade, so you can install and manage any open-source script-powered web app which needs the MySQL database storage engine without the need to deal with any problem as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation process, irrespective of whether you use our 1-click installation tool or create the database and set up the app manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll carry out daily backups of all your databases, so you can be sure that you will never lose any data if you erase a database by mistake or you overwrite some important information – you’ll simply need to inform us and we will restore your data back to normal.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the Control Panel provided with all our semi-dedicated server plans and you begin installing an open-source script-powered web app either manually or using our 1-click app installer tool, the database storage engine will be picked automatically based on the requirements of the particular app. As InnoDB is present on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any moment. To prevent any chance of losing info if you update an app or if you erase a database unintentionally, we’ll perform backups of all your databases each day, so if anything goes wrong, we can recover your data.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to select any of the three hosting Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database storage engine manually to be able to use PHP script-powered apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you need to run very large Internet sites, it’s pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines as well, so in case a specific app needs MyISAM instead of InnoDB, you will not have any difficulty while managing it. The engine that will be used will be recognized automatically once the app installation process begins, so you will not need to alter any setting manually whatsoever.