InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by plenty of web developers that build highly scalable software apps, as it works much more effectively with enormous amounts of data, while it keeps the server processing load low. Also, it locks only a single row in the database in case any information should be updated, while many other engines lock the entire table and hence need much more time to complete several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla versions are two examples of widely used script-powered software apps that have shifted over to InnoDB.

InnoDB in Web Hosting

Every script-powered application that requires InnoDB will run flawlessly on our avant-garde cloud platform and the MySQL storage engine is offered with all our web hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without having to edit any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will maintain regular backups of your content, so if you accidentally delete a database that’s important to you or you overwrite a certain part of it, we will be able to restore your content the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can use a PHP-based software application that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our cutting-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our one-click app installer. In either case, the needed engine will be picked automatically once the installation of the app starts, so you will not need to modify anything manually, no matter if the application requires InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you accidentally delete one, as we perform several database backups every day, each of which is preserved for one week.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the default software pack that will be installed on your server before we hand it over to you. You will not have to configure anything manually and you’ll be able to enable and use any PHP-driven web application that requires InnoDB as soon as your VPS server is set up, which takes no more than one hour after the order submission process itself. Several engines are offered, so anytime you set up a database via the Hepsia hosting Control Panel, a particular engine will be selected when the app installation process begins and our system will automatically detect which engine is required by the app in question. In case you need MyISAM, for example, you won’t need to do anything different from installing the chosen application, whether manually or using our application installer.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is ready, you’ll be able to log in and to activate any script-powered web application that requires this database engine. When you set up a new MySQL database through the Control Panel, there won’t be any active engine till you start installing an app. As soon as the app activation wizard begins importing data into the newly created database, the engine will be set automatically on the basis of the prerequisites of the specific app, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any moment. In this way, you can use a broad selection of apps for your websites.