InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by many programmers that write scalable applications, due to the fact that it works more effectively with enormous data volumes, while it keeps the server load at a minimum. Moreover, it locks only a single row in the database if any information should be modified, whereas lots of other engines lock the entire table and therefore require more time to carry out several consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to avoid confusion or losing data. Magento and the newest Joomla™ versions are two examples of widely used open-source script-powered apps which have switched to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-driven software application which needs the InnoDB database engine without having to deal with any obstacle once you order your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, irrespective of whether you use our 1-click installer or create the database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll carry out regular MySQL database backups, so you can be sure that you’ll never lose any data if you delete a database unintentionally or you overwrite some crucial information – you will just need to contact us and we will restore your database back to normal.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the features that you can pick on the order form when you purchase a dedicated server from us. As this is the most powerful kind of web hosting, it is very likely that you will manage popular sites that will attract many individuals, and since InnoDB is among the very best choices for such sites, we’ll enable it along with all the other software applications that are available with a Hepsia-managed server. If you set up a brand-new database in your account, there won’t be any active database storage engine till you begin installing an open-source PHP script, whether manually via your web browser or using the automatic scripts installation tool that is available in the hosting Control Panel. The needed 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 need the default MySQL engine, MyISAM, without encountering any impediment.