InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous strengths that make it the engine of choice for many PHP-based web applications, among them Joomla and Magento, which have switched to InnoDB permanently. For example, importing large volumes of data will be faster with InnoDB, since it locks only a single row to execute an operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is handled. Simply put, appending new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back if any problem shows up during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Cloud Web Hosting

InnoDB is available with all our Linux cloud web hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP-based application that needs the InnoDB database engine without having to deal with any difficulty as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, no matter if you make use of our 1-click installation tool or create the database and activate the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular backups of all your databases, so you can be sure that you’ll never lose any data in case you erase a database by accident or you overwrite some key info – you simply need to get in touch with us and we’ll restore your database back to normal.

InnoDB in Dedicated Servers Hosting

Our Hepsia Control Panel is one of the options that you can pick on the server order page when you buy a dedicated server from us. Since this is the most powerful kind of hosting, it is pretty likely that you will run popular Internet sites that will draw plenty of people, and since InnoDB is among the best options for such websites, we’ll enable it along with all the other software apps that come with a Hepsia-managed dedicated server. If you set up a brand-new database in your dedicated server account, there won’t be any active MySQL database storage engine till you start installing a script, whether manually via your browser or using the automatic script installer tool that is included in the Control Panel. The needed engine will be automatically recognized and will be assigned to that database, so you can activate scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without any difficulty.