InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and a faster crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of web developers that run scalable web applications, as it works more effectively with immense amounts of data, while it keeps the server load at a minimum. In addition, it it locks only one row in the database if any information should be modified, while lots of other engines lock the entire database table and thus require much more time to carry out multiple sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest Joomla versions are two instances of widely used PHP-based applications that have shifted over to InnoDB.
InnoDB in Shared Hosting
You’ll be able to make use of any PHP script-based web application that needs InnoDB if you’ve got a shared hosting with us, as the database engine is available on our cutting-edge cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is required. You can run applications that use the MyISAM engine without encountering any obstacle as well and, once again, the engine will be selected automatically, so you will not have to modify any setting manually at any moment. On top of that, we will also generate daily backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server accounts and you begin installing a PHP script-powered software app either manually or using our 1-click application installer, the MySQL database storage engine will be picked automatically based on the requirements of the given app. As InnoDB is present on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any point. To prevent any risk of losing info if you update an application or if you delete a database unintentionally, we will make backups of all your databases each day, so if something happens, we can retrieve your data.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the standard software bundle that will be installed on your server before we give it to you. You will not need to activate anything manually and you will be able to enable and use any open-source script-based software application that needs InnoDB once your VPS is up and running, which takes no more than 1 hour after the order submission procedure itself. A couple of engines are available, so anytime you create a MySQL database via the Hepsia Control Panel, a specific engine will be activated once the app installation process starts and our system will automatically recognize the engine that is required by the app in question. If you have to use MyISAM, for example, you will not have to do anything different than installing the desired app, whether manually or using our application installer.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you won’t have to install it manually if you need to run open-source scripts that need it. All it takes to run such a script is to set up a new database and to start the installation – once the script setup wizard acquires access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to run scripts that need MyISAM, the other widely used MySQL engine, so you will not have to update any settings on the server. This will permit you to install various scripts on a single machine and to use the latter to its full potential.