InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got numerous strengths that have made it the engine of choice for lots of PHP-driven web applications, such as Joomla and Magento, which have switched to InnoDB permanently. For instance, adding enormous data volumes will be much faster with InnoDB, because it locks only a single row to execute a given task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is handled. Put simply, appending new or modifying existing data will either be fully completed, or will be aborted and the operation will be rolled back if some issue appears during the process, so the content that remains in the database won’t be lost.

InnoDB in Web Hosting

Any script-driven app that needs InnoDB will run flawlessly on our leading-edge cloud website hosting platform and the MySQL database storage engine is offered with all our web hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to update any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to make the most of its full potential. We’ll maintain regular backups of your content, so in case you accidentally delete a database that you need or you overwrite a certain part of it, we will be able to restore everything the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-driven web app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our innovative cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our single-click app installer. Either way, the needed engine will be selected automatically as soon as the application’s installation begins, so you will not need to update anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you remove one by mistake, as we carry out a few MySQL database backups every day, each of which is kept for one whole week.

InnoDB in VPS

If our custom-built Hepsia Control Panel is chosen during the signup process for your new Linux virtual private servers , InnoDB will be installed on the VPS server together with other essential software, so you won’t need to do anything if you choose to run PHP script-based web apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand new MySQL database and start installing the app manually or through our one-click installation tool. The system will automatically recognize the engine that the particular application requires and will set it for the specific database, so the installation process will continue flawlessly and the application can import its data into that database. In this way, you can install applications with various requirements in regard to the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

All dedicated hosting services that are ordered with our custom Hepsia hosting Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to install it manually if you want to activate PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to initiate the setup process – once the installation wizard gains access to the database in question and begins dumping data in it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to run scripts that need MyISAM – the other very popular MySQL engine, so you will not have to edit any settings on the dedicated server. This will allow you to use different scripts on one single physical server and to use the latter to its full potential.