InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a much better overall performance and an improved crash recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of devs that create highly scalable web apps, due to the fact that it works more effectively with large amounts of data, while it keeps the server load at a minimum. What’s more, it it locks only one row in the database in case anything should be updated, whereas lots of other engines lock the entire table and thus require much more time to fulfill several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla versions are two examples of famous PHP script-based apps which have switched to InnoDB.

InnoDB in Cloud Web Hosting

Any script-driven application that needs InnoDB will run impeccably on our leading-edge cloud hosting platform and the MySQL database engine is available with all our cloud web hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s requirements without the need to configure any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to get the most out of its full potential. We will carry out regular backups of your content, so in case you accidentally remove a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore everything the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans come with InnoDB and you’ll be able to get the most out of all the options offered by this MySQL database engine with any script-based web app that needs it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the requirements of the app in question. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer. To be on the safe side, we will store daily backups of all your MySQL databases, so if something goes wrong after an update or if you remove some data unintentionally, we’ll be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Servers

If you acquire a VPS server from our company, you’ll be able to make use of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP-based web app which requires InnoDB, as this MySQL database storage engine is an essential part of the default software package that will be pre-installed on your VPS server during its configuration. When you set up a brand-new database via the Control Panel, you will simply have to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the app in question needs it, so you will not need to do anything else in your VPS account. Likewise, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not need to activate it manually in case you’d like to use scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the installation process – once the setup wizard acquires access to the database and starts dumping content in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that require MyISAM – the other very popular MySQL engine, so you will not have to edit any settings on the server. This will permit you to install various scripts on a single machine and to use the latter to its maximum capacity.