InnoDB is a very popular storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has many upsides which make it the preferred engine for numerous PHP-powered web applications, including Joomla and Magento, which have switched over to InnoDB for good. For instance, adding large volumes of data will be much faster with InnoDB, due to the fact that it locks only one row to execute a specific operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is treated. To put it simply, adding new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem occurs in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Web Hosting

InnoDB is available with all our web hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP script-based application which needs the InnoDB database engine without having any problem as soon as you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation, irrespective of whether you use our single-click installer or create the MySQL database and set up the app manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll create daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any data in case you delete a database by mistake or you overwrite some important information – you will just need to inform us and we’ll restore your content the way it was.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to select any of the three hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this database engine manually in order to be able to use script-powered web applications that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you need to run very large Internet sites, it is rather likely that you’ll resort to InnoDB. You will be able to make use of other engines too, so if a given application needs MyISAM instead of InnoDB, you will not encounter any impediment while running it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you will not need to tweak any setting manually at any moment.