InnoDB is a database engine for MySQL databases, which is used by well known open-source script-based web apps such as Joomla v3 and Magento. It’s perfect for scalable applications, as it works very well when managing enormous data volumes. Instead of locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. What’s more, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – a set of rules that define how data imports and modifications should be treated. In case a certain task hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially mixed with newly added content.

InnoDB in Hosting

InnoDB is offered with all our hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP script-based software application that needs the database storage engine without encountering any problem once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation process, irrespective of whether you take advantage of our 1-click installation tool or create the MySQL database and set up the application manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll store regular database backups, so you can rest assured that you won’t ever lose any content if you erase a database by mistake or you overwrite some crucial info – you just need to contact us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the hosting Control Panel provided with each of 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 picked automatically depending on the requirements of the particular application. Since InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any point. To prevent any chance of losing data if you update an application or if you remove a database accidentally, we will perform a backup of all your MySQL databases each day, so if anything happens, we can rescue your data.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is picked during the registration process for your new VPS servers , InnoDB will be installed on the server together with other needed software, so you won’t have to do anything if you choose to install PHP script-driven applications that require this MySQL storage engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a new database and start the app installation process manually or using our 1-click installer. The system will detect the engine that the application in question needs and will assign it to the specific database, so the installation process will proceed impeccably and the app can enter its data into that database. Therefore, you can run apps with different prerequisites in regard to the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options that you can choose on the order page when you purchase a dedicated server from us. As this is the most powerful type of website hosting, it’s very likely that you will run popular sites that will attract lots of visitors, and since InnoDB is one of the very best options for such sites, we will enable it along with all the other software apps that are available with a Hepsia-equipped dedicated server. If you set up a new database in your dedicated server account, there won’t be any activated MySQL database engine until you begin installing a script, whether manually through your web browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The necessary engine will be detected and will be set for the database in question, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without the need to deal with any impediment.