InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a much better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is preferred by a lot of devs that run highly scalable applications, since it works more efficiently with enormous data volumes, while it keeps the server load low. Furthermore, it uses row-level locking in case any information should be updated, whereas many other engines lock the entire database table and thus require much more time to process multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for whatever reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest versions of Joomla™ are two instances of popular script-powered applications that have shifted over to InnoDB.
InnoDB in Cloud Website Hosting
You’ll be able to activate any open-source script-driven application that requires InnoDB if you have a Linux cloud website hosting service
with our company, as the storage engine is available on our avant-garde cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can activate applications that use the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be selected automatically, so you won’t have to modify anything manually at any point. In addition, we’ll also make daily backups of all the MySQL databases that you’ve got in the shared web hosting account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the Control Panel included with each of our semi-dedicated server
plans and you start installing an open-source script-powered software app either manually or using our one-click app installer tool, the storage engine for the MySQL database will be picked automatically based on the requirements of the particular application. Since InnoDB is present on the cloud platform where your new account will be created, it will be set as the default engine for each app that needs it without any manual intervention required on your end at any moment. To prevent any chance of losing data if you update an app or if you erase a database unintentionally, we will make backups of all your databases every day, so if something goes wrong, we can retrieve your data.
InnoDB in VPS Servers
If you choose a VPS server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be an essential part of the standard software pack that will be pre-installed on your Virtual Private Server before we give it to you. You won’t have to activate anything manually and you’ll be able to enable and manage any PHP-driven web application that requires InnoDB when your Virtual Private Server is set up, which takes no more than one hour after the order submission process itself. A couple of engines are available, so anytime you set up a MySQL database using the Hepsia Control Panel, a particular engine will be selected when the app installation begins and our system will automatically detect which engine is required by the app in question. In case you need to use MyISAM, for instance, you will not need to do anything different from installing the chosen app, whether manually or using our app installer.
InnoDB in Dedicated Servers
When you buy a new dedicated server
, you’ll be able to select any of the three Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to enable this MySQL database storage engine manually so as to be able to use open-source script-based web apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you need in order to run very large sites, it’s very likely that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a certain application needs MyISAM instead of InnoDB, you will not have any obstacle while using it. The engine that will be used will be automatically detected once the app installation process commences, so you will not have to edit any setting manually at any point.