InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based applications such as Joomla 3 and Magento. It’s perfect for scalable applications, because it performs astonishingly well when managing enormous data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be handled. In case a given task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved intact and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
Any open-source script-powered application that requires InnoDB will run flawlessly on our innovative cloud hosting platform and the MySQL storage engine is available with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll make regular content backups, so if you unintentionally erase a MySQL database that you need or you overwrite some part of it, we will be able to restore your content the way it was only a few hours ago.
InnoDB in Semi-dedicated Hosting
You can make use of a script-based web app that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click application installer tool. In either case, the needed engine will be selected automatically once the installation of the application begins, so you will not need to update anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you unintentionally delete one, as we create several MySQL database backups every day, each of which is stored for one week.