InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a better overall performance and an improved crash recovery in comparison to the default engine that’s used by MySQL – MyISAM. InnoDB is used by many web developers that write highly scalable apps, because it works more effectively with immense amounts of data, while it keeps the server load at a minimum. Furthermore, it uses row-level locking in case anything should be edited, while many other engines lock the entire table and therefore need much more time to fulfill multiple sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case 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™ editions are two instances of popular PHP-powered software platforms that have moved to InnoDB.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting packages by default, not upon request or as a paid upgrade, so you can install and run any script-powered application that requires the storage engine without any problem once you activate your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, no matter if you take advantage of our one-click installation tool or create the database and activate the application manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be sure that you’ll never lose any data if you erase a database accidentally or you overwrite some key info – you simply have to touch base with us and we will restore the database the way it was.

InnoDB in Dedicated Servers Hosting

Our Hepsia Control Panel is among the options that you can pick on the order form when you purchase a dedicated server from us. As this is the most powerful type of web hosting, it’s pretty likely that you’ll manage highly popular Internet sites that will draw a lot of visitors, and since InnoDB is one of the best choices for such sites, we’ll activate it along with all the other software apps that come with a Hepsia-managed server. When you set up a brand new database in your dedicated account, there won’t be any active storage engine till you start installing an open-source PHP script, whether manually via your web browser or using the automatic script installation tool that is included in the hosting Control Panel. The needed engine will be detected and will be assigned to that database, so you can activate scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having any difficulty.