InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved database crash recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of web developers that write scalable web apps, due to the fact that it works better with immense volumes of data, while it keeps the server load low. Additionally, it locks only a single database row if any info should be updated, while many other engines lock the entire database table and therefore require much more time to handle several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla are two examples of widely used PHP script-powered software apps that have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is available with all our web hosting by default, not as a paid upgrade or upon request, so you can install and run any script-powered software app which needs the InnoDB storage engine without having to deal with any obstacle once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app activation, regardless of whether you use our 1-click installation tool or create the database and activate the application manually, as long as the application requires it instead of the more famous MyISAM engine. We will create regular backups of all your databases, so you can be sure that you’ll never lose any content in case you delete a database accidentally or you overwrite some crucial information – you’ll just need to notify us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you will be able to make use of all the options offered by this database storage engine with any PHP script-powered app that needs it. InnoDB is among the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the particular application. You will not need to do anything manually to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer. To avoid any risk, we’ll generate daily backups of all your databases, so if something goes wrong following some update or if you erase some content unintentionally, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to run any PHP-driven software application that requires this particular MySQL database storage engine without needing to install anything manually. You can pick Hepsia on the VPS order form and your brand new server will be ready within one hour, so you can sign in and start building your sites straight away. Once you create a brand-new MySQL database and begin the app installation process, our system will choose the engine for this database automatically. Thus, you can use different applications at the same time without updating anything on the VPS server. You can have a WordPress-powered weblog that uses the default MySQL engine – MyISAM, and a Magento-powered Internet shop that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

When you order a new dedicated server, you’ll be able to select one of the three Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to add this database engine manually so as to be able to run open-source script-based apps that require it. InnoDB is used by scalable applications and since a dedicated server will give you all the resources that you need to manage large-scale Internet sites, it is pretty possible that you’ll use InnoDB. You’ll be able to use other engines as well, so if a given app needs MyISAM rather than InnoDB, you won’t have to deal with any impediment while managing it. The engine that will be used will be detected automatically as soon as the app installation begins, so you will not have to modify any settings manually at any point.