InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a better overall performance and a faster database failure recovery in comparison with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many web developers that create scalable software apps, because it works much more effectively with huge amounts of data, while it keeps the server processing load at a minimum. Furthermore, it it locks only one row in the database in case any information should be modified, whereas many other engines lock the entire table and thus need more time to accomplish multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for any reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest Joomla releases are two instances of widespread PHP-based software applications which have switched to InnoDB.

InnoDB in Shared Hosting

You will be able to use any open-source script-driven web app that needs InnoDB if you have a shared service with our company, as the MySQL database storage engine is present on our cutting-edge cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can run applications that require the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you will not have to modify anything manually at any moment. On top of that, we’ll also make regular backups of all the databases that you have in the shared hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB is available with all our semi-dedicated services by default, so as soon as you obtain a new account, you can go ahead and install any script-powered software application that requires this particular MySQL storage engine. A few engines are pre-installed on our cloud hosting platform, so when you create a new database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen based on the requirements of the specific application. This will permit you to install and run InnoDB-specific apps without having to cope with any impediment and without having to edit any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your MySQL databases, so if you erase or alter any content unintentionally, we can easily retrieve it.

InnoDB in VPS Web Hosting

All VPS web hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to run any PHP-driven software app that requires this MySQL database engine without installing anything manually. You can pick Hepsia on the VPS configuration page and your brand-new VPS server will be up and running within 1 hour, so you can sign in and begin setting up your Internet sites straight away. Once you set up a new MySQL database and start the app installation process, our system will set the engine for this MySQL database automatically. In this way, you can run different apps at the same time without modifying anything on the Virtual Private Server. You can create a WordPress online blog that makes use of the default MySQL engine – MyISAM, and a Magento-powered e-commerce site that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers Hosting

All dedicated servers hosting ordered with our in-house built Hepsia Control Panel include a software package that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t have to add it manually if you need to use open-source scripts that need it. All it takes to activate such a script is to create a new database and to start the installation – as soon as the installation wizard gets access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM – the other popular MySQL engine, so you will not have to edit any settings on the dedicated server. This will allow you to install different scripts on a single physical machine and to use it to its full capabilities.