InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a significantly better overall performance and a faster database failure recovery compared to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by many programmers that create scalable web applications, as it works better with large volumes of data, while it keeps the server load at a minimum. In addition, it locks only a single row in the database in case any information should be edited, whereas many other engines lock the entire database table and therefore need more time to handle multiple sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla editions are two examples of popular PHP script-based software platforms that have switched to InnoDB.

InnoDB in Website Hosting

Any script-based software application that needs InnoDB will function impeccably on our advanced cloud web hosting platform and the MySQL database storage engine is offered with all our website hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without the need to modify any setting in your hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We’ll generate regular content backups, so if you unintentionally remove a database that is important to you or you overwrite certain parts of it, we’ll be able to restore your database the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

InnoDB is included with all our Linux semi-dedicated hosting by default, so as soon as you get a new account, you can go ahead and install any PHP script-powered web application that needs this MySQL storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a brand-new MySQL database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked based on the requirements of the given app. This will permit you to install and run InnoDB-specific applications without needing to cope with any complication and without editing any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can swiftly recover it.

InnoDB in VPS Web Hosting

If our custom-built Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be installed on the VPS server together with other essential pieces of software, so you will not need to do anything if you choose to manage open-source script-driven applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a new MySQL database and start installing the application manually or through our one-click installer tool. The system will automatically recognize the engine that the app in question requires and will assign it to the specific database, so the installation process will proceed flawlessly and the app can insert its content into that database. Therefore, you can manage apps with different requirements regarding the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t need to add it manually if you would like to activate open-source PHP scripts that need it. All it takes to use such a script is to set up a new database and to begin the installation – as soon as the installation wizard accesses the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to run scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to update any settings on the server. This will permit you to run different scripts on a single physical server and to use the latter to its fullest potential.