InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a significantly better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL database management system – MyISAM. InnoDB is used by a lot of programmers that build scalable web apps, as it works more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. In addition, it uses row-level locking in case any info should be modified, whereas lots of other engines lock the entire database table and thus require more time to accomplish several successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest releases of Joomla are two examples of famous PHP script-driven applications which have switched 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 activate and manage any script-driven web app that needs the database storage engine without the need to deal with any complication once you activate your account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, no matter if you use our single-click installer or create the MySQL database and set up the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will maintain regular backups of all your MySQL databases, so you can be sure that you won’t ever lose any content in case you erase a database unintentionally or you overwrite some important information – you will simply have to alert us and we will restore the database back to normal.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to select any of the 3 hosting Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to enable this MySQL storage engine manually to be able to use open-source script-based applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you require to manage very large sites, it’s quite possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so in case a particular app requires MyISAM instead of InnoDB, you won’t experience any impediment while managing it. The engine that will be used will be recognized automatically the moment the app installation procedure commences, so you won’t have to fine-tune any settings manually at any point.