InnoDB is a database engine for MySQL databases, which is used by widespread PHP-powered applications such as Joomla™ 3 and Magento. It is perfect for scalable applications, since it works exceptionally well when handling large data volumes. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can process much more operations for the same length of time. Plus, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – rules that determine how data imports and modifications should be treated. In case a given operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved intact and won’t be partially merged with new content.

InnoDB in Shared Hosting

Any script-driven app that requires InnoDB will run flawlessly on our leading-edge cloud web hosting platform and the database storage engine comes with all our shared hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to modify any setting in your hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll create regular content backups, so in case you accidentally erase a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was just a few hours earlier.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you’ll be able to select one of the three Control Panels offered by our company – Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to activate this MySQL database engine manually to be able to manage script-powered software apps that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you need to manage very large sites, it’s pretty likely that you’ll use InnoDB. You will be able to use other engines too, so if a given app requires MyISAM instead of InnoDB, you will not have any complication while using it. The engine that will be used will be automatically recognized as soon as the app installation procedure starts, so you won’t need to modify any setting manually at any point.