InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of web developers that run scalable web applications, since it works much better with enormous data volumes, while it keeps the server processing load at a minimum. Additionally, it it locks only one row in the database in case any info should be edited, while many other engines lock the entire table and hence require much more time to fulfill multiple successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to prevent scrambling or losing data. Magento and the latest Joomla versions are two instances of famous PHP script-powered apps that have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting by default, not upon request or as a paid upgrade, so you can install and manage any script-based software application which requires the MySQL storage engine without the need to deal with any obstacle once you open your account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation, regardless of whether you use our single-click installation tool or create the database and activate the app manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll maintain regular database backups, so you can be sure that you will never lose any content in case you erase a database unintentionally or you overwrite some vital info – you’ll just have to touch base with us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our semi-dedicated servers by default, so the moment you obtain a new semi-dedicated account, you can go on and install any script-based software application that needs the MySQL storage engine. A few engines are installed on our cloud website hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen depending on the prerequisites of the given app. This will permit you to activate and manage InnoDB-specific apps without having to cope with any obstacle and without needing to configure any settings in your account. To be on the safe side, we’ll always have a seven-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can swiftly recover it.

InnoDB in VPS Servers

If you get a VPS server from us, you will be able to use our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any PHP script-driven web app which requires InnoDB, as this database engine is included in the software package that will be pre-installed on the VPS server during its creation. When you create a brand-new database using the Control Panel, you will simply have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question needs it, so you will not have to do anything else in your VPS account. Identically, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you will be able to pick one of the 3 Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to add this database storage engine manually to be able to run script-powered software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you need to run very large sites, it is pretty likely that you’ll resort to InnoDB. You will be able to make use of other engines too, so if a particular application requires MyISAM rather than InnoDB, you won’t run into any impediment while using it. The engine that will be used will be detected automatically as soon as the app installation procedure commences, so you will not need to modify any settings manually at any moment.