InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a much better overall performance and a faster database crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous developers that create scalable software apps, due to the fact that it works more effectively with large volumes of data, while it keeps the server load low. Furthermore, it locks only a single row in the database in case anything should be edited, while lots of other engines lock the entire database table and thus require much more time to execute multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification cannot be completed for any reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla editions are two instances of widely used PHP-powered apps which have switched to InnoDB.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting companies, it’s part of the standard set of services that we are offering with our hosting packages. In case you’d like to use a PHP-based software application that requires InnoDB particularly, in order to be activated and to work correctly, you won’t have any obstacles because the MySQL storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand-new database and activate an app manually or take advantage of our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app needs it rather than MyISAM. In addition to the outstanding database crash recovery that InnoDB is offering, we also store daily database backups, so we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server packages and you start installing an open-source script-based software app either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be selected automatically based on the requirements of the particular application. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that needs it without any manual intervention required on your end at any time. To avoid any risk of losing information if you update an app or if you delete a database by mistake, we’ll carry out backups of all your databases each and every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Web Hosting

If you purchase a virtual private server from us, you will be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will permit you to install any open-source script-driven app which requires InnoDB, as this particular database storage engine is part of the software bundle that will be pre-installed on your server during its setup. When you set up a new database through the Control Panel, you’ll simply need to start installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not have to do anything else in your VPS account. Similarly, if a given application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers Hosting

Our Hepsia Control Panel is one of the options which you can choose on the order form when you buy a dedicated server from us. Since this is the most powerful kind of hosting, it’s quite likely that you will manage very popular sites that will attract a lot of visitors, and since InnoDB is among the very best options for such websites, we’ll enable it together with all the other software applications that are offered with a Hepsia-managed server. If you set up a brand new database in your dedicated account, there won’t be any active MySQL database engine until you start installing a PHP script, whether manually through your Internet browser or using the automatic script installation tool that is integrated into the Control Panel. The necessary engine will be automatically detected and will be set for that database, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without coming across any impediment.