Find out more about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by well known script-based web apps like Joomla™ 3.x and Magento. It’s ideal for scalable apps, since it excels in handling enormous amounts of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. What’s more, InnoDB offers a much faster database crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be treated. In case a specific operation has not been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it’s part of the default set of features that we offer with our shared hosting packages. In case you want to make use of a script-driven web application that requires InnoDB specifically, in order to be activated and to operate correctly, you won’t face any problems since the InnoDB storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand new database and install an application manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires InnoDB rather than MyISAM. In addition to the exceptional database failure recovery that InnoDB is offering, we also keep daily database backups, so that we can quickly restore any MySQL database in your shared web hosting account.