InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has plenty of strengths which make it the engine of choice for many open-source script-driven web applications, including Joomla™ and Magento, which have switched over to InnoDB permanently. For instance, adding large amounts of data will be much faster with InnoDB, because it locks only a single database row to execute a specific operation, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. In simpler words, importing new or editing existing data will either be fully completed, or will be canceled and the procedure will be rolled back if a certain issue shows up during the process, therefore the content that remains in the database will not be damaged.

InnoDB in Website Hosting

Every PHP-driven web application that requires InnoDB will function flawlessly on our leading-edge cloud hosting platform and the database storage engine is offered with all our website hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without having to update any setting in your account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to get the most out of its full capacity. We’ll create regular content backups, so if you unintentionally erase a database that’s important to you or you overwrite certain parts of it, we’ll be able to restore the database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the hosting Control Panel included with all our semi-dedicated server packages and you begin installing a PHP-based software app either manually or using our single-click application installer, the MySQL database storage engine will be picked automatically on the basis of the prerequisites of the specific app. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any moment. To prevent any chance of losing information if you update an app or if you remove a database by mistake, we’ll carry out a backup of all your MySQL databases every day, so if anything goes wrong, we can restore your data.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to use any PHP script-based web app that needs the MySQL storage engine without having to activate anything manually. You can choose Hepsia on the VPS order page and your brand new VPS server will be set up within 60 minutes, so you can sign in and begin setting up your Internet sites straight away. When you set up a brand-new MySQL database and begin the app activation process, our system will pick the engine for this MySQL database automatically. Thus, you can make use of different applications at the same time without having to edit anything on the VPS server. You can set up a WordPress-driven personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-powered Internet shop that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It is an integral part of the standard software bundle that we install on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to log in and to install a various open-source script-powered web application that requires this MySQL storage engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an app. As soon as the app installation wizard starts dumping data in the database, the engine will be set automatically depending on the requirements of the specific app, so you can use both InnoDB and MyISAM without having to select either one specifically at any moment. Thus, you can use an extensive variety of applications for your sites.