InnoDB is a database engine for MySQL databases, which is used by widespread PHP-based web applications like Joomla 3.x and Magento. It is excellent for scalable applications, as it performs exceptionally well when managing huge volumes of data. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same length of time. Plus, InnoDB offers a better database crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be handled. If a certain task has not been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will stay undamaged and will not be partially mixed with newly added content.

InnoDB in Hosting

Any script-powered web app that needs InnoDB will run impeccably on our avant-garde cloud hosting platform and the MySQL storage engine comes with all our hosting plans. Each time 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 will use will be selected based on the app’s specifications without having to edit any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will keep daily backups of your content, so in case you accidentally delete a database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server accounts and you begin installing a PHP script-powered web app either manually or using our one-click app installer, the storage engine for the database will be selected automatically on the basis of the prerequisites of the given application. Since 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 any manual intervention needed on your end at any point. To avoid any risk of losing info if you update an application or if you delete a database unintentionally, we will generate a backup of all your databases each day, so if anything happens, we can retrieve your data.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the VPS server along with other essential software, so you will not need to do anything if you choose to run PHP script-based web apps that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a brand-new MySQL database and begin the app installation manually or through our 1-click installer tool. The system will detect the engine that the particular app requires and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can import its content into that database. Thus, you can make use of applications with different prerequisites concerning the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to add it manually in case you wish to use open-source PHP scripts that require it. All it takes to run such a script is to set up a new database and to initiate the installation process – once the script configuration wizard acquires access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to install scripts that need MyISAM – the other very popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will permit you to activate various scripts on one single machine and to use it to its maximum capabilities.