InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and a faster database failure recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by numerous developers that create highly scalable applications, as it works more efficiently with enormous volumes of data, while it keeps the server load at a minimum. Also, it locks only a single row in the database in case anything should be edited, while lots of other engines lock the entire table and hence need more time to execute multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla versions are two instances of famous PHP-driven software platforms that have moved to InnoDB.
InnoDB in Hosting
InnoDB is available with all our hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-based app that needs the InnoDB database storage engine without having any difficulty as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our one-click installer or create the database and install the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll perform daily database backups, so you can be sure that you’ll never lose any data if you erase a database by mistake or you overwrite some essential info – you’ll just need to contact us and we will restore your content back to normal.
InnoDB in Semi-dedicated Servers
You can activate an open-source script-based web application that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our innovative cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our single-click app installer tool. Either way, the required engine will be chosen automatically once the activation of the application begins, so you won’t have to edit anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you accidentally delete one, as we carry out several backups every day, each of which is preserved for seven days.
InnoDB in VPS Servers
If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the software pack that will be pre-installed on your server before we give it to you. You will not have to activate anything manually and you will be able to install and run any script-based web application that needs InnoDB when your VPS is up and running, which takes no more than 60 minutes after the order submission procedure itself. A couple of engines are available, so anytime you create a MySQL database via the Hepsia Control Panel, a particular engine will be selected once the app activation begins and our system will automatically recognize the engine that is required by the app in question. In case you have to use MyISAM, for example, you won’t need to do anything different from installing the application of your preference, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It is included in the default software package that will be installed on all Hepsia-managed servers, so once your machine is up and running, you will be able to log in and to activate any type of PHP-driven software application that needs this MySQL database engine. If you set up a new MySQL database through the Control Panel, there won’t be any active engine till you begin installing an app. Once the app setup wizard starts importing data into the database, the engine will be set automatically on the basis of the given app’s requirements, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any moment. Thus, you can make use of a vast variety of apps for your websites.