InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has numerous strong sides that make it the preferred engine for numerous PHP-powered web applications, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, importing huge amounts of data will be faster with InnoDB, as it locks only one database row to execute a particular task, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. Simply put, appending new or modifying existent data will either be entirely completed, or will be canceled and the operation will be rolled back in case some issue shows up during the process, so the content that remains in the database won’t be lost.

InnoDB in Shared Website Hosting

Any PHP script-driven application that needs InnoDB will function flawlessly on our advanced cloud platform and the storage engine is offered with all our shared website hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s specifications without having to configure any setting in your shared web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We will maintain regular backups of your content, so in case you accidentally erase a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your data the way it was just a few hours earlier.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our semi-dedicated hosting by default, so the moment you purchase a new semi-dedicated account, you can move on and activate any PHP script-powered web application that needs the MySQL database engine. Several engines are installed on our cloud hosting platform, so when you set up a brand new database and begin installing an application manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be set based on the respective app’s prerequisites. This will permit you to activate and manage InnoDB-specific applications without encountering any impediment and without needing to edit any settings in your account. To be on the safe side, we will always keep a 1-week-old backup of all your databases, so if you delete or edit any content by accident, we can quickly retrieve it.

InnoDB in VPS Web Hosting

When you obtain a virtual private server from our company, you’ll be able to take advantage of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to manage any PHP-based app which needs InnoDB, as this particular MySQL storage engine is included in the software bundle that will be pre-installed on your VPS server during its creation. When you create a brand-new MySQL database using the Control Panel, you’ll just have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you won’t have to do anything else in your VPS account. Equivalently, if a given app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually if you want to run open-source PHP scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the installation – as soon as the script installation wizard gets access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to use scripts that need the other very popular MySQL engine, MyISAM, so you will not need to update any settings on the server. This will allow you to activate various scripts on one single physical server and to use it to its full capabilities.