InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got a number of advantages that make it the preferred engine for lots of PHP-powered apps, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding enormous volumes of data will be much faster with InnoDB, as it locks only a single row to accomplish 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 manner in which the info is handled. Simply put, adding new or updating existent data will either be fully completed, or will be canceled and the procedure will be rolled back if a given issue shows up in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Shared Website Hosting

You’ll be able to activate any open-source script-powered software application that requires InnoDB in case you have a shared website hosting with our company, as the MySQL database engine is present on our avant-garde cloud platform as standard. Throughout 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 which require the MyISAM engine without any obstacles as well and, once again, the engine will be pre-selected, so you won’t have to modify any setting manually at any moment. What’s more, we will also create regular backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite anything, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to select any of the three Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to add this MySQL storage engine manually to be able to use open-source script-based web applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need to run very large sites, it’s rather likely that you will resort to InnoDB. You will be able to use other engines as well, so in case a given app requires MyISAM rather than InnoDB, you won’t need to deal with any difficulty while using it. The engine that will be used will be automatically recognized once the app installation begins, so you will not need to modify any setting manually at any point.