InnoDB is a database engine for MySQL relational databases, which is used by widely used PHP script-based applications such as Magento and Joomla v3. It is ideal for scalable apps, because it performs amazingly well when processing enormous amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same period of time. Furthermore, InnoDB offers an improved crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and updates should be treated. If a given operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and won’t be partially mixed with newly added content.

InnoDB in Cloud Hosting

You will be able to install any PHP script-powered software application that requires InnoDB in case you’ve got a cloud plan with our company, as the MySQL storage engine is available on our leading-edge cloud web hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is required. You can run applications that use the MyISAM engine without any difficulty as well and, once again, the engine will be pre-selected, so you will not need to change any setting manually at any time. Furthermore, we will also make daily backups of all the MySQL databases that you’ve got in your account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-driven software app that needs this MySQL database storage engine without needing to configure anything manually. You can select Hepsia on the VPS configuration page and your brand-new Virtual Private Server will be up and running within 60 minutes, so you can log in and begin creating your Internet sites right away. Once you create a brand-new MySQL database and begin the app installation process, our system will pick the engine for that database automatically. Thus, you can install different applications at the same time without having to configure anything on the server. You can have a WordPress-powered personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-commerce site that uses InnoDB, for example.