InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and an improved crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by lots of programmers that build highly scalable web apps, because it works much more effectively with large volumes of data, while it keeps the server load at a minimum. Additionally, it uses row-level locking if any information should be updated, while many other engines lock the entire table and therefore require much more time to process several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or losing data. Magento and the latest releases of Joomla™ are two examples of popular PHP script-based software apps that have shifted over to InnoDB.
InnoDB in Shared Website Hosting
Every PHP script-based software application that needs InnoDB will function flawlessly on our cutting-edge cloud platform and the database engine comes with all our shared website hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to configure any setting in your account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to take advantage of its full potential. We will keep regular backups of your content, so if you unintentionally remove a database that is important to you or you overwrite specific parts of it, we’ll be able to restore your content the way it was only a few hours earlier.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our semi-dedicated hosting packages by default, so once you get a new account, you can go ahead and install any PHP script-driven app that requires this MySQL database engine. A few engines are pre-installed on our cloud website hosting platform, so when you set up a brand-new database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated app installer, the engine for the database will be set on the basis of the prerequisites of the specific app. This will permit you to activate and manage InnoDB-specific applications without having to deal with any complication and without needing to update any settings in your account. To take no chances, we’ll always have a seven-day-old backup of all your databases, so if you delete or alter any content by accident, we can easily recover it.
InnoDB in VPS Hosting
When you obtain a virtual private server from our company, you will be able to take full advantage of our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to activate any script-based web app which requires InnoDB, as this MySQL database storage engine is an essential part of the software bundle that will be installed on your server during its setup. When you create a brand new database through the hosting Control Panel, you just need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine in case the app in question requires it, so you won’t have to do anything else in your VPS account. Similarly, if a certain app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Web Hosting
All Linux dedicated web hosting ordered with our custom Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to install it manually if you want to activate scripts that require it. All it takes to use such a script is to create a new database and to begin the installation process – once the setup wizard acquires access to the database and begins inserting data into it, InnoDB will be set as the default MySQL 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 require the other popular MySQL engine – MyISAM, so you will not have to update any settings on the dedicated server. This will allow you to activate a variety of scripts on one single physical server and to use the latter to its full capacity.