InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster database crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of programmers that build scalable software applications, because it works much better with large volumes of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case any information should be updated, while lots of other engines lock the entire database table and hence need more time to perform multiple sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla™ editions are two examples of widely used open-source script-powered applications that have moved to InnoDB.
InnoDB in Hosting
Every PHP script-driven software application that requires InnoDB will function flawlessly on our leading-edge cloud website hosting platform and the MySQL database engine is available with all our hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to change any setting in your account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to get the most out of its full potential. We will create regular backups of your content, so if you accidentally delete a MySQL database that is important to you or you overwrite a certain part of it, we will be able to restore your data the way it was just a few hours ago.
InnoDB in Semi-dedicated Servers
You can run a PHP-based software application that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our advanced cloud web hosting platform where the MySQL database storage 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 1-click app installer tool. In either case, the required engine will be chosen automatically as soon as the activation of the application begins, so you won’t have to change anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to restore any of your databases in case you delete one by accident, as we make a few backups every day, each of which is kept for seven days.
InnoDB in VPS Servers
In case our in-house developed Hepsia hosting Control Panel is picked during the registration process for your new VPS plans , InnoDB will be installed on the Virtual Private Server along with other required pieces of software, so you won’t need to do anything if you decide to manage script-powered software applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new MySQL database and begin installing the app manually or through our 1-click installer tool. The system will automatically recognize the engine that the particular app requires and will assign it to the specific database, so the installation process will proceed flawlessly and the app can enter its content into that database. Thus, you can make use of applications with different requirements with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom Hepsia Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t need to install it manually in case you wish to use scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the installation process – as soon as the script configuration wizard gets access to the database and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You’ll also be able to run scripts that need the other widely used MySQL engine – MyISAM, so you will not need to edit any settings on the server. This will permit you to install different scripts on a single server and to use the latter to its fullest capabilities.