InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by many developers that build highly scalable apps, as it works much more effectively with huge amounts of data, while it keeps the server processing load low. Moreover, it locks only a single database row if any information should be edited, while many other engines lock the entire table and hence require more time to complete multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla™ versions are two examples of popular PHP-powered software platforms that have shifted over to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP-driven web application which requires the MySQL database engine without the need to deal with any problem as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation process, irrespective of whether you make use of our 1-click installation tool or create the database and activate the application manually, provided that the application requires it instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can be certain that you’ll never lose any content in case you delete a database unintentionally or you overwrite some vital information – you simply need to inform us and we will restore your content back to normal.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated servers by default, so once you purchase a new account, you can move on and install any script-powered web application that needs this particular MySQL database storage engine. A few engines are pre-installed on our cloud platform, so when you create a brand new MySQL database and start installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen depending on the requirements of the respective app. This will allow you to activate and manage InnoDB-specific apps without having to cope with any problem and without the need to change any settings in your account. To take no chances, we’ll always keep a 1-week-old backup of all your databases, so if you delete or alter any content by accident, we can easily recover it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to use any PHP-based software app that requires this particular MySQL database engine without having to set up anything manually. You can choose Hepsia on the VPS order form and your brand-new Virtual Private Server will be up and running within 60 minutes, so you can sign in and start building your Internet sites straight away. Once you set up a new MySQL database and start the app activation process, our system will choose the engine for this MySQL database automatically. In this way, you can install different applications simultaneously without editing anything on the VPS server. You can set up a WordPress-driven weblog that uses MyISAM – the default MySQL engine, and a Magento-driven e-store that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you would like to run open-source PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the setup – as soon as the installer wizard receives access to the database and begins entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You will also be able to activate scripts that require the other widely used MySQL engine – MyISAM, so you won’t have to configure any settings on the server. This will permit you to use a variety of scripts on one single server and to use it to its fullest potential.