InnoDB

InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a much better overall performance and an improved database crash recovery compared to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many devs that build highly scalable web applications, due to the fact that it works much more efficiently with huge data volumes, while it keeps the server load at a minimum. Also, it locks only one database row if anything should be updated, whereas many other engines lock the entire database table and hence require more time to process multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest Joomla™ releases are two examples of widely used PHP-based applications which have switched over to InnoDB.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting services by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any PHP script-powered app that needs the storage engine without the need to deal with any obstacle once you order your shared hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, regardless of whether you use our one-click installation tool or create the MySQL database and set up the app manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will make regular MySQL database backups, so you can be certain that you’ll never lose any data if you erase a database by mistake or you overwrite some important information – you will just need to inform us and we will restore everything the way it was.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database through the hosting Control Panel coming with all our semi-dedicated server packages and you begin installing a script-based web app either manually or using our 1-click application installer, the storage engine for the database will be selected automatically on the basis of the particular app’s requirements. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any point. To prevent any risk of losing data if you update an app or if you remove a database by accident, we will carry out backups of all your databases every day, so if something goes wrong, we can retrieve your data.

InnoDB in VPS Hosting

If you choose a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the standard software bundle that will be installed on your server before we hand it over to you. You will not have to activate anything manually and you’ll be able to enable and use any script-driven app that requires InnoDB once your VPS is up and running, which takes no more than 60 minutes after the order process itself. A number of engines are offered, so every time you create a database through the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process commences and our system will automatically detect which engine is required by the app in question. If you have to use MyISAM, for example, you won’t have to do anything different than installing the chosen app, whether manually or using our app installer tool.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our custom-built Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t have to install it manually in case you need to run open-source PHP scripts that need it. All it takes to install such a script is to create a new MySQL database and to initiate the installation process – as soon as the installation wizard obtains access to the database in question and starts dumping content in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will permit you to run different scripts on one single server and to use the latter to its maximum capabilities.