InnoDB is a database engine for MySQL databases, which is used by well known script-driven apps such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, as it performs astonishingly well when managing enormous amounts of data. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same period of time. Besides, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – rules that define how data inserts and modifications should be treated. If a given operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially merged with new content.

InnoDB in Website Hosting

You can use any PHP script-powered web app that requires InnoDB in case you have a Linux website hosting with us, as the MySQL storage engine is available on our leading-edge cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can run apps which need the MyISAM engine without encountering any problem as well and, once again, the engine will be pre-selected, so you will not have to change anything manually at any moment. What’s more, we will also create regular backups of all the MySQL databases that you have in your shared hosting account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the features which you can pick on the server configuration page when you purchase a dedicated server from our company. Since this is the most powerful kind of website hosting, it’s quite likely that you’ll run highly popular sites that will draw plenty of visitors, and since InnoDB is among the best choices for such sites, we will activate it together with all the other software applications that are offered with a Hepsia-equipped server. If you set up a brand-new MySQL database in your dedicated server account, there won’t be any active MySQL storage engine till you begin installing an open-source script, whether manually through your Internet browser or using the automatic script installer tool that is available in the Control Panel. The required engine will be recognized and will be assigned to the database in question, so you can use scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having any impediment.