InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got many advantages which have made it the engine of choice for many PHP script-powered software apps, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large volumes of data will be faster with InnoDB, since it locks only a single database row to carry out a particular task, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. In simpler words, importing new or editing existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case a certain issue shows up in the meantime, which is why the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

InnoDB is available with all our website hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP-based web application that requires the InnoDB database storage engine without having to deal with any difficulty once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation process, regardless of whether you use our one-click installation tool or create the MySQL database and install the application manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will maintain regular MySQL database backups, so you can be sure that you won’t ever lose any data if you erase a database accidentally or you overwrite some vital info – you just have to touch base with us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel coming with all our semi-dedicated server accounts and you start installing a PHP-based application either manually or using our 1-click application installer, the database storage engine will be selected automatically on the basis of the requirements of the app in question. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual intervention required on your end at any time. To avoid any risk of losing info if you update an application or if you remove a database unintentionally, we’ll carry out backups of all your MySQL databases every day, so if something goes wrong, we can retrieve your content.

InnoDB in VPS Servers

When you buy a VPS server from our company, you will be able to use our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to use any PHP script-based application that requires InnoDB, as this database engine is included in the software bundle that will be installed on the Virtual Private Server during its configuration. When you set up a new database through the hosting Control Panel, you simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you won’t have to do anything else in your VPS 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

Our Hepsia Control Panel is one of the options that you can pick on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of hosting, it is quite likely that you’ll manage highly popular sites that will attract plenty of individuals, and since InnoDB is one of the very best options for such websites, we will enable it together with all the other software applications that are available with a Hepsia-equipped server. When you create a brand new database in your dedicated server account, there won’t be any active MySQL database engine till you start installing an open-source script, whether manually via your browser or using the automatic scripts installer that is included in the hosting Control Panel. The needed engine will be recognized automatically and will be set for that database, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without needing to deal with any obstacle.