InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved database crash recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by many programmers that create highly scalable software applications, because it works more effectively with enormous volumes of data, while it keeps the server load low. Also, it locks only one database row in case anything should be updated, while lots of other engines lock the entire table and hence require much more time to complete several sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla releases are two instances of widely used PHP-based applications which have switched over to InnoDB.

InnoDB in Shared Web Hosting

You can run any script-based web app that requires InnoDB if you’ve got a shared web hosting service with our company, as the MySQL storage engine is present on our leading-edge cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can activate applications that need the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be pre-selected, so you will not need to edit anything manually at any point. On top of that, we’ll also perform regular backups of all the databases that you have in your account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the Control Panel provided with all our semi-dedicated server accounts and you start installing a PHP script-powered app either manually or using our one-click app installer, the storage engine for the MySQL database will be selected automatically depending on the requirements of the specific application. As InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any moment. To prevent any risk of losing info if you update an app or if you remove a database by accident, we’ll carry out backups of all your MySQL databases each and every day, so if something goes wrong, we can recover your content.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an integral part of the standard software package that will be installed on your VPS server before we hand it over to you. You won’t have to configure anything manually and you’ll be able to install and run any open-source script-powered app that needs InnoDB as soon as your VPS is up and running, which takes no more than one hour after the order process itself. A couple of engines are offered, so every time you set up a MySQL database through the Hepsia hosting Control Panel, a specific engine will be activated when the app installation commences and our system will automatically recognize which engine is required by the app in question. In case you need MyISAM, for instance, you will not have to do anything different from installing the application of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features that you can pick on the order form when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it is pretty likely that you’ll run very popular Internet sites that will draw lots of visitors, and since InnoDB is one of the very best options for such Internet sites, we will activate it along with all the other software applications that are available with a Hepsia-managed server. When you create a new database in your dedicated account, there won’t be any activated storage engine till you start installing a script, whether manually via your Internet browser or using the automatic script installation tool that is integrated into the Control Panel. The needed engine will be automatically detected and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without running into any obstacle.