InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has many strengths that make it the preferred engine for plenty of PHP-powered apps, including Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing huge volumes of data will be much faster with InnoDB, because it locks only a single database row to execute a certain task, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. Simply put, appending new or updating existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some issue appears in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Web Hosting

Every PHP-driven web application that needs InnoDB will function flawlessly on our innovative cloud web hosting platform and the storage engine comes with all our web hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected based on the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We’ll make daily backups of your content, so if you unintentionally erase a database that’s important to you or you overwrite some part of it, we will be able to restore everything the way it was only a couple of hours earlier.

InnoDB in Dedicated Web Hosting

When you get a new dedicated server, you’ll be able to select any of the three hosting Control Panels that we’re offering – Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this database engine manually to be able to run PHP script-based software apps that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you require in order to run large-scale Internet sites, it’s rather possible that you will resort to InnoDB. You will be able to use other engines too, so in case a given application needs MyISAM instead of InnoDB, you will not have any impediment while running it. The engine that will be used will be automatically recognized as soon as the app installation process starts, so you won’t need to edit any settings manually at any point.