InnoDB is a very popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got lots of upsides which have made it the preferred engine for a lot of script-powered apps, such as Joomla™ and Magento, which have switched to InnoDB for good. For instance, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a specific operation, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is treated. Put simply, adding new or modifying existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case some issue appears during the process, hence the content that remains in the database won’t be damaged.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it is included in the default set of features that we’re offering with our cloud website hosting plans. In case you want to make use of a script-based software application that requires InnoDB particularly, in order to be activated and to work correctly, you will not have to deal with any difficulties because the database storage engine is available on our in-house built cloud platform. No matter if you set up a brand-new database and activate an application manually or use our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific application requires it instead of MyISAM. In addition to the exceptional database crash recovery that InnoDB is offering, we also make daily database backups, so we can easily restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server plans and you begin installing a script-powered app either manually or using our one-click application installer tool, the database storage engine will be selected automatically depending on the prerequisites of the given application. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any moment. To prevent any risk of losing info if you update an app or if you remove a database by accident, we’ll make backups of all your databases each day, so if anything goes wrong, we can recover your content.

InnoDB in VPS Servers

If you get a VPS server from our company, you will be able to make use of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to manage any PHP-driven application that needs InnoDB, as this MySQL database storage engine is part of the software bundle that will be installed on the VPS server during its creation. When you create a brand new MySQL database using the Control Panel, you’ll just have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you won’t need to do anything else in your VPS account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s an integral part of the software package that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is up and running, you’ll be able to log in and to activate any type of PHP-powered app that requires this particular MySQL database storage engine. When you create a new database through the Control Panel, there won’t be any active engine until you start installing an app. As soon as the app installation wizard begins importing data into the database, the engine will be selected automatically depending on the respective app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either one specifically at any moment. Thus, you can use an immense selection of apps for your websites.