InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has numerous strong sides that have made it the preferred engine for a lot of PHP script-powered web apps, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large amounts of data will be faster with InnoDB, because it locks only one row to accomplish an operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is tackled. Put simply, importing new or editing existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if any issue shows up during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an integral part of the default set of services offered with our shared hosting packages. If you would like to make use of a PHP script-based application that requires InnoDB particularly, in order to be installed and to operate properly, you won’t encounter any obstacles since the storage engine is available on our custom-developed cloud platform. Irrespective of whether you set up a new MySQL database and install an application manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires InnoDB instead of MyISAM. Besides the incredible database failure recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can easily restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you’ll be able to make use of all the features offered by this database engine with any open-source script-driven web application that needs it. InnoDB is among the engines that we have on our cloud hosting platform, so the one that will be used depends on the particular app’s prerequisites. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer. To avoid any risk, we will keep daily MySQL database backups, so if something goes wrong after some update or if you delete some data accidentally, we will be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is selected during the signup process for a new VPS plans , InnoDB will be installed on the VPS server together with other needed software, so you won’t have to do anything if you decide to activate open-source script-based web apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a brand-new database and begin the app installation procedure manually or using our 1-click installer tool. The system will automatically recognize the engine that the app in question requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can insert its data into that database. In this way, you can install apps with various requirements with regard to the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software package that will be installed on all Hepsia-equipped servers, so once your physical machine is assembled, you will be able to sign in and to activate any kind of PHP script-driven web app that needs this database storage engine. If you create a new MySQL 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 dumping information in the database, the engine will be selected automatically in accordance with the prerequisites of the application in question, so you can use both InnoDB and MyISAM without having to select either of them specifically at any time. Therefore, you can make use of a huge range of apps for your websites.