What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by well known script-driven applications like Joomla™ 3 and Magento. It’s excellent for scalable applications, because it excels in handling enormous amounts of data. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. In addition, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – rules that define how data imports and modifications should be handled. If a specific operation has not been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be retained undamaged and won’t be partially merged with newly appended content.
InnoDB in Website Hosting
You can install any PHP-based software app that needs InnoDB in case you have a website hosting plan
with us, as the MySQL storage engine is present on our avant-garde cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can install applications which use the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t need to change any setting manually at any time. In addition, we will also create regular backups of all the databases that you have in the account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
InnoDB comes with all our semi-dedicated hosting plans
by default, so once you create a new account, you can move on and activate any script-driven app that requires this database storage engine. Several engines are pre-installed on our cloud platform, so when you create a brand new database and start installing an app manually, or opt to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the given app’s requirements. This will permit you to activate and run InnoDB-specific applications without needing to cope with any complication and without needing to change 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 delete or edit any content by mistake, we can swiftly retrieve it.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to install it manually in case you’d like to use scripts that need it. All it takes to run such a script is to create a new database and to begin the setup – as soon as the setup wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to edit any settings on the dedicated server. This will enable you to activate various scripts on a single server and to use the latter to its fullest potential.