InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got many upsides that make it the engine of choice for lots of PHP-based applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For instance, importing huge volumes of data will be much faster with InnoDB, since it locks only a single row to carry out a particular 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 manner in which the information is treated. Put simply, importing new or modifying existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a given problem shows up in the meantime, which means that the content that remains in the database will not be damaged.

InnoDB in Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it is included in the standard set of services that we are offering with our web hosting packages. If you would like to use a script-based app that needs InnoDB specifically, in order to be installed and to perform correctly, you will not experience any obstacles because the MySQL storage engine is available on our in-house developed cloud platform. Regardless of whether you set up a brand-new database and install an application manually or use our 1-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application requires it rather than MyISAM. In addition to the exceptional database failure recovery that InnoDB offers, we also keep daily backups of all databases, so that we can swiftly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can use a PHP-powered app that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud platform where the database storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click app installer. Either way, the needed engine will be selected automatically the moment the app’s activation starts, so you won’t need to update anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you delete one by accident, as we create a couple of MySQL database backups every day, each of which is saved for 1 week.

InnoDB in VPS Servers

When you order a VPS server from us, you will be able to take advantage of our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to run any PHP script-powered software app that requires InnoDB, as the storage engine is an essential part of the default software package that will be pre-installed on your server during its configuration. When you set up a brand new MySQL database via the Control Panel, you will simply have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question needs it, so you won’t need to do anything else in your VPS account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the features that you can select on the order form when you purchase a dedicated server from our company. Since this is the most powerful type of hosting, it is pretty likely that you will run highly popular websites that will draw a lot of visitors, and since InnoDB is one of the very best choices for such sites, we will enable it together with all the other software applications that are offered with a Hepsia-managed dedicated server. If you create a brand new MySQL database in your dedicated account, there won’t be any activated storage engine until you begin installing an open-source PHP script, whether manually through your web browser or using the automatic scripts installation tool that is available in the hosting Control Panel. The needed engine will be detected and will be set for that database, so you can activate scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having to deal with any complication.