InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and a faster crash recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by a lot of devs that run scalable web applications, because it works more efficiently with huge data volumes, while it keeps the server load low. Additionally, it locks only a single database row if any information should be modified, while lots of other engines lock the entire database table and thus need much more time to fulfill several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest releases of Joomla are two examples of widely used PHP-powered software platforms which have moved to InnoDB.

InnoDB in Shared Hosting

Every script-based app that requires InnoDB will function impeccably on our cutting-edge cloud platform and the MySQL storage engine comes with all our shared hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected on the basis of the app’s prerequisites without the need to modify any setting in your account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We will store daily backups of your content, so if you accidentally remove a MySQL database that you need or you overwrite a specific part of it, we will be able to restore your database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server packages and you begin installing a script-based web app either manually or using our 1-click application installer tool, the database storage engine will be set automatically on the basis of the particular app’s requirements. As InnoDB is available on the cloud platform where your new account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any moment. To avoid any chance of losing data if you update an app or if you erase a database unintentionally, we’ll carry out backups of all your databases each and every day, so if anything happens, we can restore your data.

InnoDB in VPS

When you purchase a virtual private server from us, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to run any script-powered web app that requires InnoDB, as this particular MySQL storage engine is an integral part of the software package that will be pre-installed on your Virtual Private Server during its configuration. When you set up a brand-new database through the hosting Control Panel, you just need to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you will not have to do anything else in your VPS account. Analogously, if a given app needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Hosting

If you acquire a new dedicated server, you’ll be able to select any of the three Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this MySQL storage engine manually to be able to use open-source script-powered software apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the server resources that you require in order to run large-size websites, it is very possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a certain app needs MyISAM instead of InnoDB, you won’t have to deal with any obstacle while using it. The engine that will be used will be automatically detected as soon as the app installation begins, so you won’t have to fine-tune any settings manually whatsoever.