InnoDB is a database engine for MySQL relational databases, which is used by popular PHP-driven web apps like Magento and Joomla 3.x. It’s ideal for scalable apps, since it excels in managing large data volumes. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. Additionally, InnoDB offers a much faster database failure recovery and supports database transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be handled. In case a certain operation has not been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially merged with newly entered content.
InnoDB in Shared Web Hosting
InnoDB is available with all our shared web hosting by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-driven app which requires the MySQL database engine without any difficulty once you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation, no matter if you make use of our 1-click installation tool or create the MySQL database and set up the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll carry out daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content if you delete a database unintentionally or you overwrite some essential info – you’ll simply have to inform us and we’ll restore everything the way it was.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server plans and you start installing an open-source script-based application either manually or using our single-click application installer, the database storage engine will be selected automatically on the basis of the given app’s prerequisites. Since InnoDB is available 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 requires it without any manual action required on your end at any point. To prevent any chance of losing info if you update an app or if you remove a database unintentionally, we’ll carry out backups of all your databases each day, so if anything goes wrong, we can restore your data.
InnoDB in Dedicated Servers
When you purchase a new dedicated server, you’ll be able to select any of the 3 Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to add this MySQL database storage engine manually to be able to run open-source script-powered software apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you need in order to manage very large sites, it is rather possible that you’ll use InnoDB. You will be able to use other engines too, so in case a certain app needs MyISAM rather than InnoDB, you won’t experience any complication while using it. The engine that will be used will be detected automatically when the app installation procedure commences, so you won’t need to alter any setting manually whatsoever.