InnoDB is a MySQL database engine, which has been gaining popularity lately, because it offers a much better overall performance and an improved crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of developers that write scalable web apps, as it works much better with huge data volumes, while it keeps the server processing load low. Additionally, it it locks only one row in the database in case any info should be edited, whereas many other engines lock the entire table and hence require much more time to perform multiple consecutive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ versions are two examples of widely used PHP-powered web applications that have switched to InnoDB.

InnoDB in Hosting

InnoDB is offered with all our hosting service by default, not as a paid upgrade or upon request, so you will be able to activate and run any open-source script-based application which requires the database engine without the need to deal with any complication once you activate your account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you make use of our one-click installation tool or create the database and activate the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We’ll carry out daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data in case you erase a database unintentionally or you overwrite some vital info – you’ll just need to touch base with us and we’ll restore your database back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you start installing a PHP script-powered software app either manually or using our one-click application installer tool, the MySQL database storage engine will be set automatically on the basis of the particular app’s prerequisites. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that needs it without the need for any manual intervention on your end at any time. To prevent any chance of losing data if you update an app or if you delete a database unintentionally, we’ll make backups of all your databases each and every day, so if anything happens, we can rescue your data.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to make use of any open-source script-based web app that needs this particular MySQL database engine without needing to activate anything manually. You can pick Hepsia on the VPS configuration page and your brand-new server will be up and running within sixty minutes, so you can sign in and begin creating your websites straight away. Once you create a brand new MySQL database and begin the app installation process, our system will choose the engine for this MySQL database automatically. Thus, you can install different applications at the same time without having to update anything on the Virtual Private Server. You can have a WordPress-powered online journal that makes use of MyISAM – the default MySQL engine, and a Magento-powered e-commerce site that uses InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB comes by default with all Linux dedicated service ordered with the Hepsia Control Panel. It’s an essential part of the standard software bundle that will be installed on all Hepsia-managed dedicated servers, so as soon as your machine is up and running, you’ll be able to log in and to install any kind of PHP script-based web app that needs this particular database engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine until you start installing an app. Once the app installation wizard begins entering content into the database, the engine will be picked automatically depending on the given app’s prerequisites, so you can use both InnoDB and MyISAM without the need to select either of them explicitly at any time. Therefore, you can make use of an immense range of apps for your sites.