InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP-driven web apps such as Joomla 3 and Magento. It is ideal for scalable applications, since it works stunningly well when processing large amounts of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. Besides, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data imports and updates should be treated. If a particular operation has not been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially merged with new content.
InnoDB in Cloud Hosting
You can install any open-source script-powered web app that needs InnoDB in case you have a Linux cloud package with our company, as the MySQL database engine is available on our leading-edge cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can activate apps that need the MyISAM engine without having to deal with any obstacle as well and, again, the engine will be pre-selected, so you will not have to modify any setting manually at any moment. What’s more, we will also make daily backups of all the MySQL databases that you’ve got in the shared hosting account, so if you delete or overwrite anything, we can easily restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server plans and you start installing a PHP-based web application either manually or using our 1-click app installer, the storage engine for the database will be set automatically based on the given app’s requirements. Since InnoDB is present on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without the need for any manual intervention on your end at any point. To avoid any chance of losing data if you update an application or if you delete a database by accident, we’ll carry out backups of all your MySQL databases each day, so if something happens, we can rescue your content.
InnoDB in VPS Hosting
If you order a virtual private server from us, you will be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to install any open-source script-powered web application which requires InnoDB, as this storage engine is an essential part of the default software bundle that will be installed on your server during its configuration. When you create a brand new MySQL database through the Control Panel, you simply have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t have to do anything else in your VPS account. Identically, if a certain application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Web Hosting
When you get a new dedicated server, you’ll be able to choose any of the 3 hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to add this database storage engine manually so as to be able to use PHP script-based software applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you need to manage very large Internet sites, it’s rather possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so in case a particular application needs MyISAM rather than InnoDB, you won’t have any problem while managing it. The engine that will be used will be automatically recognized when the app installation procedure commences, so you won’t have to update any settings manually at any time.