InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a significantly better overall performance and an improved database crash recovery compared with the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by a lot of web developers that create highly scalable apps, since it works better with large data volumes, while it keeps the server processing load at a minimum. Also, it locks only a single database row if any info should be modified, while lots of other engines lock the entire database table and therefore need more time to carry out several consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for whatever reason, the action is rolled back to prevent confusion or losing data. Magento and the latest editions of Joomla are two instances of widely used PHP-powered web applications that have moved to InnoDB.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting by default, not upon request or as a paid upgrade, so you will be able to install and manage any PHP script-based web app that requires the MySQL storage engine without any problems once you order your shared account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, regardless of whether you use our 1-click installer or create the database and install the app manually, as long as the application requires it instead of the more famous MyISAM engine. We will generate daily MySQL database backups, so you can be certain that you’ll never lose any content in case you delete a database by accident or you overwrite some vital information – you’ll just have to alert us and we’ll restore everything the way it was.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can choose on the server order page when you buy a dedicated server from us. Since this is the most powerful kind of web hosting, it’s quite likely that you’ll manage popular Internet sites that will attract a lot of people, and since InnoDB is among the best choices for such Internet sites, we’ll enable it along with all the other software applications that come with a Hepsia-equipped dedicated server. When you set up a brand-new MySQL database in your dedicated account, there won’t be any active MySQL database storage engine until you begin installing an open-source PHP script, whether manually via your Internet browser or using the automatic script installer tool that is available in the Control Panel. The necessary engine will be detected automatically and will be assigned to that database, so you can run scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without running into any problem.