InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by many programmers that write highly scalable software applications, due to the fact that it works much better with enormous volumes of data, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database if anything should be modified, while lots of other engines lock the entire table and hence need much more time to fulfill multiple sequential tasks. Last, but not least, InnoDB obeys 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 avoid confusion or losing data. Magento and the newest releases of Joomla are two examples of popular open-source script-driven web applications that have moved to InnoDB.
InnoDB in Hosting
InnoDB is offered with all our hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any script-powered web app which requires the InnoDB database engine without having to deal with any impediment as soon as you open your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, no matter if you take advantage of our one-click installation tool or create the database and activate the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll create regular backups of all your MySQL databases, so you can rest assured that you will never lose any data if you erase a database accidentally or you overwrite some essential information – you’ll just need to touch base with us and we will restore your content the way it was.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-based app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud web hosting platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you take advantage of our one-click application installer tool. Either way, the required engine will be chosen automatically as soon as the application’s activation starts, so you will not need to edit anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. In addition, we will always be able to restore any of your databases if you accidentally delete one, as we carry out a few backups every day, each of which is stored for seven days.
InnoDB in VPS Hosting
If you order a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the software pack that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to set up anything manually and you’ll be able to enable and run any PHP-powered web app that requires InnoDB when your VPS is ready, which takes no more than 1 hour after the order submission itself. Several engines are available, so whenever you set up a database through the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process starts and our system will recognize which engine is required by the app in question. If you need to use MyISAM, for example, you will not have to do anything different than installing the preferred app, whether manually or using our app installer tool.
InnoDB in Dedicated Web Hosting
All dedicated web hosting ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you would like to activate scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the installation – once the installation wizard obtains access to the database in question and starts entering data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to activate scripts that need the other popular MySQL engine – MyISAM, so you won’t need to modify any settings on the dedicated server. This will allow you to run different scripts on a single machine and to use it to its full capabilities.