InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a better overall performance and an improved database crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by a lot of web developers that write scalable apps, because it works much better with large data volumes, while it keeps the server load at a minimum. Furthermore, it uses row-level locking if anything should be edited, whereas lots of other engines lock the entire database table and hence require much more time to accomplish several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla are two instances of popular PHP-based software platforms which have switched over to InnoDB.

InnoDB in Cloud Hosting

You will be able to use any script-driven web app that needs InnoDB if you’ve got a cloud hosting with our company, as the database storage engine is present on our innovative cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can install apps which need the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t have to configure anything manually at any time. On top of that, we’ll also perform regular backups of all the databases that you’ve got in your shared account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the hosting Control Panel offered with all our semi-dedicated server accounts and you begin installing a PHP-based web app either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically depending on the particular app’s requirements. Since InnoDB is present on the cloud 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 requires it without any manual intervention needed on your end at any moment. To prevent any risk of losing info if you update an app or if you delete a database accidentally, we will carry out a backup of all your databases each and every day, so if anything goes wrong, we can recover your content.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an indivisible part of the default software package that will be pre-installed on your VPS server before we give it to you. You won’t have to configure anything manually and you’ll be able to enable and manage any open-source script-powered software application that needs InnoDB as soon as your VPS server is set up, which takes no more than 1 hour after the order process itself. A few engines are available, so every time you create a MySQL database using the Hepsia hosting Control Panel, a specific engine will be picked when the app installation process commences and our system will automatically detect which engine is required by the app in question. If you need MyISAM, for instance, you won’t have to do anything different than installing the chosen application, whether manually or using our app installer.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to pick any of the three Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL database storage engine manually to be able to run PHP script-based web apps that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you need in order to run large-scale websites, it’s quite possible that you’ll use InnoDB. You’ll be able to use other engines as well, so if a specific app needs MyISAM rather than InnoDB, you will not have to deal with any obstacle while using it. The engine that will be used will be recognized automatically the moment the app installation begins, so you will not have to change any setting manually at any time.