InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got plenty of pluses that have made it the engine of choice for numerous PHP script-powered applications, including Magento and Joomla, which have switched over to InnoDB for good. For example, importing huge data volumes will be much faster with InnoDB, because it locks only a single row to execute a certain operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, appending new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem appears in the meantime, hence the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You’ll be able to run any PHP-based software application that needs InnoDB if you’ve got a shared hosting with us, as the storage engine is available on our cutting-edge cloud web hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can install applications that need the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you will not have to configure anything manually at any moment. In addition, we’ll also carry out regular backups of all the databases that you have in your shared hosting account, so in case you delete or overwrite anything, we can swiftly restore it the way it was on any of the previous 7 days.