InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it offers a better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of developers that run scalable web applications, since it works more efficiently with immense volumes of data, while it keeps the server processing load at a minimum. Moreover, it it locks only one row in the database if any information should be edited, whereas lots of other engines lock the entire database table and hence require much more time to handle multiple successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for some reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla editions are two instances of widespread PHP-based web applications which have switched over to InnoDB.

InnoDB in Cloud Website Hosting

You will be able to use any script-based software application that requires InnoDB in case you have a cloud website hosting plan with us, as the database engine is available on our advanced cloud website hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can install applications which require the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you won’t have to modify anything manually at any point. In addition, we will also perform daily backups of all the databases that you have in your account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

You can install a PHP script-powered app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our innovative cloud platform where the MySQL storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our 1-click application installer. Either way, the needed engine will be chosen automatically once the application’s activation starts, so you won’t need to configure anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to retrieve any of your MySQL databases in case you accidentally erase one, as we make a couple of backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the default software package that will be installed on your VPS server before we give it to you. You won’t need to activate anything manually and you will be able to install and use any PHP-powered app that requires InnoDB as soon as your VPS is ready, which takes no more than 1 hour after the order submission itself. Several engines are available, so anytime you set up a MySQL database through the Hepsia Control Panel, a specific engine will be activated once the app installation begins and our system will automatically recognize the engine that is required by the application in question. If you need MyISAM, for example, you won’t need to do anything different than installing the preferred app, whether manually or using our application installer.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can pick on the order form when you buy a dedicated server from our company. Since this is the most powerful type of website hosting, it is quite likely that you’ll run highly popular websites that will draw a lot of individuals, and since InnoDB is among the very best choices for such websites, we’ll activate it together with all the other software applications that come with a Hepsia-managed server. If you create a brand-new database in your dedicated server account, there won’t be any activated database engine till you begin installing a PHP script, whether manually via your browser or using the automatic scripts installation tool that is included in the Control Panel. The required engine will be automatically detected and will be assigned to that database, so you can run scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without experiencing any problem.