InnoDB is a popular database engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has lots of strong sides which have made it the engine of choice for plenty of open-source script-based web apps, such as Magento and Joomla, which have switched to InnoDB permanently. For instance, adding huge amounts of data will be faster with InnoDB, since it locks only a single row to carry out a specific task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is handled. Simply put, importing new or modifying existent data will either be entirely completed, or will be annulled and the operation will be rolled back in case a certain problem occurs in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

Any script-based web application that needs InnoDB will function flawlessly on our leading-edge cloud web hosting platform and the storage engine comes with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without having to modify any setting in your shared account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We’ll generate daily backups of your content, so in case you accidentally remove a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore everything the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

You can activate a PHP script-powered software application that requires InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. Either way, the required engine will be picked automatically the moment the installation of the application begins, so you will not have to change anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to restore any of your databases if you accidentally remove one, as we make a few database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Hosting

If you pick a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the software pack that will be installed on your VPS server before we give it to you. You won’t need to configure anything manually and you will be able to enable and run any PHP-powered web app that requires InnoDB when your VPS server is ready, which takes no more than one hour after the order procedure itself. A number of engines are offered, so whenever you create a MySQL database via the Hepsia hosting Control Panel, a specific engine will be selected once the app installation begins and our system will automatically detect the engine that is required by the application in question. If you need to use MyISAM, for instance, you won’t have to do anything different from installing the chosen application, whether manually or using our app installer.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our custom-built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to install it manually in case you want to run open-source PHP scripts that need it. All it takes to activate such a script is to set up a new database and to start the installation – as soon as the installation wizard gets access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to run scripts that require MyISAM – the other very popular MySQL engine, so you won’t need to change any settings on the server. This will allow you to use a variety of scripts on one single physical machine and to use it to its fullest capabilities.