InnoDB is a popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got lots of strong sides that make it the engine of choice for plenty of PHP script-driven web apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing huge data volumes will be faster with InnoDB, due to the fact that it locks only one database row to complete an operation, 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 information is treated. Simply put, adding new or editing existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back if some issue shows up in the meantime, so the content that remains in the database won’t be damaged.
InnoDB in Cloud Website Hosting
While InnoDB is either not offered or it is a paid upgrade with other web hosts, it is an essential part of the default set of services that we’re offering with our cloud website hosting plans. In case you wish to use a PHP-driven application that requires InnoDB in particular, in order to be installed and to operate correctly, you will not have any impediments since the InnoDB database engine is available on our in-house built cloud Internet hosting platform. No matter if you create a brand-new database and install an application manually or use our one-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB rather than MyISAM. Besides the excellent crash recovery that InnoDB offers, we also make daily backups of all databases, so we can easily recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database from the Control Panel included with each of our semi-dedicated server accounts and you start installing a PHP-driven application 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 prerequisites of the particular application. As InnoDB is available on the cloud hosting platform where your new account will be set up, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any moment. To avoid any risk of losing info if you update an application or if you remove a database by accident, we’ll make a backup of all your MySQL databases every day, so if anything goes wrong, we can rescue your content.
InnoDB in VPS
When you order a virtual private server from our company, you’ll be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to run any script-driven software app that needs InnoDB, as this particular MySQL database storage engine is an integral part of the default software package that will be pre-installed on your Virtual Private Server during its setup. When you create a brand new database using the Control Panel, you just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you won’t have to do anything else in your account. Analogously, if a certain application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Hosting
All Linux dedicated hosting ordered with our in-house built Hepsia Control Panel include a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you need to use PHP scripts that require it. All it takes to use such a script is to create a new database and to initiate the installation – once the script configuration wizard gets access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to use scripts that need the other popular MySQL engine, MyISAM, so you will not have to update any settings on the server. This will enable you to run different scripts on a single physical machine and to use the latter to its full capabilities.