InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and a faster database failure recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by numerous devs that write scalable software applications, since it works better with immense amounts of data, while it keeps the server load low. Additionally, it locks only a single row in the database if anything should be updated, while lots of other engines lock the entire database table and hence need more time to complete multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla™ releases are two instances of famous PHP script-powered software applications which have shifted over to InnoDB.

InnoDB in Shared Hosting

You can run any PHP-based software application that requires InnoDB in case you’ve got a shared hosting plan with us, as the database engine is available on our innovative cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is required. You can install applications that need the MyISAM engine without any difficulty as well and, once again, the engine will be selected automatically, so you won’t need to change anything manually at any point. Furthermore, we will also carry out regular backups of all the databases that you’ve got in the shared account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

You can install a script-based software app that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer tool. In either case, the needed engine will be chosen automatically the moment the activation of the application starts, so you will not need to modify anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to recover any of your databases if you remove one by mistake, as we carry out a couple of database backups every day, each of which is stored for 1 week.

InnoDB in VPS Servers

If you acquire a VPS server from our company, you’ll be able to use our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to install any open-source script-based application that requires InnoDB, as this particular database engine is part of the standard software package that will be installed on the Virtual Private Server during its creation. When you create a brand new MySQL database using the hosting Control Panel, you will simply need to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question requires it, so you won’t need to do anything else in your VPS account. Likewise, if a given app requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to pick any of the three Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database engine manually in order to be able to manage script-powered web applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need to manage large-size Internet sites, it is quite possible that you’ll use InnoDB. You’ll be able to use other engines too, so if a given app needs MyISAM rather than InnoDB, you will not come across any problem while running it. The engine that will be used will be recognized automatically when the app installation process starts, so you will not have to fine-tune any settings manually at any moment.