InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a significantly better overall performance and a faster crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by lots of programmers that run scalable web applications, due to the fact that it works better with immense amounts of data, while it keeps the server processing load low. Also, it uses row-level locking if anything should be modified, while many other engines lock the entire database table and thus require much more time to carry out several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification cannot be completed for whatever reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest Joomla versions are two instances of widespread PHP-powered software applications that have switched over to InnoDB.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other website hosting service providers, it is an essential part of the default set of services that we’re offering with our cloud web hosting packages. If you’d like to use a PHP script-powered web app that requires InnoDB in particular, in order to be installed and to operate correctly, you will not have any obstacles as the InnoDB storage engine is available on our in-house built cloud web hosting platform. Regardless of whether you set up a new MySQL database and install an app manually or make use of our one-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the given app needs InnoDB instead of MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also perform regular backups of all databases, so we can swiftly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing a PHP script-driven web app either manually or using our one-click application installer, the storage engine for the database will be selected automatically based on the prerequisites of the particular app. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that requires it without any manual intervention required on your end at any point. To prevent any chance of losing information if you update an app or if you erase a database by accident, we’ll generate a backup of all your MySQL databases every day, so if something happens, we can retrieve your content.

InnoDB in VPS Hosting

If you get a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an indivisible part of the default software pack that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to configure anything manually and you will be able to enable and run any PHP-based software application that requires InnoDB once your Virtual Private Server is up and running, which takes no more than 1 hour after the order process itself. Several engines are available, so anytime you set up a MySQL database via the Hepsia Control Panel, a particular engine will be selected when the app activation process commences and our system will automatically recognize the engine that is required by the app in question. In case you need to use MyISAM, for instance, you will not need to do anything different than installing the desired application, whether manually or using our app installer tool.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is one of the options which you can pick on the server configuration page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it’s rather likely that you will run very popular websites that will draw a lot of individuals, and since InnoDB is one of the best options for such Internet sites, we will enable it together with all the other software applications that are offered with a Hepsia-equipped server. When you create a new MySQL database in your dedicated server account, there won’t be any active database engine until you start installing a PHP script, whether manually via your browser or using the automatic scripts installer tool that is available in the hosting Control Panel. The required engine will be automatically detected and will be set for that database, so you can make use of scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without the need to deal with any complication.