InnoDB is a storage engine for MySQL databases, which is used by widely used PHP script-powered web apps like Magento and Joomla™ 3. It’s excellent for scalable applications, as it performs unbelievably well when managing huge amounts of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same length of time. Besides, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and modifications should be treated. In case a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will stay intact and will not be partially merged with newly inserted content.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting plans by default, not upon request or as a paid upgrade, so you can install and manage any PHP-powered web app that needs the MySQL database storage engine without having to deal with any impediment as soon as you order your account. InnoDB will be selected automatically as the default engine for a given database during the app activation, irrespective of whether you take advantage of our single-click installer or create the database and activate the application manually, as long as the app requires it instead of the more popular MyISAM engine. We will carry out regular MySQL database backups, so you can be certain that you’ll never lose any data if you delete a database by accident or you overwrite some key information – you will just have to touch base with us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can run a PHP script-driven web application that requires InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our cutting-edge cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our single-click application installer. Either way, the required engine will be chosen automatically as soon as the activation of the app starts, so you won’t need to modify anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. On top of that, we’ll always be able to retrieve any of your databases if you remove one by accident, as we carry out several database backups every day, each of which is kept for 7 days.

InnoDB in VPS Servers

If you acquire a VPS server from our company, you’ll be able to make use of our custom Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP script-driven app which requires InnoDB, as this particular MySQL storage engine is an integral part of the default software bundle that will be pre-installed on your VPS server during its creation. When you set up a brand new MySQL database using the Control Panel, you’ll just have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the application in question requires it, so you will not need to do anything else in your account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually in case you’d like to activate open-source PHP scripts that need it. All it takes to use such a script is to create a new database and to initiate the setup – once the installation wizard obtains access to the database and begins inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to activate scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to modify any settings on the dedicated server. This will permit you to run various scripts on one single physical machine and to use the latter to its full capacity.