InnoDB is a popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got plenty of advantages that have made it the preferred engine for lots of PHP script-based apps, including Joomla™ and Magento, which have switched over to InnoDB permanently. For example, importing enormous amounts of data will be much faster with InnoDB, as it locks only one database row to complete a particular operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, appending new or updating existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case any problem appears in the meantime, thus the content that remains in the database will not be damaged.

InnoDB in Hosting

InnoDB is available with all our Linux hosting plans by default, not upon request or as a paid upgrade, so you will be able to install and manage any open-source script-powered software application that requires the MySQL database engine without having to deal with any problem once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, regardless of whether you use our one-click installation tool or create the database and install the application manually, provided that the app requires it instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can be certain that you’ll never lose any content in case you erase a database by accident or you overwrite some crucial info – you will just need to notify us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the Control Panel offered with each of our semi-dedicated server accounts and you begin installing an open-source script-based software app either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be picked automatically based on the given app’s requirements. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any point. To avoid any chance of losing information if you update an app or if you delete a database unintentionally, we will perform backups of all your databases every day, so if something goes wrong, we can restore your content.

InnoDB in VPS Servers

If you buy a VPS server from our company, you’ll be able to use our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to run any PHP script-based web app which requires InnoDB, as this MySQL database engine is an essential part of the software package that will be pre-installed on your Virtual Private Server during its creation. When you set up a new database using the hosting Control Panel, you just have to start installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the app in question needs it, so you won’t need to do anything else in your account. Correspondingly, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is included as standard with all Linux dedicated servers ordered with the Hepsia Control Panel. It’s an essential part of the default software package that will be pre-installed on all Hepsia-managed servers, so once your physical machine is ready, you’ll be able to log in and to install any kind of open-source script-driven software application that requires this particular database engine. When you set up a new database via the Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard begins dumping content in the newly created database, the engine will be set automatically depending on the respective app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either one of them explicitly at any time. In this way, you can use a wide range of apps for your websites.