InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of developers that create scalable web applications, as it works much more effectively with enormous amounts of data, while it keeps the server load low. What’s more, it it locks only one row in the database in case any information should be edited, whereas many other engines lock the entire table and thus require more time to process several consecutive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest versions of Joomla are two examples of widely used script-based web applications that have switched over to InnoDB.

InnoDB in Shared Website Hosting

You’ll be able to run any PHP-powered application that needs InnoDB if you’ve got a shared website hosting plan with our company, as the MySQL database storage engine is present on our cutting-edge cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate apps which use the MyISAM engine without having to deal with any impediment as well and, again, the engine will be pre-selected, so you won’t have to change any setting manually at any time. In addition, we will also generate daily backups of all the databases that you’ve got in the shared account, so in case you delete or overwrite something, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can activate a PHP-powered software application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our avant-garde cloud hosting platform where the MySQL database engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our 1-click app installer. In either case, the required engine will be picked automatically the moment the installation of the application begins, so you will not have to update anything manually, regardless of whether the app requires InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to retrieve any of your databases in case you unintentionally delete one, as we generate several MySQL database backups every day, each of which is kept for one whole week.

InnoDB in VPS Servers

When you get a VPS server from our company, you will be able to use our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to use any PHP script-driven app that requires InnoDB, as the database engine is part of the default software package that will be installed on the Virtual Private Server during its setup. When you set up a new database via the hosting Control Panel, you will just have to start installing an app – manually or using our application 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. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to pick any of the three Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to install this MySQL storage engine manually to be able to manage open-source script-based apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require to manage large-scale sites, it is pretty likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a particular app requires MyISAM instead of InnoDB, you won’t encounter any impediment while using it. The engine that will be used will be recognized automatically the moment the app installation starts, so you will not need to update any settings manually whatsoever.