InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous programmers that write scalable web applications, because it works much more effectively with huge amounts of data, while it keeps the server processing load low. Moreover, it it locks only one row in the database if any info should be updated, while many other engines lock the entire table and therefore require more time to handle multiple successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the latest Joomla™ releases are two examples of famous PHP script-based software apps which have moved to InnoDB.
InnoDB in Hosting
Any PHP-based application that requires InnoDB will run flawlessly on our innovative cloud web hosting platform and the database storage engine is available with all our hosting packages. 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 use will be selected in accordance with the app’s prerequisites without the need to update 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 create regular content backups, so in case you accidentally erase a MySQL database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting plans come with InnoDB and you’ll be able to take advantage of all the options offered by this MySQL storage engine with any script-powered web application that requires it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the given application. You will not need to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we’ll carry out regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some content by accident, we will be able to restore your database the way it was on any of the previous seven days.
InnoDB in VPS Servers
When you order a VPS server from us, you will be able to use our in-house built Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will permit you to install any PHP-powered app which needs InnoDB, as the storage engine is an essential part of the default software package that will be installed on your Virtual Private Server during its setup. When you create a brand-new database via the hosting Control Panel, you’ll just need to start installing an app – manually or using our application installer. InnoDB will be set as the default engine as long as the application in question needs it, so you will not have to do anything else in your VPS account. Analogously, if an app requires MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the default software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is up and running, you’ll be able to sign in and to activate any script-driven web application that requires this particular storage engine. When you create a new database via the Control Panel, there won’t be any active engine until you start installing an application. Once the app installation wizard begins entering content into the newly created database, the engine will be picked automatically based on the prerequisites of the specific application, so you can run both InnoDB and MyISAM without the need to select either of them explicitly at any moment. Therefore, you can make use of an immense selection of applications for your sites.