InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it offers a better overall performance and a faster crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by numerous web developers that create highly scalable apps, as it works more efficiently with immense data volumes, while it keeps the server load at a minimum. Moreover, it uses row-level locking in case any information should be updated, while lots of other engines lock the entire database table and hence require more time to handle several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for whatever reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest Joomla™ editions are two instances of widespread script-based applications that have shifted over to InnoDB.
InnoDB in Shared Hosting
Every PHP script-driven software application that requires InnoDB will function flawlessly on our leading-edge cloud platform and the MySQL database storage engine is offered with all our shared hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s requirements without having to change 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 make the most of its full potential. We’ll maintain regular content backups, so if you unintentionally remove a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore your data the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
You can install an open-source script-driven web application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our leading-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our 1-click application installer tool. In either case, the required engine will be selected automatically once the installation of the app begins, so you will not have to configure anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases in case you unintentionally delete one, as we create a few database backups every day, each of which is saved for 7 days.
InnoDB in VPS Hosting
If you order a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be an essential part of the software pack that will be pre-installed on your VPS server before we hand it over to you. You will not have to set up anything manually and you will be able to enable and manage any open-source script-based web app that needs InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission itself. Several engines are available, so whenever you set up a MySQL database via the Hepsia Control Panel, a particular engine will be activated when the app installation begins and our system will recognize the engine that is required by the application in question. If you have to use MyISAM, for example, you won’t have to do anything different than installing the preferred app, whether manually or using our application installer tool.
InnoDB in Dedicated Web Hosting
Our Hepsia Control Panel is one of the features that you can select on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of web hosting, it is pretty likely that you’ll run very popular Internet sites that will draw plenty of individuals, and since InnoDB is among the best choices for such Internet sites, we’ll activate it along with all the other software applications that come with a Hepsia-managed dedicated server. When you set up a brand new MySQL database in your dedicated account, there won’t be any active database storage engine till you begin installing an open-source script, whether manually through your web browser or using the automatic script installer that is integrated into the Control Panel. The needed engine will be automatically detected and will be set for the database in question, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having to deal with any problem.