InnoDB
What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by famous PHP script-based apps like Joomla™ 3 and Magento. It’s ideal for scalable applications, because it performs stunningly well when managing enormous volumes of data. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. In addition, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and updates should be treated. In case a given task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay undamaged and won’t be partially merged with newly inserted content.
-
InnoDB in Shared Website Hosting
You will be able to use any PHP script-based application that requires InnoDB if you have a
shared website hosting with our company, as the database engine is present on our cutting-edge cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can run apps which use the MyISAM engine without any difficulties as well and, once again, the engine will be pre-selected, so you won’t need to change any setting manually at any time. On top of that, we will also carry out regular backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.