InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP-based web apps such as Joomla 3 and Magento. It is ideal for scalable apps, since it performs incredibly well when managing large amounts of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same period of time. Moreover, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – rules that prescribe how data imports and modifications should be treated. In case a certain task has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be retained undamaged and will not be partially merged with newly entered content.

InnoDB in Website Hosting

You will be able to activate any PHP-driven application that needs InnoDB if you have a Linux website hosting with our company, as the MySQL database engine is present on our innovative cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install applications that need the MyISAM engine without any problems as well and, again, the engine will be pre-selected, so you won’t have to modify anything manually at any moment. Furthermore, we’ll also create daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you delete or overwrite something, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our Linux semi-dedicated hosting by default, so as soon as you buy a new account, you can go on and activate any open-source script-based application that needs this MySQL database engine. A couple of engines are installed on our cloud web hosting platform, so when you create a brand new database and begin installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen based on the prerequisites of the particular app. This will permit you to install and run InnoDB-specific applications without coming across any impediment and without needing to change any settings in your semi-dedicated account. To be on the safe side, we will always keep a seven-day-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can quickly retrieve it.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our in-house built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to activate it manually in case you want to activate PHP scripts that require it. All it takes to activate such a script is to create a new database and to start the installation process – as soon as the setup wizard gets access to the database and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You will also be able to activate scripts that require MyISAM – the other popular MySQL engine, so you will not need to edit any settings on the dedicated server. This will permit you to use different scripts on a single physical server and to use it to its fullest capacity.