InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many web developers that create scalable software apps, since it works much more efficiently with immense volumes of data, while it keeps the server load at a minimum. In addition, it it locks only one row in the database in case any info should be modified, while lots of other engines lock the entire database table and hence require more time to perform multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest Joomla editions are two instances of widely used PHP-powered web apps which have switched over to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it’s an integral part of the standard set of services that we’re offering with our hosting plans. In case you would like to make use of a script-driven web app that requires InnoDB in particular, in order to be activated and to function correctly, you will not face any difficulties because the MySQL database engine is available on our custom-built cloud hosting platform. Irrespective of whether you create a brand-new database and activate an application manually or make use of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it instead of MyISAM. Besides the amazing crash recovery that InnoDB is offering, we also generate regular database backups, so that we can swiftly restore any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated servers by default, so as soon as you purchase a new account, you can go on and activate any open-source script-based software app that requires this MySQL database engine. A few engines are pre-installed on our cloud website hosting platform, so when you create a new database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen depending on the prerequisites of the given application. This will allow you to activate and run InnoDB-specific applications without the need to cope with any difficulty and without the need to modify any settings in your account. To avoid any risk, we will always keep a one-week-old backup of all your MySQL databases, so if you remove or alter any content unintentionally, we can easily recover it.

InnoDB in VPS Servers

If you obtain a VPS server from us, you’ll be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to install any PHP script-driven application which needs InnoDB, as the database storage engine is an integral part of the software bundle that will be installed on the VPS server during its setup. When you create a brand new database via the Control Panel, you’ll just need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t need to do anything else in your VPS account. Correspondingly, if an application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to choose one of the three hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to install this MySQL storage engine manually to be able to manage PHP script-based apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you need in order to run large-scale sites, it is very possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a particular application requires MyISAM rather than InnoDB, you will not encounter any complication while managing it. The engine that will be used will be recognized automatically the moment the app installation process starts, so you will not have to fine-tune any setting manually at any point.