InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has numerous pluses which have made it the preferred engine for numerous PHP-powered applications, such as Joomla and Magento, which have switched over to InnoDB permanently. For example, importing enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single row to perform a particular operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is tackled. Simply put, adding new or updating existing data will either be fully completed, or will be aborted and the operation will be rolled back if some issue occurs during the process, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any PHP script-driven app that needs the InnoDB database storage engine without encountering any problem 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 1-click installation tool or create the database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We will create regular backups of all your MySQL databases, so you can be sure that you’ll never lose any content if you erase a database by mistake or you overwrite some essential info – you will just need to alert us and we will restore your content the way it was.

InnoDB in Dedicated Servers Hosting

If you buy a new dedicated server, you will be able to choose one of the 3 hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to add this MySQL database storage engine manually in order to be able to use PHP-powered software apps that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the resources that you need to run very large sites, it is quite likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a specific app needs MyISAM instead of InnoDB, you won’t need to deal with any difficulty while managing it. The engine that will be used will be automatically recognized the moment the app installation process starts, so you won’t need to fine-tune any setting manually at any moment.