InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a much better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by many web developers that build scalable web applications, due to the fact that it works much more effectively with huge volumes of data, while it keeps the server processing load at a minimum. In addition, it it locks only one row in the database if anything should be updated, whereas many other engines lock the entire table and therefore need much more time to carry out multiple sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for some reason, the action is rolled back to prevent confusion or losing data. Magento and the latest versions of Joomla are two instances of widely used PHP script-based software applications which have shifted over to InnoDB.
InnoDB in Web Hosting
Any PHP script-based application that requires InnoDB will run flawlessly on our cutting-edge cloud platform and the database storage engine is available with all our web hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to modify any setting in your account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We will perform regular content backups, so if you accidentally erase a database that you need or you overwrite some part of it, we’ll be able to restore everything the way it was only several hours ago.
InnoDB in Semi-dedicated Hosting
You can activate a PHP-powered software app that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our innovative cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click application installer. Either way, the required engine will be picked automatically once the app’s installation begins, so you will not have to configure anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. In addition, we will always be able to restore any of your databases in case you accidentally erase one, as we make a couple of MySQL database backups every day, each of which is saved for one whole week.
InnoDB in VPS Hosting
If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the default software pack that will be pre-installed on your VPS server before we give it to you. You won’t need to set up anything manually and you’ll be able to install and use any script-based web application that requires InnoDB once your VPS is set up, which takes no more than 60 minutes after the order submission itself. A couple of engines are available, so anytime you create a MySQL database using the Hepsia Control Panel, a particular engine will be picked when the app activation process starts and our system will automatically detect which engine is required by the app in question. If you need to use MyISAM, for example, you will not have to do anything different from 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 features that you can choose on the server configuration page when you purchase a dedicated server from us. Since this is the most powerful type of website hosting, it is very likely that you’ll run very popular websites that will draw lots of visitors, and since InnoDB is among the very best options for such websites, we will install it together with all the other software applications that are available with a Hepsia-managed dedicated server. When you create a new MySQL database in your dedicated server account, there won’t be any active MySQL database engine till you start installing a script, whether manually through your browser or using the automatic scripts installer tool that is included in the hosting Control Panel. The needed engine will be automatically detected and will be assigned to the database in question, so you can run scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without needing to deal with any problem.