InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by numerous developers that build scalable web apps, because it works better with enormous volumes of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking if anything should be edited, while many other engines lock the entire table and hence require much more time to fulfill several successive 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 scrambling or data loss. Magento and the newest versions of Joomla are two examples of widely used script-powered software platforms that have switched to InnoDB.

InnoDB in Shared Hosting

Any script-powered software application that requires InnoDB will function impeccably on our advanced cloud website hosting platform and the database engine is offered with all our shared hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without the need to configure any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will maintain daily content backups, so if you accidentally delete a MySQL database that you need or you overwrite certain parts of it, we will be able to restore your content the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the hosting Control Panel offered with each of our semi-dedicated server plans and you begin installing a PHP-based web app either manually or using our single-click app installer, the database storage engine will be set automatically based on the requirements of the given app. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any time. To prevent any risk of losing info if you update an app or if you erase a database by mistake, we will make a backup of all your MySQL databases each and every day, so if something happens, we can rescue your data.

InnoDB in VPS

When you order a virtual private server from our company, you’ll be able to take advantage of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will permit you to activate any script-powered web application which needs InnoDB, as the database engine is an essential part of the standard software package that will be installed on your Virtual Private Server during its configuration. When you create a brand-new MySQL database via the hosting Control Panel, you will just have to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you won’t need to do anything else in your account. Similarly, if an application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Hosting

Our Hepsia hosting Control Panel is one of the options which you can select on the order page when you buy a dedicated server from us. As this is the most powerful type of hosting, it’s pretty likely that you’ll manage very popular sites that will draw lots of visitors, and since InnoDB is among the very best options for such sites, we’ll install it together with all the other software applications that come with a Hepsia-managed server. If you create a brand-new database in your account, there won’t be any active storage engine till you start installing an open-source script, whether manually via your Internet browser or using the automatic scripts installer that is available in the Control Panel. The required engine will be detected and will be set for that database, so you can make use of scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having any impediment.