InnoDB is a very popular storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has many pluses which have made it the preferred engine for numerous script-based web apps, including Magento and Joomla, which have switched to InnoDB for good. For example, importing enormous amounts of data will be much faster with InnoDB, because it locks only a single database row to carry out a certain operation, 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. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the operation will be rolled back in case some issue shows up in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

Any open-source script-powered software application that needs InnoDB will function impeccably on our cutting-edge cloud web hosting platform and the storage engine is offered with all our cloud hosting plans. Every time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without the need to edit any setting in your hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll carry out daily content backups, so in case you accidentally erase a database that is important to you or you overwrite a specific part of it, we will be able to restore your database the way it was just several hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the Control Panel coming with all our semi-dedicated server packages and you start installing a PHP-based web app either manually or using our one-click application installer, the MySQL database storage engine will be set automatically based on the prerequisites of the app in question. As InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any time. To prevent any chance of losing information if you update an application or if you delete a database by accident, we will perform a backup of all your databases each day, so if something goes wrong, we can retrieve your data.

InnoDB in VPS Web Hosting

If you get a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an integral part of the standard software bundle that will be pre-installed on your server before we give it to you. You won’t have to configure anything manually and you will be able to install and manage any PHP script-based web application that requires InnoDB once your VPS is ready, which takes no more than 1 hour after the order submission process itself. A couple of engines are available, so every time you create a MySQL database through the Hepsia Control Panel, a specific engine will be picked when the app installation commences and our system will recognize which engine is required by the application in question. In case you have to use MyISAM, for example, you will not need to do anything different from installing the desired app, whether manually or using our app installer.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t need to add it manually in case you need to use PHP scripts that require it. All it takes to activate such a script is to set up a new database and to begin the setup process – once the script configuration wizard gains access to the database and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to run scripts that need MyISAM, the other popular MySQL engine, so you won’t have to change any settings on the server. This will allow you to install a variety of scripts on one single physical server and to use it to its full potential.