InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has lots of strengths that make it the preferred engine for many PHP-driven applications, among them Magento and Joomla™, which have shifted over to InnoDB permanently. For example, adding huge volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to execute a given operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the info is treated. In simpler words, importing new or modifying existent data will either be fully completed, or will be canceled and the operation will be rolled back if some issue shows up in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Web Hosting

You’ll be able to install any PHP-based software application that requires InnoDB in case you have a web hosting with us, as the MySQL database engine is present on our advanced cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can install applications which require the MyISAM engine without any impediments as well and, again, the engine will be pre-selected, so you will not have to configure any setting manually at any moment. What’s more, we’ll also create daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

You can run a PHP script-powered software application that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our advanced cloud platform where the MySQL storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our one-click app installer tool. In either case, the needed engine will be selected automatically the moment the installation of the app begins, so you won’t need to change anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. Furthermore, we’ll always be able to recover any of your databases if you delete one by mistake, as we make a few database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Hosting

When you buy a virtual private server from us, you’ll be able to use our custom-developed Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to run any open-source script-powered app that requires InnoDB, as the storage engine is an essential part of the software bundle that will be pre-installed on the server during its creation. When you set up a brand-new MySQL database via the Control Panel, you just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question requires it, so you will not need to do anything else in your VPS account. Equivalently, if a certain app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Web Hosting

If you purchase a new dedicated server, you will be able to choose one of the 3 Control Panels offered by us – cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database engine manually to be able to use PHP-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the server resources that you require to run large-scale Internet sites, it is very possible that you’ll use InnoDB. You will be able to make use of other engines as well, so if a particular app needs MyISAM instead of InnoDB, you will not need to deal with any problem while running it. The engine that will be used will be automatically recognized the moment the app installation process starts, so you will not need to alter any setting manually whatsoever.