InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is used by numerous developers that run scalable software applications, as it works much better with large data volumes, while it keeps the server processing load at a minimum. In addition, it uses row-level locking if any info should be edited, whereas many other engines lock the entire table and thus require much more time to fulfill several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla editions are two examples of widely used script-driven software applications that have shifted over to InnoDB.

InnoDB in Website Hosting

Every open-source script-driven software app that needs InnoDB will run flawlessly on our avant-garde cloud website hosting platform and the MySQL database engine is offered with all our website hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will use will be selected in accordance with the app’s requirements without the need to change any setting in your shared account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We will carry out regular content backups, so if you accidentally remove a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our semi-dedicated plans by default, so as soon as you get a new account, you can go on and install any script-driven app that needs this particular MySQL database storage engine. A number of engines are installed on our cloud website hosting platform, so when you set up a brand-new MySQL database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected based on the concrete app’s requirements. This will permit you to install and run InnoDB-specific applications without coming across any complication and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or alter any content by mistake, we can easily rescue it.

InnoDB in VPS Servers

When you get a VPS server from our company, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to run any open-source script-powered web app which requires InnoDB, as this storage engine is an essential part of the default software package that will be installed on your Virtual Private Server during its configuration. When you set up a brand new MySQL database using the hosting Control Panel, you will simply have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t need to do anything else in your VPS account. Equivalently, if a certain app requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you wish to run open-source PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to start the installation process – once the script installation wizard gets access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to configure any settings on the dedicated server. This will allow you to use various scripts on one single physical server and to use the latter to its maximum capabilities.