InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a better overall performance and an improved database failure recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous web developers that run scalable software applications, due to the fact that it works more effectively with huge amounts of data, while it keeps the server load low. Also, it it locks only one row in the database if anything should be edited, while lots of other engines lock the entire table and thus need much more time to accomplish multiple sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest Joomla editions are two instances of widespread PHP-powered software platforms which have switched to InnoDB.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting services by default, not upon request or as a paid upgrade, so you can activate and run any script-powered web application which needs the database storage engine without any problem as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation process, regardless of whether you use our 1-click installation tool or create the database and activate the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will keep regular backups of all your databases, so you can be sure that you will never lose any data if you delete a database by mistake or you overwrite some key information – you’ll just need to touch base with us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Hosting
You can run a PHP script-driven software app that needs InnoDB with all of our semi-dedicated server plans, as all the accounts are created on our advanced cloud hosting platform where the 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 make use of our one-click application installer. Either way, the needed engine will be selected automatically once the activation of the application begins, so you will not have to update anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to recover any of your MySQL databases in case you delete one by mistake, as we generate a few backups every day, each of which is stored for 1 whole week.
InnoDB in VPS Web Hosting
All VPS web hosting services that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any PHP-driven software application that requires the database storage engine without the need to install anything manually. You can choose Hepsia on the VPS configuration page and your new VPS server will be set up within 1 hour, so you can log in and begin creating your websites straight away. When you set up a new MySQL database and start the app installation process, our system will choose the engine for this database automatically. Thus, you can install various apps simultaneously without changing anything on the Virtual Private Server. You can have a WordPress weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven Internet shop that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Servers Hosting
InnoDB is available as standard with all dedicated servers hosting that are ordered with the Hepsia Control Panel. It’s part of the standard software package that we install on all Hepsia-managed servers, so as soon as your machine is ready, you will be able to log in and to activate a various PHP-powered app that needs this particular storage engine. If you create a new database through the Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app installation wizard begins importing content into the newly created database, the engine will be selected automatically in accordance with the requirements of the specific app, so you can use both MyISAM and InnoDB without the need to select either of them specifically at any time. In this way, you can use a huge variety of applications for your websites.