InnoDB is a very popular database engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got numerous upsides which have made it the engine of choice for a lot of PHP-driven apps, including Magento and Joomla, which have moved to InnoDB for good. For example, importing immense amounts of data will be much faster with InnoDB, as it locks only a single database row to accomplish a given operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. In simpler words, adding new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a certain issue appears during the process, therefore the content that remains in the database will not be damaged.

InnoDB in Shared Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosts, it is included in the standard set of services that we offer with our shared web hosting plans. If you wish to use a PHP script-driven application that needs InnoDB particularly, in order to be activated and to perform correctly, you won’t have to deal with any impediments because the database engine is available on our in-house developed cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application needs InnoDB rather than MyISAM. Besides the amazing crash recovery that InnoDB is offering, we also generate regular backups of all databases, so we can quickly recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can activate a PHP script-driven web application that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our innovative cloud web hosting platform where the database engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our one-click application installer tool. In either case, the required engine will be chosen automatically as soon as the installation of the application starts, so you won’t need to update anything manually, irrespective of whether the app needs InnoDB or the more regularly used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases in case you accidentally remove one, as we perform a few MySQL database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS Web Hosting

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the default software bundle that will be pre-installed on your server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and manage any PHP script-based web app that requires InnoDB when your Virtual Private Server is set up, which takes no more than 60 minutes after the order process itself. A couple of engines are offered, so every time you create a MySQL database through the Hepsia hosting Control Panel, a specific engine will be selected once the app installation process commences and our system will automatically recognize which engine is required by the application in question. In case you have to use MyISAM, for instance, you won’t have to do anything different from installing the preferred application, whether manually or using our app installer.

InnoDB in Dedicated Servers Hosting

All dedicated hosting services that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not need to install it manually in case you want to activate scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – as soon as the installer wizard accesses the database in question and starts dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to install scripts that require MyISAM, the other popular MySQL engine, so you won’t need to change any settings on the server. This will allow you to use different scripts on one single physical machine and to use it to its full capacity.