InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has many strengths which make it the engine of choice for a lot of open-source script-driven applications, such as Magento and Joomla™, which have switched to InnoDB permanently. For example, importing large amounts of data will be faster with InnoDB, because it locks only one row to carry out an operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. Simply put, importing new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some issue occurs in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

InnoDB is available with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you will be able to install and manage any script-based application which requires the MySQL storage engine without any problems as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation, irrespective of whether you make use of our single-click installation tool or create the database and install the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll generate regular MySQL database backups, so you can rest assured that you will never lose any data if you erase a database by mistake or you overwrite some vital information – you’ll simply need to notify us and we will restore everything the way it was.

InnoDB in Dedicated Servers Hosting

If you order a new dedicated server, you’ll be able to choose any of the 3 Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to enable this storage engine manually to be able to run PHP-driven web apps that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need in order to run large-scale Internet sites, it is very likely that you’ll resort to InnoDB. You will be able to make use of other engines too, so in case a specific app requires MyISAM rather than InnoDB, you will not run into any impediment while managing it. The engine that will be used will be recognized automatically when the app installation procedure starts, so you will not need to edit any settings manually at any point.