InnoDB is a storage engine for MySQL relational databases, which is used by widespread script-based apps like Magento and Joomla 3. It’s ideal for scalable apps, since it works very well when managing enormous volumes of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same length of time. What’s more, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and updates should be handled. If a certain task has not been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved undamaged and won’t be partially merged with new content.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our cloud web hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-powered app which requires the InnoDB database engine without having to deal with any obstacle as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app activation process, regardless of whether you take advantage of our single-click installation tool or create the MySQL database and set up the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll create regular backups of all your databases, so you can rest assured that you will never lose any data if you delete a database by accident or you overwrite some key info – you will just need to inform us and we will restore the database the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our semi-dedicated servers by default, so as soon as you obtain a new semi-dedicated account, you can move on and activate any PHP-based web app that requires this particular MySQL database storage engine. A few engines are pre-installed on our cloud website hosting platform, so when you create a brand-new database and start installing an application manually, or opt to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be selected depending on the requirements of the specific app. This will allow you to install and manage InnoDB-specific applications without coming across any difficulty and without having to configure any settings in your account. To take no chances, we will always have a 7-day-old backup of all your databases, so if you remove or edit any content by mistake, we can easily retrieve it.