InnoDB is a very popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has numerous strengths that make it the preferred engine for numerous PHP-driven apps, among them Magento and Joomla, which have moved to InnoDB for good. For example, adding enormous amounts of data will be much faster with InnoDB, since it locks only one row to perform a certain task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. To put it simply, importing new or editing existent data will either be fully completed, or will be annulled and the operation will be rolled back in case a given issue occurs in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Hosting

InnoDB is available with all our Linux hosting service by default, not upon request or as a paid upgrade, so you can activate and run any open-source script-driven software app which needs the MySQL database storage engine without having to deal with any impediment once you open your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, regardless of whether you use our 1-click installer or create the database and set up the application manually, as long as the application requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your databases, so you can be sure that you’ll never lose any content if you erase a database by mistake or you overwrite some key information – you will just need to notify us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel offered with all our semi-dedicated server packages and you start installing an open-source script-powered software application either manually or using our single-click app installer tool, the MySQL database storage engine will be selected automatically based on the requirements of the particular app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that needs it without the need for any manual intervention on your end at any time. To prevent any chance of losing data if you update an app or if you erase a database by mistake, we will make a backup of all your MySQL databases every day, so if something goes wrong, we can retrieve your content.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the default software package that will be pre-installed on your VPS server before we hand it over to you. You won’t need to set up anything manually and you’ll be able to install and use any PHP-powered software app that needs InnoDB once your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission process itself. A number of engines are offered, so anytime you set up a database using the Hepsia hosting Control Panel, a particular engine will be selected once the app activation process begins and our system will recognize the engine that is required by the app in question. If you need to use MyISAM, for instance, you won’t need to do anything different than installing the app of your preference, whether manually or using our app installer.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can select on the server configuration page when you purchase a dedicated server from our company. Since this is the most powerful type of hosting, it is pretty likely that you will manage very popular Internet sites that will attract plenty of visitors, and since InnoDB is among the very best choices for such Internet sites, we will activate it along with all the other software applications that are offered with a Hepsia-managed server. When you create a brand-new MySQL database in your dedicated server account, there won’t be any active storage engine until you start installing a PHP script, whether manually via your browser or using the automatic scripts installer tool that is integrated into the Control Panel. The necessary engine will be automatically recognized and will be set for that database, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without having to cope with any problem.