InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster database failure recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by many web developers that write scalable applications, as it works much more effectively with large amounts of data, while it keeps the server load low. Additionally, it uses row-level locking in case any information should be updated, whereas lots of other engines lock the entire table and thus need more time to accomplish several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla are two instances of widely used script-driven web apps which have switched over to InnoDB.

InnoDB in Cloud Website Hosting

You’ll be able to use any PHP script-based app that needs InnoDB in case you have a cloud website hosting with our company, as the MySQL database engine is available on our advanced cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can run apps that need the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you will not have to edit anything manually at any time. In addition, we will also perform regular backups of all the databases that you have in your shared web hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

You can use a PHP-driven web app that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our advanced cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our one-click app installer tool. In either case, the needed engine will be selected automatically once the app’s installation begins, so you will not need to update anything manually, no matter if the application requires InnoDB or the more widely used MyISAM. Furthermore, we will always be able to recover any of your MySQL databases in case you unintentionally remove one, as we make several MySQL database backups every day, each of which is stored for 1 week.

InnoDB in VPS

If you purchase a virtual private server from our company, you’ll be able to use our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to activate any PHP-based software application which needs InnoDB, as this particular database engine is an essential part of the software bundle that will be pre-installed on your Virtual Private Server during its setup. When you set up a new MySQL database via the Control Panel, you will simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question needs it, so you won’t need to do anything else in your account. Equivalently, if a certain app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Hosting

If you get a new dedicated server, you’ll be able to choose one of the three hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to add this database storage engine manually in order to be able to run open-source script-powered web applications that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you require in order to manage very large Internet sites, it is quite likely that you will resort to InnoDB. You will be able to use other engines too, so in case a particular app requires MyISAM rather than InnoDB, you won’t encounter any complication while managing it. The engine that will be used will be recognized automatically as soon as the app installation process starts, so you won’t need to fine-tune any setting manually at any point.