InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a better overall performance and a faster database crash recovery in comparison with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by many devs that create scalable web applications, since it works much more effectively with huge amounts of data, while it keeps the server load at a minimum. Also, it locks only one database row in case any info should be edited, whereas many other engines lock the entire table and therefore require much more time to handle multiple sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest Joomla editions are two examples of widely used PHP-based software apps that have moved to InnoDB.

InnoDB in Website Hosting

You will be able to use any open-source script-based web app that needs InnoDB in case you’ve got a Linux website hosting with us, as the MySQL database 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 process will proceed impeccably if this engine is needed. You can install applications that need the MyISAM engine without the need to deal with any complication as well and, once again, the engine will be pre-selected, so you will not have to configure anything manually at any point. In addition, we’ll also make daily backups of all the databases that you’ve got in your account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting include InnoDB and you will be able to get the most out of all the features of this database engine with any PHP-powered software app that requires it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the specific app. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our single-click application installer tool. To avoid any risk, we’ll perform daily MySQL database backups, so if anything goes wrong after an upgrade or if you delete some data by accident, we’ll be able to get your database back to the way it was on any of the previous seven days.

InnoDB in VPS

In case our in-house developed Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers , InnoDB will be activated on the VPS server together with other needed pieces of software, so you will not need to do anything if you decide to install PHP script-driven apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand new MySQL database and start the app installation manually or using our 1-click installer tool. The system will detect which engine the app in question requires and will set it for the specific database, so the installation process will proceed flawlessly and the application can insert its content into that database. Therefore, you can activate apps with various requirements in regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is among the features which you can pick on the server configuration page when you purchase a dedicated server from us. Since this is the most powerful type of website hosting, it’s rather likely that you’ll manage popular websites that will attract many individuals, and since InnoDB is one of the best choices for such sites, we’ll enable it along with all the other software apps that are offered with a Hepsia-managed dedicated server. When you create a new database in your account, there won’t be any active storage engine till you begin installing an open-source PHP script, whether manually via your Internet browser or using the automatic scripts installer that is included in the 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 need the default MySQL engine – MyISAM, without coming across any complication.