InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by plenty of programmers that build highly scalable software applications, as it works more efficiently with huge volumes of data, while it keeps the server processing load low. Moreover, it it locks only one row in the database in case any information should be edited, whereas lots of other engines lock the entire database table and thus require much more time to carry out several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest Joomla™ versions are two examples of famous PHP-based software platforms that have shifted over to InnoDB.

InnoDB in Cloud Hosting

You can use any script-based software app that needs InnoDB in case you’ve got a Linux cloud hosting with our company, as the storage engine is present on our cutting-edge cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate applications that need the MyISAM engine without encountering any impediment as well and, again, the engine will be pre-selected, so you won’t have to configure any setting manually at any point. Furthermore, we will also perform daily backups of all the MySQL databases that you’ve got in the shared hosting account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our Linux semi-dedicated servers by default, so as soon as you obtain a new semi-dedicated account, you can go on and install any script-based web application that needs this database engine. A few engines are pre-installed on our cloud website hosting platform, so when you create a brand new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be set depending on the requirements of the particular app. This will allow you to activate and manage InnoDB-specific applications without any problem and without having to change any settings in your semi-dedicated account. To take no chances, we will always keep a 1-week-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can quickly retrieve it.

InnoDB in VPS Servers

When you acquire a VPS server from us, you’ll be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to run any PHP-powered app that requires InnoDB, as this database storage engine is an integral part of the standard software package that will be installed on the Virtual Private Server during its setup. When you create a new MySQL database via the hosting Control Panel, you simply need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your account. Equivalently, if a certain app requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to select one of the three Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL database storage engine manually so as to be able to run script-powered apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the server resources that you need to run very large sites, it’s pretty likely that you’ll use InnoDB. You’ll be able to use other engines as well, so if a certain application needs MyISAM instead of InnoDB, you won’t need to deal with any complication while managing it. The engine that will be used will be automatically recognized once the app installation procedure begins, so you won’t have to tweak any setting manually at any moment.