InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a much better overall performance and a faster database crash recovery compared with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by a lot of programmers that write highly scalable software applications, due to the fact that it works better with immense amounts of data, while it keeps the server processing load at a minimum. In addition, it it locks only one row in the database if anything should be updated, while lots of other engines lock the entire database table and therefore need more time to execute multiple consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla editions are two instances of widespread script-based apps that have switched to InnoDB.

InnoDB in Cloud Web Hosting

You can make use of any PHP script-driven software application that requires InnoDB in case you have a cloud web hosting with our company, as the database storage engine is available on our cutting-edge cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can run apps that use the MyISAM engine without any impediments as well and, again, the engine will be pre-selected, so you will not have to edit any setting manually at any point. Furthermore, we will also carry out regular backups of all the MySQL databases that you’ve got in the account, so if you delete or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you start installing a PHP-based software app either manually or using our one-click application installer, the storage engine for the MySQL database will be picked automatically on the basis of the prerequisites of the specific application. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any time. To prevent any risk of losing data if you update an app or if you remove a database by accident, we will make backups of all your databases every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is chosen during the registration process for your new VPS plans , InnoDB will be activated on the server together with other essential software, so you will not have to do anything if you choose to make use of PHP-based web applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a brand-new database and begin installing the application manually or using our single-click installation tool. The system will recognize which engine the application in question needs and will set it for the specific database, so the installation will proceed flawlessly and the app can dump its data in that database. Therefore, you can activate applications with various requirements with regard to the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to pick one of the three Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to activate this MySQL database storage engine manually to be able to run script-based software applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require in order to run large-scale sites, it is quite likely that you’ll resort to InnoDB. You will be able to use other engines too, so in case a given app requires MyISAM rather than InnoDB, you will not come across any problem while managing it. The engine that will be used will be automatically detected the moment the app installation begins, so you will not need to configure any settings manually whatsoever.