What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved database failure recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by plenty of programmers that run highly scalable applications, as it works much more efficiently with huge volumes of data, while it keeps the server load at a minimum. Moreover, it uses row-level locking in case any info should be updated, while lots of other engines lock the entire table and hence require much more time to complete several consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest Joomla™ releases are two examples of widely used script-driven software apps that have switched over to InnoDB.
InnoDB in Shared Website Hosting
You will be able to install any script-based software application that requires InnoDB if you’ve got a shared website hosting plan
with our company, as the database engine is present on our advanced cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can install applications that need the MyISAM engine without any difficulties as well and, again, the engine will be pre-selected, so you will not need to modify any setting manually at any time. Furthermore, we will also carry out daily backups of all the MySQL databases that you have in your shared account, so if you delete or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server
plans and you begin installing a script-based software application either manually or using our 1-click app installer tool, the storage engine for the database will be set automatically on the basis of the prerequisites of the specific application. Since InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any moment. To avoid any risk of losing information if you update an application or if you erase a database unintentionally, we will generate backups of all your databases each and every day, so if something goes wrong, we can rescue your content.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated web hosting plans
ordered with the Hepsia Control Panel. It is included in the software bundle that will be pre-installed on all Hepsia-equipped servers, so as soon as your physical machine is ready, you’ll be able to log in and to install any kind of open-source script-based software application that requires this particular MySQL storage engine. When you create a new database through the Control Panel, there won’t be any activated engine until you begin installing an app. Once the app activation wizard starts importing content into the database, the engine will be set automatically depending on the prerequisites of the specific app, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any point. Thus, you can make use of a wide collection of applications for your sites.