InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got numerous advantages that make it the preferred engine for plenty of PHP-based apps, among them Joomla™ and Magento, which have moved to InnoDB for good. For example, adding immense volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a specific task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, appending new or updating existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back if any problem shows up in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

InnoDB is available with all our Linux shared website hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any PHP-powered app that needs the InnoDB database engine without any difficulty as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, irrespective of whether you make use of our one-click installer or create the database and install the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll store daily MySQL database backups, so you can be certain that you will never lose any data if you delete a database accidentally or you overwrite some vital information – you’ll simply have to alert us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can make use of a PHP script-based app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our avant-garde cloud platform where the MySQL database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click app installer. Either way, the required engine will be chosen automatically once the application’s installation begins, so you will not need to update anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases in case you erase one by mistake, as we make several MySQL database backups every day, each of which is saved for one whole week.

InnoDB in VPS Servers

All VPS web hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any open-source script-powered software application that requires the database engine without the need to configure anything manually. You can pick Hepsia on the VPS order page and your brand-new VPS server will be up and running within sixty minutes, so you can sign in and begin setting up your web sites straight away. Once you create a brand new MySQL database and start the app installation process, our system will choose the engine for that MySQL database automatically. In this way, you can run different applications at the same time without having to edit anything on the Virtual Private Server. You can have a WordPress-based blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven web shop that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to select one of the three Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Each server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this database storage engine manually so as to be able to run PHP script-powered software applications that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you need in order to run very large Internet sites, it’s rather possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so if a particular app requires MyISAM instead of InnoDB, you will not have to deal with any impediment while managing it. The engine that will be used will be detected automatically as soon as the app installation process begins, so you won’t need to tweak any setting manually at any point.