What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a database engine for MySQL relational databases, which is used by well known script-driven software applications like Magento and Joomla™ 3. It is excellent for scalable apps, because it works incredibly well when processing enormous volumes of data. Instead of locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same period of time. What’s more, InnoDB offers a better database crash recovery and supports transactions and foreign keys – a set of rules that determine how data imports and modifications should be handled. If a particular task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be kept safe and sound and won’t be partially merged with new content.
InnoDB in Shared Hosting
InnoDB is offered with all our shared hosting
by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-based software app that needs the InnoDB storage engine without any difficulties once you open your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation, no matter if you use our single-click installation tool or create the MySQL database and activate the app manually, as long as the application requires it instead of the more famous MyISAM engine. We will make daily backups of all your databases, so you can rest assured that you won’t ever lose any content if you delete a database accidentally or you overwrite some vital information – you simply have to notify us and we will restore your database the way it was.
InnoDB in VPS Servers
If you get a VPS server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the software pack that will be installed on your server before we hand it over to you. You won’t have to configure anything manually and you’ll be able to install and use any open-source script-powered web app that needs InnoDB when your VPS is ready, which takes no more than 1 hour after the order process itself. A few engines are offered, so every time you set up a MySQL database via the Hepsia hosting Control Panel, a particular engine will be selected once the app installation process commences and our system will automatically recognize which engine is required by the application in question. If you need MyISAM, for example, you will not need to do anything different than installing the chosen application, whether manually or using our app installer.