InnoDB is a very popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got many advantages which have made it the engine of choice for lots of open-source script-based software apps, including Joomla and Magento, which have shifted over to InnoDB for good. For instance, importing enormous data volumes will be faster with InnoDB, because it locks only one row to complete a certain task, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the data is treated. In simpler words, importing new or editing existing data will either be fully completed, or will be canceled and the procedure will be rolled back in case any issue shows up during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Hosting

InnoDB is offered with all our hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any PHP-driven app which requires the MySQL database engine without having any problem as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, no matter if you make use of our one-click installer or create the database and install the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We’ll keep daily backups of all your databases, so you can be certain that you will never lose any content if you delete a database unintentionally or you overwrite some vital info – you simply need to contact us and we will restore your data the way it was.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-powered application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our leading-edge cloud hosting platform where the database storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our one-click application installer. Either way, the needed engine will be picked automatically as soon as the app’s activation begins, so you won’t have to modify anything manually, irrespective of whether the application requires InnoDB or the more commonly used MyISAM. On top of that, we will always be able to recover any of your MySQL databases in case you accidentally erase one, as we make a couple of MySQL database backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to run any PHP script-driven software application that requires the storage engine without needing to configure anything manually. You can choose 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 web sites straight away. Once you set up a brand new database and begin the app activation process, our system will select the engine for that database automatically. In this way, you can manage various applications at the same time without changing anything on the Virtual Private Server. You can have a WordPress-driven personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-based shopping portal that uses InnoDB, for instance.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to activate it manually if you need to activate PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to initiate the installation process – as soon as the installation wizard gains access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to install scripts that need the other popular MySQL engine, MyISAM, so you won’t have to modify any settings on the server. This will allow you to use various scripts on one single physical server and to use it to its full capacity.