InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by plenty of web developers that write scalable applications, since it works more effectively with large volumes of data, while it keeps the server processing load low. Moreover, it locks only a single row in the database in case anything should be edited, while many other engines lock the entire table and thus need more time to execute multiple successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed for some reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla editions are two examples of widespread PHP script-based apps that have shifted over to InnoDB.

InnoDB in Shared Web Hosting

Every open-source script-powered software app that requires InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the MySQL database engine is available with all our shared web hosting packages. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without having to change any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We will perform daily backups of your content, so if you accidentally erase a database that is important to you or you overwrite specific parts of it, we will be able to restore your data the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

You can activate a PHP-based app that needs InnoDB with all 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 MySQL database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our single-click application installer. In either case, the needed engine will be picked automatically as soon as the application’s installation starts, so you won’t need to edit anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to recover any of your databases if you remove one by mistake, as we carry out several MySQL database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any open-source script-driven web application that requires this particular MySQL database storage engine without the need to set up anything manually. You can pick Hepsia on the VPS order page and your brand-new server will be up and running within 60 minutes, so you can log in and begin building your web sites right away. Once you set up a brand new database and start the app activation process, our system will set the engine for this database automatically. Thus, you can make use of various applications at the same time without updating anything on the server. You can have a WordPress-powered online journal that uses MyISAM – the default MySQL engine, and a Magento online shopping portal that makes use of InnoDB, for instance.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the features which you can choose on the server configuration page when you buy a dedicated server from us. Since this is the most powerful type of hosting, it is rather likely that you will run popular Internet sites that will attract lots of individuals, and since InnoDB is among the very best options for such websites, we’ll install it along with all the other software apps 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 till you start installing a PHP script, whether manually through your browser or using the automatic script installation tool that is available in the hosting Control Panel. The necessary engine will be detected automatically and will be set for that database, so you can activate scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without running into any impediment.