InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a significantly better overall performance and a faster database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of developers that run highly scalable web applications, due to the fact that it works more effectively with enormous data volumes, while it keeps the server processing load at a minimum. What’s more, it locks only one database row in case any info should be edited, while many other engines lock the entire database table and therefore require much more time to perform several successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or losing data. Magento and the newest Joomla™ editions are two examples of widespread script-based applications which have switched to InnoDB.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting packages by default, not upon request or as a paid upgrade, so you can install and run any PHP-driven application which needs the MySQL storage engine without any problems as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, irrespective of whether you make use of our 1-click installer or create the MySQL database and install the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will store daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data if you delete a database by mistake or you overwrite some essential info – you’ll simply need to alert us and we will restore your data back to normal.

InnoDB in Semi-dedicated Hosting

You can activate a script-driven web application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our single-click application installer. In either case, the needed engine will be picked automatically once the app’s activation starts, so you won’t need to edit anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. Furthermore, we’ll always be able to recover any of your databases in case you erase one by mistake, as we carry out a couple of backups every day, each of which is stored for 1 week.

InnoDB in VPS Web Hosting

All Linux VPS web hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to use any PHP script-driven app that requires this particular database storage engine without needing to activate anything manually. You can select Hepsia on the VPS order form and your brand new server will be set up within 60 minutes, so you can sign in and begin building your sites right away. Once you set up a brand-new database and start the app installation process, our system will select the engine for this MySQL database automatically. Thus, you can make use of various applications at the same time without having to modify anything on the Virtual Private Server. You can have a WordPress online blog that uses the default MySQL engine – MyISAM, and a Magento-driven e-commerce site that makes use of InnoDB, for example.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting 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 will get the InnoDB database storage engine, so you will not have to add it manually if you need to run PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to initiate the installation process – once the script configuration wizard accesses the database in question and begins entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that require MyISAM – the other very popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will allow you to activate different scripts on one single physical machine and to use the latter to its full capacity.