InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software applications like Magento and Joomla™ 3. It is perfect for scalable apps, as it works very well when processing immense amounts of data. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports database transactions and foreign keys – rules that determine how data inserts and updates should be treated. If a given task hasn’t been fully completed for some reason, the action will be rolled back. In this way, the database content will be retained intact and will not be partially merged with newly appended content.

InnoDB in Website Hosting

You’ll be able to run any PHP script-powered software application that requires InnoDB if you have a Linux website hosting with us, as the database storage engine is present on our cutting-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can activate apps which need the MyISAM engine without any difficulties as well and, again, the engine will be selected automatically, so you will not need to update any setting manually at any time. On top of that, we will also generate regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the features which you can choose on the order page when you purchase a dedicated server from us. Since this is the most powerful type of web hosting, it’s quite likely that you’ll run very popular sites that will attract plenty of visitors, and since InnoDB is one of the best options for such sites, we will enable it along with all the other software applications that come with a Hepsia-equipped server. When you set up a brand-new MySQL database in your account, there won’t be any active MySQL database engine till you start installing a script, whether manually via your web browser or using the automatic scripts installer tool that is included in the Control Panel. The required engine will be automatically recognized and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without encountering any complication.