InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got lots of advantages which have made it the engine of choice for numerous open-source script-based web applications, such as Magento and Joomla, which have switched over to InnoDB permanently. For example, importing enormous data volumes will be much faster with InnoDB, because it locks only one row to complete a certain operation, 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 tackled. To put it simply, adding new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back in case a given issue appears in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

You’ll be able to install any open-source script-driven software app that needs InnoDB in case you’ve got a Linux cloud website hosting plan with our company, as the database storage engine is available on our cutting-edge cloud web hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can install apps which use the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be selected automatically, so you won’t need to update anything manually at any point. In addition, we will also make daily backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite anything, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you can take advantage of all the options offered by this database storage engine with any PHP script-driven web application that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the given app. You won’t need to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll keep regular database backups, so if anything goes wrong following some update or if you delete some data by accident, we will be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

In case our custom-built Hepsia Control Panel is picked during the registration process for a new VPS plans , InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you will not have to do anything if you choose to install PHP script-driven applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand-new database and start the app installation manually or through our 1-click installer. The system will detect the engine that the application in question requires and will assign it to the specific MySQL database, so the installation will proceed impeccably and the app can insert its content into that database. In this way, you can manage applications with various requirements about the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not have to install it manually in case you would like to run PHP scripts that need it. All it takes to activate such a script is to create a new database and to begin the installation process – as soon as the installer wizard obtains access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to activate scripts that need the other very popular MySQL engine – MyISAM, so you will not have to change any settings on the server. This will permit you to run various scripts on a single machine and to use the latter to its maximum capabilities.