InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a better overall performance and a faster database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is used by a lot of web developers that build scalable software apps, due to the fact that it works more effectively with immense data volumes, while it keeps the server load low. Also, it it locks only one row in the database in case anything should be updated, while many other engines lock the entire database table and therefore need much more time to accomplish several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the modification of the entire data cannot be completed for any reason, the action is rolled back to prevent confusion or losing data. Magento and the newest Joomla™ versions are two examples of famous open-source script-based apps which have shifted over to InnoDB.

InnoDB in Shared Hosting

You’ll be able to activate any PHP-driven web application that requires InnoDB in case you’ve got a shared plan with our company, as the MySQL database storage engine is available on our cutting-edge cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can run apps that need the MyISAM engine without encountering any impediment as well and, again, the engine will be pre-selected, so you will not need to modify anything manually at any time. On top of that, we’ll also perform daily backups of all the databases that you’ve got in the shared account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you begin installing a script-driven software app either manually or using our one-click app installer, the database storage engine will be picked automatically depending on the prerequisites of the given app. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any moment. To avoid any chance of losing info if you update an app or if you delete a database by mistake, we’ll generate a backup of all your databases every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Servers

All VPS hosting plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to use any PHP-driven app that requires this particular MySQL database engine without needing to install anything manually. You can choose Hepsia on the VPS configuration page and your brand new VPS server will be ready within 60 minutes, so you can log in and start building your web sites right away. When you create a brand new MySQL database and begin the app installation process, our system will set the engine for this database automatically. Thus, you can activate various apps at the same time without having to change anything on the server. You can create a WordPress personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-powered e-shop that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t need to install it manually if you need to use open-source scripts that need it. All it takes to run such a script is to create a new MySQL database and to start the setup process – once the script setup wizard obtains access to the database and starts dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that require MyISAM, the other widely used MySQL engine, so you will not need to change any settings on the dedicated server. This will enable you to run different scripts on a single physical server and to use the latter to its fullest potential.