InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has a number of pluses that have made it the engine of choice for numerous PHP script-driven web apps, such as Magento and Joomla, which have switched over to InnoDB permanently. For example, adding huge data volumes will be faster with InnoDB, because it locks only a single row to accomplish a specific operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. To put it simply, adding new or updating existing data will either be entirely completed, or will be annulled and the operation will be rolled back in case any problem shows up in the meantime, therefore the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

Any open-source script-powered application that requires InnoDB will run impeccably on our innovative cloud hosting platform and the MySQL database engine comes with all our shared website hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected on the basis of the app’s specifications without the need to update any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We will create regular content backups, so if you unintentionally delete a MySQL database that you need or you overwrite certain parts of it, we’ll be able to restore everything the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

You can activate a script-based web application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our advanced cloud hosting platform where the database engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our single-click application installer. In either case, the needed engine will be selected automatically once the activation of the app begins, so you won’t have to change anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. Also, we’ll always be able to restore any of your databases if you accidentally erase one, as we make a few MySQL database backups every day, each of which is stored for 1 week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to take advantage of any PHP script-driven app that requires this database storage engine without activating anything manually. You can choose Hepsia on the VPS order page and your brand new Virtual Private Server will be ready within 1 hour, so you can sign in and begin creating your Internet sites straight away. Once you set up a brand-new database and start the app activation process, our system will select the engine for this database automatically. In this way, you can use different apps simultaneously without having to edit anything on the VPS server. You can set up a WordPress-powered weblog that uses MyISAM – the default MySQL engine, and a Magento-powered e-commerce website that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t need to add it manually in case you need to activate PHP scripts that need it. All it takes to install such a script is to set up a new database and to initiate the installation – once the script configuration wizard gains access to the database and begins entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require MyISAM – the other popular MySQL engine, so you will not need to configure any settings on the dedicated server. This will enable you to install various scripts on one single physical server and to use the latter to its fullest capacity.