InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has a number of advantages which make it the preferred engine for a lot of PHP script-based web applications, including Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing huge data volumes will be faster with InnoDB, as it locks only one database row to execute a certain operation, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is treated. In simpler words, appending new or editing existent data will either be entirely completed, or will be canceled and the operation will be rolled back in case any problem occurs during the process, which is why the content that remains in the database will not be damaged.

InnoDB in Shared Website Hosting

You can use any PHP script-driven software application that needs InnoDB in case you’ve got a shared website hosting plan with our company, as the MySQL database engine is present on our avant-garde cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can run applications which need the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you will not need to update anything manually at any time. In addition, we will also create regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you’ll be able to choose any of the three Control Panels that we offer – cPanel and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to activate this database storage engine manually in order to be able to use PHP-powered applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you require to run very large Internet sites, it is very possible that you will use InnoDB. You will be able to use other engines too, so in case a certain application requires MyISAM instead of InnoDB, you won’t have to deal with any obstacle while running it. The engine that will be used will be recognized automatically when the app installation process commences, so you will not need to fine-tune any setting manually whatsoever.