Find out more about InnoDB and see why it’s already been picked out as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a better overall performance and an improved database failure recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by a lot of developers that create scalable applications, because it works more effectively with immense data volumes, while it keeps the server processing load low. Moreover, it uses row-level locking in case anything should be updated, whereas many other engines lock the entire table and therefore need much more time to perform multiple sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification process cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the latest Joomla™ editions are two examples of widely used script-based software applications that have switched to InnoDB.
InnoDB in Shared Web Hosting
Any open-source script-based application that needs InnoDB will run flawlessly on our avant-garde cloud platform and the storage engine is offered with all our shared web hosting
plans. Every time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without the need to configure any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We will make daily content backups, so in case you accidentally remove a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated servers
by default, so once you obtain a new account, you can go ahead and activate any PHP script-driven web application that requires this particular storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you set up a new database and start installing an application manually, or decide to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be selected based on the requirements of the particular application. This will permit you to install and manage InnoDB-specific applications without the need to deal with any impediment and without updating any settings in your account. To be on the safe side, we’ll always keep a 7-day-old backup of all your MySQL databases, so if you erase or change any content by accident, we can easily recover it.
InnoDB in VPS Servers
When you acquire a VPS server
from us, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to use any PHP-based web app that requires InnoDB, as this particular MySQL storage engine is an integral part of the software package that will be pre-installed on your VPS server during its setup. When you create a brand-new MySQL database via the Control Panel, you will just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the application in question requires it, so you won’t need to do anything else in your VPS account. Equivalently, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers
ordered with the Hepsia Control Panel. It’s an essential part of the software package that we install on all Hepsia-equipped servers, so as soon as your machine is set up, you’ll be able to log in and to activate any open-source script-based app that needs this particular MySQL database engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app setup wizard begins dumping content in the newly created database, the engine will be chosen automatically in accordance with the specific app’s requirements, so you can run both InnoDB and MyISAM without the need to select either one specifically at any moment. Thus, you can use a broad variety of apps for your sites.