Find out more on InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has many strong sides that make it the engine of choice for many script-powered applications, such as Magento and Joomla™, which have switched over to InnoDB permanently. For instance, adding enormous amounts of data will be much faster with InnoDB, as it locks only one database row to perform a given task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. To put it simply, adding new or modifying existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back if any problem occurs in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it is included in the default set of features that we are offering with our shared hosting packages. In case you wish to use a PHP-based software app that needs InnoDB specifically, in order to be installed and to perform correctly, you will not face any impediments because the MySQL storage engine is available on our custom-built cloud website hosting platform. No matter if you create a brand new MySQL database and activate an application manually or use our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it rather than MyISAM. Besides the remarkable crash recovery that InnoDB offers, we also generate daily backups of all databases, so we can swiftly restore any database in your shared web hosting account.