InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-based applications such as Joomla 3.x and Magento. It’s perfect for scalable applications, as it performs unbelievably well when processing enormous amounts of data. Rather than locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same period of time. Also, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that determine how data imports and updates should be handled. If a certain operation has not been fully completed for some reason, the action will be rolled back. In this way, the information in the database will be preserved undamaged and won’t be partially mixed with newly inserted content.
InnoDB in Hosting
Every PHP-driven web application that requires InnoDB will run flawlessly on our advanced cloud web hosting platform and the MySQL database storage engine is offered with all our hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to edit any setting in your account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We will create regular backups of your content, so if you unintentionally erase a database that’s important to you or you overwrite some part of it, we will be able to restore your data the way it was just several hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server plans and you start installing a script-based application either manually or using our one-click app installer tool, the database storage engine will be picked automatically based on the particular app’s requirements. As InnoDB is available on the cloud platform where your new semi-dedicated server 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 moment. To avoid any risk of losing information if you update an app or if you remove a database unintentionally, we’ll make a backup of all your databases every day, so if anything goes wrong, we can restore your data.
InnoDB in Dedicated Web Hosting
If you order a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to enable this database engine manually in order to be able to run open-source script-based apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you need in order to run large-scale Internet sites, it is very possible that you’ll use InnoDB. You will be able to make use of other engines as well, so in case a certain app needs MyISAM instead of InnoDB, you won’t encounter any complication while running it. The engine that will be used will be detected automatically the moment the app installation procedure begins, so you won’t need to edit any setting manually at any time.