InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and an improved crash recovery compared with the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by lots of programmers that build scalable software applications, as it works more efficiently with enormous amounts of data, while it keeps the server load low. Moreover, it uses row-level locking in case any information should be edited, whereas many other engines lock the entire table and hence need much more time to execute several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla™ editions are two examples of widespread open-source script-based software apps that have moved to InnoDB.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it’s part of the standard set of services offered with our web hosting packages. If you would like to use a script-powered software app that requires InnoDB particularly, in order to be installed and to perform properly, you won’t face any obstacles since the InnoDB storage engine is available on our in-house developed cloud platform. Regardless of whether you create a brand-new database and activate an app manually or take advantage of our 1-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it instead of MyISAM. Besides the outstanding database crash recovery that InnoDB offers, we also generate regular backups of all databases, so we can quickly restore any database in your shared website hosting account.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is picked during the signup process for your new VPS hosting plans , InnoDB will be activated on the server together with other required pieces of software, so you won’t need to do anything if you choose to manage script-powered apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and begin installing the application manually or using our one-click installer. The system will automatically detect which engine the application in question requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the app can import its data into that database. Thus, you can activate applications with various requirements regarding the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

When you order a new dedicated server, you will be able to pick one of the three Control Panels offered by our company – Hepsia and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to add this MySQL database engine manually in order to be able to use script-driven web apps that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you require in order to run very large websites, it’s quite possible that you’ll use InnoDB. You will be able to make use of other engines as well, so if a specific application needs MyISAM instead of InnoDB, you will not run into any impediment while running it. The engine that will be used will be automatically detected as soon as the app installation begins, so you won’t have to modify any setting manually at any moment.