InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got numerous advantages which make it the engine of choice for plenty of PHP-driven applications, including Joomla and Magento, which have switched to InnoDB permanently. For example, importing immense data volumes will be faster with InnoDB, since it locks only a single row to carry out a specific operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. In simpler words, adding new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a given issue appears during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Hosting

InnoDB is offered with all our Linux hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP-driven web application which needs the MySQL database engine without having any difficulty as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation process, no matter if you make use of our single-click installation tool or create the database and activate the application manually, as long as the application requires it instead of the more famous MyISAM engine. We’ll keep regular backups of all your MySQL databases, so you can be certain that you’ll never lose any content in case you delete a database by accident or you overwrite some vital info – you’ll simply have to contact us and we will restore everything the way it was.

InnoDB in Semi-dedicated Hosting

You can activate a PHP script-based application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our leading-edge cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click application installer. In either case, the required engine will be picked automatically the moment the activation of the app starts, so you will not need to modify anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases if you delete one by mistake, as we create a couple of backups every day, each of which is stored for seven days.