InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has many advantages that have made it the preferred engine for numerous PHP-powered web apps, among them Magento and Joomla, which have switched over to InnoDB for good. For instance, adding enormous amounts of data will be much faster with InnoDB, as it locks only a single row to execute a specific task, 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 treated. In simpler words, adding new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case some problem shows up during the process, which is why the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-driven software app that requires the MySQL storage engine without encountering any problem once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, no matter if you use our 1-click installer or create the database and install the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll keep daily backups of all your databases, so you can rest assured that you won’t ever lose any data if you delete a database accidentally or you overwrite some important info – you will simply have to alert us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel coming with each of our semi-dedicated server packages and you start installing an open-source script-powered software app either manually or using our 1-click application installer tool, the storage engine for the database will be picked automatically on the basis of the requirements of the specific application. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that requires it without any manual intervention required on your end at any point. To avoid any risk of losing information if you update an app or if you delete a database by mistake, we will make backups of all your databases every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be included in the standard software package that will be pre-installed on your VPS server before we give it to you. You won’t need to set up anything manually and you’ll be able to install and use any open-source script-powered app that requires InnoDB once your VPS server is up and running, which takes no more than 60 minutes after the order submission process itself. Several engines are available, so whenever you set up a database through the Hepsia Control Panel, a specific engine will be selected when the app installation commences and our system will recognize which engine is required by the app in question. If you need to use MyISAM, for instance, you will not have 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 among the options which you can select on the server order page when you purchase a dedicated server from our company. Since this is the most powerful kind of website hosting, it is rather likely that you will run popular Internet sites that will draw a lot of people, and since InnoDB is among the very best options for such sites, we will activate it along with all the other software apps that are offered with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your dedicated server account, there won’t be any active storage engine until you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The needed engine will be detected and will be set for the database in question, so you can install scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without having to cope with any complication.