InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a much better overall performance and an improved database failure recovery in comparison with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by lots of programmers that build highly scalable software applications, due to the fact that it works much better with immense volumes of data, while it keeps the server load at a minimum. Furthermore, it locks only a single database row in case any information should be updated, while many other engines lock the entire database table and hence need much more time to fulfill multiple successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest releases of Joomla™ are two examples of widely used script-driven software platforms that have switched to InnoDB.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our Linux cloud web hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP script-driven software application that needs the storage engine without any difficulties as soon as you open your shared account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation process, no matter if you make use of our one-click installer or create the database and set up the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will perform regular MySQL database backups, so you can be sure that you won’t ever lose any data if you delete a database by accident or you overwrite some crucial information – you just have to touch base with us and we will restore the database back to normal.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you begin installing an open-source script-based software app either manually or using our 1-click app installer, the MySQL database storage engine will be selected automatically based on the prerequisites of the specific app. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that needs it without any manual intervention required on your end at any point. To prevent any chance of losing data if you update an application or if you erase a database by accident, we will carry out backups of all your databases each and every day, so if something happens, we can rescue your content.
InnoDB in VPS Servers
When you purchase a VPS server from us, you will be able to make use of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to use any PHP-driven software application that needs InnoDB, as this database storage engine is part of the standard software bundle that will be installed on the server during its setup. When you set up a new MySQL database through the hosting Control Panel, you’ll just have to start installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the app in question requires it, so you won’t need to do anything else in your account. Similarly, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated servers ordered with the Hepsia Control Panel. It’s an integral part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is ready, you will be able to sign in and to install any kind of script-based web app that requires this particular database storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app setup wizard begins entering information into the database, the engine will be chosen automatically depending on the specific app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either of them explicitly at any time. Therefore, you can make use of a large range of applications for your websites.