InnoDB is a popular database storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got lots of pluses that make it the preferred engine for plenty of PHP-driven web apps, such as Magento and Joomla, which have switched over to InnoDB for good. For example, adding large data volumes will be much faster with InnoDB, because it locks only a single database row to accomplish a specific 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 tackled. In simpler words, adding new or modifying existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case a certain problem appears during the process, so the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an essential part of the standard set of services that we’re offering with our shared hosting packages. In case you want to use a script-driven application that requires InnoDB specifically, in order to be activated and to operate correctly, you will not encounter any problems as the InnoDB database engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an app manually or use our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the given application needs InnoDB rather than MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also store daily database backups, so that we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can use a PHP-based application that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our cutting-edge cloud web hosting platform where the MySQL database storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click application installer tool. Either way, the needed engine will be chosen automatically as soon as the application’s activation begins, so you won’t need to configure anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. Also, we will always be able to retrieve any of your databases if you unintentionally remove one, as we perform a few MySQL database backups every day, each of which is saved for 7 days.

InnoDB in Dedicated Hosting

All dedicated hosting that are ordered with our in-house developed Hepsia hosting Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to install it manually in case you would like to activate open-source PHP scripts that require it. All it takes to activate such a script is to create a new database and to begin the setup – once the script configuration wizard gets access to the database and begins importing content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you will not need to modify any settings on the dedicated server. This will permit you to install different scripts on a single machine and to use it to its maximum capacity.