InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by many devs that build highly scalable software applications, because it works more efficiently with immense amounts of data, while it keeps the server load at a minimum. In addition, it locks only one database row if anything should be edited, whereas lots of other engines lock the entire table and therefore require more time to complete several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the latest versions of Joomla are two instances of widely used PHP script-based apps that have moved to InnoDB.

InnoDB in Website Hosting

You’ll be able to run any script-based app that needs InnoDB in case you have a Linux website hosting package with our company, as the database engine is available on our avant-garde cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can install applications that require the MyISAM engine without having any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to configure any setting manually at any point. Furthermore, we will also perform daily backups of all the databases that you have in your shared account, so in case you delete or overwrite something, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

You can run a script-powered web application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our leading-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our 1-click app installer tool. In either case, the needed engine will be picked automatically as soon as the installation of the application starts, so you won’t need to update anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. On top of that, we will always be able to restore any of your databases in case you delete one by mistake, as we carry out several MySQL database backups every day, each of which is saved for 1 whole week.

InnoDB in VPS

All Linux VPS packages that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any open-source script-driven web app that requires this storage engine without the need to activate anything manually. You can select Hepsia on the VPS order page and your new server will be ready within the hour, so you can sign in and start building your websites straight away. When you set up a brand-new MySQL database and start the app installation process, our system will select the engine for that database automatically. In this way, you can install different applications simultaneously without changing anything on the Virtual Private Server. You can have a WordPress-based weblog that makes use of the default MySQL engine – MyISAM, and a Magento e-commerce website that uses the InnoDB engine, for instance.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the features which you can pick on the server configuration page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s quite likely that you will manage very popular Internet sites that will attract lots of people, and since InnoDB is among the very best options for such websites, we’ll enable it along with all the other software apps that come with a Hepsia-managed server. When you create a brand new MySQL database in your account, there won’t be any active storage engine until you start installing an open-source script, whether manually through your web browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The required engine will be automatically detected and will be assigned to the database in question, so you can run scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without any complications.