InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a 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 many devs that run scalable software applications, because it works more efficiently with immense volumes of data, while it keeps the server processing load at a minimum. Also, it uses row-level locking if any info should be modified, while many other engines lock the entire database table and hence need much more time to fulfill several consecutive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for whatever reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the newest Joomla releases are two examples of famous open-source script-powered web apps that have switched to InnoDB.

InnoDB in Shared Hosting

You will be able to activate any open-source script-based software app that needs InnoDB in case you’ve got a shared hosting with our company, as the MySQL storage engine is available on our avant-garde cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can install apps that need the MyISAM engine without encountering any problem as well and, again, the engine will be selected automatically, so you will not have to configure anything manually at any time. What’s more, we’ll also make daily backups of all the databases that you have in your account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can install a PHP-powered app that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our avant-garde cloud hosting platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the required engine will be chosen automatically as soon as the app’s activation begins, so you will not have to configure anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases if you remove one by mistake, as we create a few backups every day, each of which is kept for 1 whole week.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an essential part of the software package that will be installed on your Virtual Private Server before we give it to you. You won’t need to configure anything manually and you will be able to enable and use any script-based web app that needs InnoDB when your Virtual Private Server is set up, which takes no more than 1 hour after the order submission process itself. A couple of engines are offered, so whenever you create a database through the Hepsia hosting Control Panel, a specific engine will be selected once the app installation process starts and our system will automatically recognize which engine is required by the app in question. In case you have to use MyISAM, for instance, you will not need to do anything different than installing the chosen app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-activated and among everything else, you will get the InnoDB database engine, so you won’t have to activate it manually in case you’d like to activate open-source scripts that require it. All it takes to activate such a script is to create a new database and to begin the setup process – once the installer wizard accesses the database and starts entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to install scripts that need MyISAM, the other popular MySQL engine, so you won’t need to update any settings on the server. This will enable you to activate various scripts on one single machine and to use the latter to its maximum capacity.