InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has a number of strengths that make it the preferred engine for many PHP-powered web applications, including Joomla and Magento, which have switched to InnoDB for good. For instance, adding immense amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to accomplish a given task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. To put it simply, importing new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case any problem appears in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Website Hosting

Every PHP script-powered web app that requires InnoDB will run impeccably on our innovative cloud platform and the MySQL database storage engine is offered with all our website hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to configure any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to get the most out of its full potential. We will carry out daily backups of your content, so in case you unintentionally erase a MySQL database that’s important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was only a few hours ago.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the Control Panel provided with all our semi-dedicated server plans and you start installing a PHP script-based web app either manually or using our one-click app installer tool, the storage engine for the MySQL database will be picked automatically on the basis of the requirements of the app in question. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any point. To prevent any risk of losing data if you update an application or if you erase a database accidentally, we’ll perform a backup of all your MySQL databases each day, so if anything happens, we can rescue your data.

InnoDB in VPS

If you pick a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the software pack that will be installed on your server before we give it to you. You will not need to set up anything manually and you will be able to enable and manage any open-source script-powered app that requires InnoDB when your VPS server is up and running, which takes no more than 1 hour after the order process itself. Several engines are offered, so anytime you set up a database through the Hepsia Control Panel, a specific engine will be activated once the app activation starts and our system will detect which engine is required by the app in question. In case you need MyISAM, for example, you won’t have to do anything different from installing the chosen application, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database engine, so you won’t need to activate it manually in case you need to use PHP scripts that require it. All it takes to install such a script is to create a new database and to initiate the setup process – as soon as the script installation wizard acquires access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You will also be able to activate scripts that need the other widely used MySQL engine, MyISAM, so you will not have to configure any settings on the server. This will enable you to activate various scripts on a single physical server and to use the latter to its fullest capabilities.