InnoDB is a very popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has many strengths which make it the engine of choice for lots of PHP script-powered software apps, including Joomla and Magento, which have moved to InnoDB for good. For example, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only one row to execute a specific operation, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is tackled. Put simply, appending new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a given issue appears during the process, hence the content that remains in the database will not be damaged.

InnoDB in Hosting

While InnoDB is either not available or a paid upgrade with many other hosting service providers, it’s an integral part of the default set of services that we are offering with our hosting packages. If you would like to use a script-driven web app that needs InnoDB specifically, in order to be installed and to work correctly, you won’t face any impediments since the MySQL database storage engine is available on our in-house developed cloud web hosting platform. Irrespective of whether you set up a brand new database and install an application manually or use our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the particular app requires InnoDB instead of MyISAM. In addition to the amazing database crash recovery that InnoDB offers, we also maintain daily database backups, so we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server accounts and you start installing a PHP script-powered web app either manually or using our 1-click application installer, the database storage engine will be set automatically depending on the prerequisites of the given app. Since InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without the need for any manual action on your end at any point. To avoid any chance of losing information if you update an app or if you delete a database by mistake, we’ll perform backups of all your MySQL databases each day, so if something goes wrong, we can restore your data.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to take advantage of any script-based software application that needs the database engine without the need to activate anything manually. You can choose Hepsia on the VPS configuration page and your brand new server will be up and running within sixty minutes, so you can sign in and begin creating your websites straight away. When you create a brand-new database and start the app activation process, our system will choose the engine for this database automatically. Thus, you can run various apps simultaneously without having to modify anything on the VPS server. You can have a WordPress-powered personal weblog that uses MyISAM – the default MySQL engine, and a Magento online shop that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It is an integral part of the default software bundle that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is assembled, you will be able to log in and to install a various script-based application that requires this MySQL storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app installation wizard begins inserting information into the newly created database, the engine will be selected automatically depending on the requirements of the given application, so you can use both MyISAM and InnoDB without having to select either one explicitly at any time. Thus, you can use an extensive collection of applications for your Internet sites.