InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has numerous upsides that have made it the preferred engine for plenty of open-source script-powered apps, including Magento and Joomla, which have moved to InnoDB permanently. For instance, importing huge data volumes will be faster with InnoDB, since it locks only a single row to execute a specific operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is tackled. Put simply, importing new or updating existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a certain issue appears in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Hosting

InnoDB is offered with all our hosting service by default, not as a paid upgrade or upon request, so you can install and manage any PHP script-powered web app that requires the InnoDB database engine without any difficulty as soon as you order your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you use our 1-click installation tool or create the database and set up the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will maintain daily MySQL database backups, so you can rest assured that you’ll never lose any content in case you delete a database by accident or you overwrite some essential info – you will just need to contact us and we will restore everything the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service come with InnoDB and you will be able to take advantage of all the features offered by this database engine with any open-source script-based app that requires it. InnoDB is among the engines that are available on our cloud platform, so the one that will be selected depends on the prerequisites of the particular application. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we’ll carry out daily backups of all your MySQL databases, so if something goes wrong following some update or if you erase some data by accident, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the standard software bundle that will be pre-installed on your VPS server before we hand it over to you. You won’t need to set up anything manually and you will be able to install and manage any open-source script-driven web application that needs InnoDB when your VPS is set up, which takes no more than 60 minutes after the order submission itself. Several engines are available, so every time you create a MySQL database via the Hepsia hosting Control Panel, a particular engine will be selected once the app activation starts and our system will recognize the engine that is required by the app in question. If you have to use MyISAM, for example, you won’t need to do anything different than installing the chosen application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options that you can pick on the server order page when you buy a dedicated server from us. As this is the most powerful type of website hosting, it is quite likely that you will manage highly popular websites that will attract many people, and since InnoDB is one of the very best options for such sites, we’ll activate it along with all the other software apps that are offered with a Hepsia-equipped server. When you set up a brand new database in your dedicated server account, there won’t be any activated database storage engine till you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installer that is included in the Control Panel. The required engine will be recognized automatically and will be assigned to the database in question, so you can run scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without needing to deal with any problem.