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.