InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a much better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by numerous programmers that create scalable apps, since it works more effectively with enormous data volumes, while it keeps the server processing load at a minimum. What’s more, it locks only one database row in case any information should be modified, whereas lots of other engines lock the entire table and therefore require more time to process several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla releases are two instances of famous PHP-based software applications which have switched to InnoDB.
InnoDB in Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other web hosting providers, it’s an essential part of the default set of features that we are offering with our website hosting packages. If you want to use a PHP script-based web application that needs InnoDB specifically, in order to be activated and to work correctly, you will not have any impediments since the storage engine is available on our custom-developed cloud platform. Regardless of whether you create a brand new database and activate an app manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires it instead of MyISAM. In addition to the exceptional database failure recovery that InnoDB is offering, we also make daily database backups, so that we can quickly restore any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
You can install an open-source script-based software application that needs InnoDB with all of our semi-dedicated server plans, because all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click application installer tool. In either case, the needed engine will be selected automatically the moment the installation of the app starts, so you will not need to change anything manually, regardless of whether the application requires InnoDB or the more regularly used MyISAM. Also, we will always be able to restore any of your databases in case you accidentally remove one, as we carry out several backups every day, each of which is kept for 1 whole week.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the default software package that will be installed on your server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and manage any PHP script-driven web application that needs InnoDB as soon as your VPS server is ready, which takes no more than 60 minutes after the order submission process itself. Several engines are available, so every time you set up a database via the Hepsia hosting Control Panel, a particular engine will be selected when the app activation process commences and our system will recognize the engine that is required by the application in question. In case you need to use MyISAM, for example, you will not have to do anything different than installing the chosen application, whether manually or using our application installer.
InnoDB in Dedicated Servers
All dedicated servers ordered with our custom-built Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually in case you want to use scripts that require it. All it takes to use such a script is to create a new MySQL database and to begin the installation process – as soon as the setup wizard acquires access to the database in question and starts importing content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to update any settings on the server. This will enable you to run different scripts on one single physical machine and to use the latter to its fullest potential.