InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has many strong sides that have made it the engine of choice for many PHP-powered software apps, including Joomla and Magento, which have switched to InnoDB permanently. For instance, adding immense volumes of data will be faster with InnoDB, since it locks only a single row to perform a particular task, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, appending new or editing existing data will either be fully completed, or will be aborted and the procedure will be rolled back if any issue shows up during the process, which means that the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
InnoDB is offered with all our Linux web hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP script-based software application which requires the InnoDB storage engine without encountering any obstacle once you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, irrespective of whether you use our single-click installation tool or create the MySQL database and activate the application manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll perform daily database backups, so you can be certain that you’ll never lose any data in case you erase a database unintentionally or you overwrite some crucial information – you will just have to get in touch with us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated packages include InnoDB and you will be able to make use of all the options offered by this MySQL database storage engine with any open-source script-powered application that needs it. It’s among the engines that are available on our cloud website hosting platform, so the one that will be selected depends on the particular app’s requirements. You will not have to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our 1-click app installer tool. To be on the safe side, we will maintain regular backups of all your databases, so if anything goes wrong following an update or if you delete some data by accident, we will be able to get your database back to the way it was on any of the past seven days.
InnoDB in VPS
All Linux VPS packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any script-based web application that requires this MySQL database engine without having to install anything manually. You can choose Hepsia on the VPS configuration page and your brand new server will be up and running within one hour, so you can sign in and start setting up your sites right away. When you create a new database and start the app installation process, our system will pick the engine for this MySQL database automatically. In this way, you can install different apps at the same time without modifying anything on the VPS server. You can set up a WordPress weblog that uses MyISAM – the default MySQL engine, and a Magento-driven shopping portal that makes use of InnoDB, for instance.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually in case you wish to run scripts that require it. All it takes to use such a script is to set up a new database and to begin the installation – as soon as the installer wizard acquires access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that require the other very popular MySQL engine, MyISAM, so you will not have to edit any settings on the dedicated server. This will permit you to activate various scripts on a single physical machine and to use the latter to its full capabilities.