InnoDB is a storage engine for MySQL databases, which is used by famous PHP-based web applications like Magento and Joomla v3. It’s ideal for scalable applications, because it works very well when handling immense volumes of data. Instead of locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. Plus, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. In case a given task has not been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will be retained intact and will not be partially mixed with newly imported content.

InnoDB in Hosting

InnoDB is available with all our hosting by default, not as a paid upgrade or upon request, so you will be able to install and run any script-powered web app that needs the InnoDB database engine without any problems once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, regardless of whether you use our one-click installation tool or create the database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll create regular backups of all your databases, so you can rest assured that you won’t ever lose any data if you delete a database by mistake or you overwrite some important information – you simply have to contact us and we will restore your database the way it was.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the hosting Control Panel offered with all our semi-dedicated server plans and you begin installing an open-source script-based app either manually or using our single-click app installer tool, the database storage engine will be selected automatically based on the particular app’s prerequisites. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any time. To prevent any chance of losing info if you update an application or if you delete a database by mistake, we’ll carry out backups of all your databases each and every day, so if something happens, we can restore your data.

InnoDB in VPS Servers

If our in-house developed Hepsia hosting Control Panel is picked during the signup process for your new VPS servers , InnoDB will be installed on the server together with other essential pieces of software, so you won’t have to do anything if you decide to install PHP script-powered software apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed too. You can set up a new database and begin installing the app manually or through our 1-click installer tool. The system will automatically detect the engine that the app in question needs and will set it for the specific MySQL database, so the installation process will continue impeccably and the app can import its data into that database. In this way, you can manage applications with various requirements about the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options that you can pick on the server order page when you purchase a dedicated server from us. Since this is the most powerful type of web hosting, it’s pretty likely that you will run highly popular websites that will draw lots of people, and since InnoDB is among the very best choices for such websites, we’ll install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. When you create a new database in your dedicated account, there won’t be any activated database storage engine until you start installing an open-source script, whether manually via your Internet browser or using the automatic script installer tool that is available in the hosting Control Panel. The necessary 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 encountering any complication.