InnoDB is a database engine for MySQL databases, which is used by well known open-source script-powered applications like Joomla 3 and Magento. It’s excellent for scalable applications, because it performs stunningly well when processing large amounts of data. Rather than locking the entire table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle much more operations for the same length of time. Besides, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that indicate how data inserts and updates should be treated. If a specific task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved undamaged and won’t be partially mixed with newly entered content.

InnoDB in Website Hosting

You will be able to run any PHP-driven app that needs InnoDB in case you’ve got a website hosting with our company, as the MySQL database storage engine is available on our leading-edge cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run applications that require the MyISAM engine without having any difficulty as well and, again, the engine will be pre-selected, so you won’t have to change any setting manually at any point. What’s more, we’ll also generate regular backups of all the MySQL databases that you’ve got in your shared account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Dedicated Servers Hosting

InnoDB is available as standard with all dedicated servers hosting ordered with the Hepsia hosting Control Panel. It is part of the software bundle that will be installed on all Hepsia-managed servers, so as soon as your physical machine is ready, you will be able to log in and to activate any open-source script-driven web application that needs this particular storage engine. When you create a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app installation wizard begins entering information into the newly created database, the engine will be picked automatically in accordance with the requirements of the application in question, so you can use both InnoDB and MyISAM without the need to select either one of them specifically at any moment. Therefore, you can make use of an immense range of apps for your websites.