InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster database crash recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by plenty of web developers that write highly scalable web applications, due to the fact that it works better with immense volumes of data, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database if anything should be edited, whereas lots of other engines lock the entire database table and hence need much more time to perform several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest versions of Joomla™ are two instances of widely used script-driven web applications that have switched to InnoDB.
InnoDB in Hosting
While InnoDB is either not available or a paid upgrade with many other web hosting companies, it’s an essential part of the standard set of features that we’re offering with our hosting
plans. In case you would like to make use of an open-source script-based software app that needs InnoDB particularly, in order to be installed and to perform correctly, you will not have any difficulties as the database storage engine is available on our in-house developed cloud Internet hosting platform. Regardless of whether you create a new database and install an application manually or make use of our 1-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires it instead of MyISAM. In addition to the amazing database crash recovery that InnoDB offers, we also generate regular database backups, so that we can swiftly recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server
plans and you start installing a PHP-driven app either manually or using our single-click application installer tool, the database storage engine will be picked automatically depending on the prerequisites of the app in question. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action needed on your end at any point. To avoid any chance of losing info if you update an application or if you remove a database by accident, we will generate backups of all your MySQL databases each day, so if something happens, we can retrieve your content.
InnoDB in VPS Servers
All Linux VPS servers
that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to make use of any PHP-based software app that requires this particular MySQL database storage engine without needing to install anything manually. You can select Hepsia on the VPS order form and your brand new server will be up and running within the hour, so you can sign in and start setting up your web sites right away. When you set up a brand new database and begin the app installation process, our system will set the engine for this MySQL database automatically. Thus, you can make use of various applications simultaneously without the need to modify anything on the server. You can create a WordPress-powered personal weblog that uses the default MySQL engine – MyISAM, and a Magento-driven e-shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our in-house built Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually in case you wish to run open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the setup process – once the installer wizard gets access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to install scripts that require MyISAM – the other very popular MySQL engine, so you will not need to change any settings on the server. This will permit you to run a variety of scripts on a single physical machine and to use the latter to its maximum capacity.