InnoDB is a storage engine for MySQL relational databases, which is used by popular script-based web apps like Joomla™ 3.x and Magento. It is ideal for scalable apps, because it performs remarkably well when processing immense volumes of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same length of time. Also, InnoDB offers a much faster database failure recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be treated. If a particular task has not been fully completed for whatever reason, the action will be rolled back. Thus, the database content will remain safe and sound and will not be partially merged with newly inserted content.
InnoDB in Shared Hosting
Every PHP script-powered app that requires InnoDB will run impeccably on our innovative cloud platform and the database engine comes with all our shared hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s requirements without having to update any setting in your shared account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We will make daily backups of your content, so in case you accidentally erase a database that you need or you overwrite some part of it, we will be able to restore the database the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you begin installing a PHP script-powered web app either manually or using our 1-click application installer tool, the storage engine for the database will be selected automatically on the basis of the particular app’s prerequisites. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that requires it without any manual action needed on your end at any point. To prevent any risk of losing data if you update an app or if you erase a database accidentally, we will perform backups of all your databases each day, so if something happens, we can recover your content.
InnoDB in VPS Servers
If you buy a VPS server from our company, you will be able to use our custom Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any PHP script-driven software app that needs InnoDB, as this particular MySQL database storage engine is an integral part of the software package that will be pre-installed on the server during its creation. When you create a brand new database through the hosting Control Panel, you’ll simply have to start installing an app – manually or using our application installer. InnoDB will be set as the default engine if the application in question requires it, so you won’t have to do anything else in your VPS account. Similarly, if an application needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
If you get a new dedicated server, you’ll be able to select one of the 3 hosting Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to activate this MySQL storage engine manually to be able to manage script-driven web applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the server resources that you require to run large-scale Internet sites, it’s very possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so if a given application requires MyISAM instead of InnoDB, you will not need to deal with any problem while using it. The engine that will be used will be recognized automatically when the app installation begins, so you will not need to update any settings manually at any time.