InnoDB is a popular database storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got numerous strengths that have made it the engine of choice for lots of PHP-powered web apps, such as Magento and Joomla, which have switched over to InnoDB permanently. For example, adding enormous volumes of data will be faster with InnoDB, as it locks only a single row to execute a particular operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is handled. Put simply, adding new or modifying existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a given issue appears during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many website hosting service providers, it is included in the default set of features offered with our web hosting packages. In case you wish to use a PHP script-powered software application that requires InnoDB in particular, in order to be activated and to function correctly, you will not need to deal with any problems because the InnoDB database engine is available on our custom cloud web hosting platform. Regardless of whether you set up a brand new MySQL database and activate an app manually or take advantage of our 1-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular application requires it instead of MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also perform daily backups of all databases, so that we can swiftly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting packages include InnoDB and you’ll be able to make use of all the features offered by this MySQL database storage engine with any open-source script-driven web application that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be used depends on the prerequisites of the respective app. You will not have to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we will create daily MySQL database backups, so if something goes wrong following an upgrade or if you remove some data by mistake, we’ll be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS Web Hosting

When you buy a virtual private server from us, you will be able to use our custom Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to activate any open-source script-driven app which needs InnoDB, as this storage engine is an essential part of the default software bundle that will be installed on the Virtual Private Server during its setup. When you set up a brand new database through the hosting Control Panel, you will just have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine if the application in question needs it, so you will not have to do anything else in your VPS account. Identically, if a certain application needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers Hosting

If you acquire a new dedicated server, you’ll be able to choose one of the three hosting Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to add this database engine manually in order to be able to manage PHP script-driven web applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the server resources that you need to run very large websites, it is pretty possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so in case a certain application requires MyISAM instead of InnoDB, you won’t come across any difficulty while managing it. The engine that will be used will be detected automatically when the app installation starts, so you will not have to alter any setting manually at any point.