InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved crash recovery in comparison with the default engine used by the MySQL database management system – MyISAM. InnoDB is used by plenty of developers that run scalable software apps, due to the fact that it works much more efficiently with huge volumes of data, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be modified, whereas many other engines lock the entire database table and therefore require much more time to execute several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla versions are two examples of popular open-source script-based apps which have switched to InnoDB.

InnoDB in Website Hosting

Every PHP-based software app that requires InnoDB will function impeccably on our cutting-edge cloud hosting platform and the storage engine comes with all our website hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s requirements without the need to modify any setting in your hosting 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 potential. We will keep daily backups of your content, so if you accidentally remove a MySQL database that is important to you or you overwrite a certain part of it, we will be able to restore your data the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the Control Panel offered with all our semi-dedicated server accounts and you begin installing a PHP-powered web app either manually or using our single-click application installer tool, the MySQL database storage engine will be selected automatically depending on the requirements of the specific application. Since InnoDB is available on the cloud platform where your new account will be set up, it will be set as the default engine for any application that needs it without any manual intervention required on your end at any moment. To prevent any chance of losing info if you update an app or if you erase a database unintentionally, we’ll generate backups of all your databases every day, so if anything goes wrong, we can retrieve your content.

InnoDB in VPS

If our in-house built Hepsia hosting Control Panel is picked during the registration process for a new Linux VPS packages , InnoDB will be activated on the server along with other necessary software, so you won’t need to do anything if you decide to activate PHP script-based apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand-new database and start the app installation procedure manually or through our one-click installation tool. The system will detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will continue impeccably and the app can enter its data into that database. Therefore, you can run apps with various prerequisites with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

When you buy a new dedicated server, you’ll be able to select one of the 3 hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to activate this MySQL database engine manually in order to be able to manage open-source script-powered web apps that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you require to run large-size websites, it’s very possible that you will use InnoDB. You will be able to make use of other engines too, so in case a specific app requires MyISAM rather than InnoDB, you won’t have to deal with any difficulty while using it. The engine that will be used will be detected automatically when the app installation begins, so you won’t need to edit any setting manually at any time.