InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a much better overall performance and an improved crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous developers that run highly scalable applications, because it works more efficiently with huge data volumes, while it keeps the server load low. In addition, it locks only a single database row in case any info should be updated, whereas many other engines lock the entire database table and thus need much more time to complete several consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest editions of Joomla are two examples of widespread PHP script-based applications that have switched over to InnoDB.

InnoDB in Shared Hosting

Any PHP-powered web application that needs InnoDB will function impeccably on our avant-garde cloud website hosting platform and the MySQL database storage engine comes with all our shared hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s requirements without the need to modify any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to get the most out of its full capacity. We’ll keep daily backups of your content, so if you accidentally erase a database that you need or you overwrite a specific part of it, we’ll be able to restore everything the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the hosting Control Panel coming with all our semi-dedicated server packages and you begin installing a PHP-based web application either manually or using our one-click app installer, the MySQL database storage engine will be set automatically based on the requirements of the particular application. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each app that requires 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 application or if you remove a database by mistake, we’ll perform backups of all your databases each day, so if something goes wrong, we can recover your data.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be activated on the VPS server together with other essential software, so you will not have to do anything if you decide to activate open-source script-based apps that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new MySQL database and begin the app installation procedure manually or using our single-click installer. The system will automatically detect which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the app can import its content into that database. Thus, you can install apps with various prerequisites regarding the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can select on the order form when you purchase a dedicated server from our company. Since this is the most powerful type of hosting, it is quite likely that you’ll manage popular websites that will draw lots of visitors, and since InnoDB is one of the very best options for such sites, we will activate it along with all the other software applications that are offered with a Hepsia-equipped dedicated server. If you set up a new MySQL database in your dedicated server account, there won’t be any active MySQL storage engine until you start installing a PHP script, whether manually via your Internet browser or using the automatic script installer tool that is included in the Control Panel. The needed engine will be automatically recognized and will be assigned to that database, so you can make use of scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without running into any difficulty.