InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved database crash recovery compared to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by numerous developers that write scalable software apps, due to the fact that it works much more efficiently with large amounts of data, while it keeps the server load at a minimum. What’s more, it it locks only one row in the database if any info should be updated, while many other engines lock the entire database table and thus require much more time to accomplish several successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the modification of the entire data cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest Joomla versions are two examples of widespread PHP script-based software apps that have shifted over to InnoDB.

InnoDB in Cloud Hosting

You can use any PHP-powered software application that needs InnoDB in case you’ve got a cloud hosting plan with us, as the storage engine is present on our cutting-edge cloud platform as standard. Throughout the app activation – 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 activate apps which require the MyISAM engine without any problems as well and, once again, the engine will be pre-selected, so you will not have to change anything manually at any moment. In addition, we’ll also create regular backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our semi-dedicated hosting plans by default, so as soon as you buy a new semi-dedicated account, you can go ahead and install any script-based app that requires the MySQL storage engine. A couple of engines are installed on our cloud hosting platform, so when you set up a brand new database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the prerequisites of the specific app. This will allow you to activate and manage InnoDB-specific apps without any difficulty and without having to change any settings in your semi-dedicated account. To take no chances, we’ll always have a seven-day-old backup of all your databases, so if you erase or alter any content unintentionally, we can quickly retrieve it.

InnoDB in VPS Servers

If you buy a VPS server from our company, you’ll be able to take full advantage of our custom Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to manage any PHP script-based software app that needs InnoDB, as this database storage engine is an integral part of the default software bundle that will be pre-installed on your Virtual Private Server during its creation. When you set up a brand new MySQL database via the Control Panel, you will just need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine given that the app in question needs it, so you will not have to do anything else in your VPS account. Equivalently, if an app requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features that you can choose on the order form when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it’s quite likely that you will manage highly popular sites that will draw lots of people, and since InnoDB is among the best options for such Internet sites, we’ll activate it along with all the other software apps that are available with a Hepsia-equipped server. When you create a new MySQL database in your dedicated server account, there won’t be any activated MySQL storage engine until you start installing an open-source PHP script, whether manually via your Internet browser or using the automatic script installer tool that is included in the hosting Control Panel. The required engine will be automatically recognized and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without coming across any problem.