InnoDB

InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got many upsides that have made it the preferred engine for plenty of PHP script-based software applications, among them Magento and Joomla™, which have switched to InnoDB permanently. For instance, adding immense data volumes will be much faster with InnoDB, because it locks only one row to complete a given task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, appending new or editing existent data will either be fully completed, or will be canceled and the operation will be rolled back if any issue occurs in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other website hosting service providers, it is part of the standard set of features that we’re offering with our hosting plans. If you wish to make use of a PHP-based application that needs InnoDB specifically, in order to be installed and to function properly, you will not have any difficulties because the MySQL storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a brand new database and activate an application manually or make use of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the application requires it instead of MyISAM. In addition to the outstanding crash recovery offered by InnoDB, we also keep regular backups of all databases, so that we can swiftly restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

You can use a script-powered software application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our single-click app installer tool. In either case, the required engine will be chosen automatically as soon as the activation of the application begins, so you will not need to edit anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. On top of that, we’ll always be able to recover any of your databases if you delete one by mistake, as we perform a few MySQL database backups every day, each of which is saved for one whole week.

InnoDB in VPS Hosting

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the default software bundle that will be pre-installed on your server before we give it to you. You won’t have to activate anything manually and you will be able to enable and manage any PHP-based application that needs InnoDB when your VPS server is up and running, which takes no more than sixty minutes after the order submission itself. A couple of engines are available, so anytime you create a database using the Hepsia hosting Control Panel, a specific engine will be activated when the app installation process commences and our system will automatically recognize which engine is required by the app in question. In case you need to use MyISAM, for instance, you will not have to do anything different than installing the desired application, whether manually or using our application installer.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-activated and among everything else, you will get the InnoDB database engine, so you will not have to install it manually in case you’d like to use PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to start the setup process – as soon as the installer wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will enable you to install various scripts on one single physical machine and to use the latter to its maximum capacity.