InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and a faster crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by many web developers that create highly scalable software apps, as it works much more effectively with immense amounts of data, while it keeps the server processing load at a minimum. Furthermore, it locks only a single row in the database in case anything should be modified, whereas lots of other engines lock the entire database table and hence need more time to accomplish several sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for whatever reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla™ are two instances of popular PHP-powered software applications which have switched over to InnoDB.

InnoDB in Website Hosting

You’ll be able to install any script-driven web app that needs InnoDB if you have a website hosting with our company, as the MySQL storage engine is present on our leading-edge 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 needed. You can activate applications that require the MyISAM engine without the need to deal with any obstacle as well and, once again, the engine will be pre-selected, so you won’t need to change anything manually at any point. Furthermore, we will also carry out daily backups of all the MySQL databases that you’ve got in your account, so if you delete or overwrite something, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server together with other required software, so you won’t have to do anything if you decide to use PHP script-based applications that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a new MySQL database and start the app installation process manually or through our 1-click installer tool. The system will automatically detect the engine that the particular application requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the app can import its content into that database. Therefore, you can activate applications with various requirements concerning the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually in case you want to run open-source scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the installation – once the installation wizard acquires access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You will also be able to use scripts that require MyISAM – the other popular MySQL engine, so you won’t need to update any settings on the dedicated server. This will permit you to run different scripts on a single server and to use it to its full potential.