InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database failure recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is used by a lot of programmers that create highly scalable apps, due to the fact that it works much better with enormous volumes of data, while it keeps the server load low. Moreover, it locks only a single row in the database in case any info should be updated, whereas many other engines lock the entire database table and therefore require much more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest editions of Joomla are two examples of famous PHP script-driven software apps which have moved to InnoDB.
InnoDB in Shared Website Hosting
While InnoDB is either not available or a paid upgrade with other hosting service providers, it’s included in the standard set of features that we’re offering with our shared website hosting packages. In case you’d like to use a PHP-based software application that needs InnoDB in particular, in order to be activated and to function correctly, you won’t come across any difficulties as the database engine is available on our custom-developed cloud platform. Regardless of whether you set up a new database and activate an application manually or take advantage of our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific application requires it instead of MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also carry out daily database backups, so we can easily recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-based web app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our leading-edge cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our one-click app installer. In either case, the required engine will be selected automatically as soon as the activation of the app begins, so you will not have to modify anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to retrieve any of your databases in case you accidentally delete one, as we generate a few backups every day, each of which is stored for one whole week.
InnoDB in VPS Web Hosting
If our in-house built Hepsia Control Panel is chosen during the registration process for your new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server together with other needed pieces of software, so you will not have to do anything if you choose to use script-based web applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a new database and start the app installation manually or using our one-click installer. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation will proceed flawlessly and the app can dump its content in that database. Thus, you can manage apps with different requirements regarding the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers Hosting
InnoDB is included as standard with all dedicated servers hosting that are ordered with the Hepsia hosting Control Panel. It’s an essential part of the standard software bundle that we install on all Hepsia-managed servers, so once your machine is ready, you’ll be able to log in and to install a various PHP script-powered app that requires this database engine. When you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine until you start installing an app. As soon as the app activation wizard starts importing information into the newly created database, the engine will be selected automatically on the basis of the requirements of the specific app, so you can use both InnoDB and MyISAM without selecting either one of them explicitly at any point. Thus, you can use an extensive range of apps for your sites.