InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got a number of upsides which have made it the engine of choice for numerous open-source script-based web applications, including Magento and Joomla, which have shifted over to InnoDB for good. For instance, adding large amounts of data will be faster with InnoDB, since it locks only a single row to perform a specific task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. In simpler words, adding new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case any issue occurs in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Hosting

You can activate any open-source script-based web app that requires InnoDB in case you have a hosting with us, as the database engine is present on our avant-garde cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can activate applications that need the MyISAM engine without any problems as well and, once again, the engine will be selected automatically, so you will not have to change anything manually at any point. Furthermore, we will also carry out regular backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our semi-dedicated servers by default, so as soon as you buy a new account, you can go on and install any script-driven web application that needs this storage engine. A few engines are pre-installed on our cloud platform, so when you set up a brand new database and begin installing an application manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the requirements of the specific app. This will permit you to install and run InnoDB-specific applications without any complication and without needing to edit any settings in your semi-dedicated account. To be on the safe side, we will always have a 1-week-old backup of all your databases, so if you remove or edit any content by accident, we can quickly rescue it.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features which you can pick on the order form when you buy a dedicated server from us. Since this is the most powerful kind of website hosting, it’s rather likely that you’ll run very popular Internet sites that will draw a lot of visitors, and since InnoDB is among the very best options for such sites, we’ll install it along with all the other software applications that are available with a Hepsia-managed server. When you set up a new MySQL database in your account, there won’t be any activated MySQL database engine until you start installing an open-source PHP script, whether manually via your web browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The required engine will be detected and will be set for the database in question, so you can activate scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having any complication.