InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got a number of strong sides that have made it the engine of choice for plenty of PHP-based software apps, such as Magento and Joomla, which have switched to InnoDB permanently. For example, importing large amounts of data will be faster with InnoDB, since it locks only one database row to perform a specific task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is treated. In simpler words, adding new or editing existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a certain issue appears during the process, so the content that remains in the database won’t be damaged.

InnoDB in Shared Website Hosting

You’ll be able to make use of any script-powered software app that needs InnoDB in case you have a shared website hosting plan with us, as the MySQL database engine is present on our advanced cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can activate applications which require the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t need to change any setting manually at any moment. What’s more, we’ll also perform regular backups of all the databases that you’ve got in your shared hosting account, so in case you delete or overwrite anything, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

You can activate an open-source script-powered web application that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud platform where the MySQL storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our single-click app installer tool. In either case, the needed engine will be selected automatically as soon as the app’s installation begins, so you will not have to update anything manually, irrespective of whether the app requires InnoDB or the more frequently used MyISAM. Also, we will always be able to restore any of your MySQL databases in case you remove one by accident, as we create a couple of MySQL database backups every day, each of which is saved for one whole week.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is selected during the registration process for a new VPS plans , InnoDB will be installed on the server together with other essential pieces of software, so you will not have to do anything if you decide to use open-source script-based software applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand-new MySQL database and start the app installation manually or through our single-click installer tool. The system will automatically detect which engine the application in question needs and will assign it to the specific database, so the installation process will continue impeccably and the application can dump its content in that database. Thus, you can make use of apps with different requirements about the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually in case you wish to activate open-source scripts that require it. All it takes to activate such a script is to create a new database and to initiate the setup – once the script configuration wizard gets access to the database and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to use scripts that need MyISAM – the other very popular MySQL engine, so you will not need to edit any settings on the dedicated server. This will allow you to install various scripts on one single physical server and to use the latter to its maximum capabilities.