InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a better overall performance and an improved database failure recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is used by many programmers that run scalable web applications, as it works better with huge amounts of data, while it keeps the server processing load low. Also, it locks only a single row in the database if any info should be updated, whereas lots of other engines lock the entire table and therefore need more time to execute multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the modification of the entire data cannot be completed for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest Joomla versions are two instances of widespread script-powered software applications that have switched over to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting service by default, not upon request or as a paid upgrade, so you can activate and run any PHP script-based app that requires the InnoDB storage engine without having any problem once you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, no matter if you take advantage of our one-click installation tool or create the database and set up the application manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll generate daily backups of all your MySQL databases, so you can rest assured that you will never lose any data in case you delete a database unintentionally or you overwrite some key information – you simply need to alert us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

You can run a PHP script-based application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud platform where the MySQL storage engine is installed. A new 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 take advantage of our 1-click app installer tool. In either case, the required engine will be picked automatically as soon as the installation of the application begins, so you will not have to edit anything manually, regardless of whether the application needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to recover any of your MySQL databases if you delete one by accident, as we carry out several database backups every day, each of which is saved for 1 whole week.

InnoDB in VPS Servers

All VPS web hosting service that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any open-source script-powered software application that needs the database storage engine without setting up anything manually. You can select Hepsia on the VPS configuration page and your brand new server will be set up within one hour, so you can sign in and begin building your Internet sites right away. When you set up a brand-new MySQL database and start the app activation process, our system will choose the engine for that database automatically. Thus, you can activate different applications simultaneously without editing anything on the Virtual Private Server. You can set up a WordPress-based personal journal that makes use of the default MySQL engine – MyISAM, and a Magento-powered web shop that uses InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It is an integral part of the default software bundle that will be installed on all Hepsia-managed servers, so as soon as your physical machine is ready, you will be able to sign in and to activate any script-based software application that requires this particular database storage engine. If you set up a new database through the Control Panel, there won’t be any activated engine till you begin installing an application. As soon as the app activation wizard starts dumping data in the newly created database, the engine will be chosen automatically on the basis of the prerequisites of the given application, so you can run both MyISAM and InnoDB without selecting either one specifically at any moment. Thus, you can make use of a broad collection of apps for your Internet sites.