InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got many advantages that make it the engine of choice for a lot of script-powered software apps, including Magento and Joomla, which have switched to InnoDB for good. For example, importing immense data volumes will be faster with InnoDB, because it locks only a single database row to complete a task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. Put simply, adding new or editing existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back if any issue occurs during the process, which is why the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

You will be able to make use of any open-source script-based application that needs InnoDB if you’ve got a shared hosting package with us, as the MySQL storage engine is present on our avant-garde cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can run apps that use the MyISAM engine without encountering any impediment as well and, again, the engine will be selected automatically, so you will not have to modify anything manually at any point. On top of that, we will also make regular backups of all the databases that you have in your shared account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you start installing a script-powered web app either manually or using our one-click app installer, the storage engine for the database will be selected automatically based on the prerequisites of the particular app. As InnoDB is available on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any moment. To prevent any risk of losing info if you update an app or if you erase a database by mistake, we’ll perform a backup of all your MySQL databases each day, so if something goes wrong, we can restore your data.

InnoDB in VPS Hosting

If you order a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the standard software package that will be installed on your VPS server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and run any PHP-powered web application that requires InnoDB as soon as your VPS server is ready, which takes no more than 60 minutes after the order process itself. A number of engines are offered, so whenever you create a database using the Hepsia Control Panel, a specific engine will be picked when the app installation process begins and our system will detect which engine is required by the app in question. In case you need to use MyISAM, for example, you will not have to do anything different from installing the chosen app, whether manually or using our application installer tool.

InnoDB in Dedicated Web Hosting

All dedicated web hosting that are ordered with our in-house developed Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you would like to use open-source PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the setup process – as soon as the installer wizard gains access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to run scripts that require MyISAM – the other popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will enable you to install various scripts on one single machine and to use it to its maximum capacity.