InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of strong sides which make it the engine of choice for many PHP-based software apps, such as Magento and Joomla, which have switched over to InnoDB permanently. For example, importing enormous amounts of data will be faster with InnoDB, because it locks only one row to execute a particular operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. Simply put, adding new or modifying existing data will either be fully completed, or will be aborted and the operation will be rolled back if some problem shows up during the process, therefore the content that remains in the database won’t be damaged.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting plans by default, not as a paid upgrade or upon request, so you can install and manage any script-based web application which requires the MySQL database engine without the need to deal with any difficulty as soon as you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, no matter if you make use of our single-click installer or create the MySQL database and install the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll create daily MySQL database backups, so you can be sure that you’ll never lose any content if you delete a database by accident or you overwrite some vital information – you’ll simply need to get in touch with us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans support InnoDB and you will be able to make the most of all the options offered by this database storage engine with any PHP-driven application that needs it. InnoDB is one of the engines that are available on our cloud hosting platform, so the one that will be used depends on the requirements of the specific app. You won’t need to do anything manually to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To be on the safe side, we will maintain daily backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you erase some data by mistake, we’ll be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an integral part of the standard software bundle that will be installed on your VPS server before we give it to you. You won’t have to configure anything manually and you’ll be able to install and run any PHP script-based software app that requires InnoDB as soon as your VPS server is set up, which takes no more than 60 minutes after the order submission procedure itself. A few engines are available, so every time you set up a MySQL database through the Hepsia hosting Control Panel, a specific engine will be picked when the app activation process commences and our system will recognize which engine is required by the application in question. If you need to use MyISAM, for example, you will not have to do anything different than installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the features which you can choose on the order page when you purchase a dedicated server from us. Since this is the most powerful kind of hosting, it’s pretty likely that you’ll run popular Internet sites that will attract a lot of visitors, and since InnoDB is among the best options for such sites, we will install it together with all the other software apps that are available with a Hepsia-managed dedicated server. If you set up a brand new database in your dedicated account, there won’t be any activated storage engine till you start installing a PHP script, whether manually through your web browser or using the automatic script installer that is included in the hosting Control Panel. The required engine will be detected and will be assigned to the database in question, so you can run scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without encountering any complication.