InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got a number of strong sides that make it the engine of choice for plenty of PHP-driven applications, among them Magento and Joomla, which have switched over to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, since it locks only one row to perform a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is tackled. Put simply, adding new or modifying existing data will either be fully completed, or will be annulled and the procedure will be rolled back in case a given issue shows up during the process, which is why the content that remains in the database won’t be damaged.
InnoDB in Hosting
Every script-based web app that needs InnoDB will function impeccably on our innovative cloud platform and the database storage engine is available with all our hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without the need to edit any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We’ll keep regular backups of your content, so in case you unintentionally erase a database that is important to you or you overwrite certain parts of it, we’ll be able to restore your data the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting come with InnoDB and you can get the most out of all the features of this storage engine with any open-source script-based web application that requires it. InnoDB is among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the app in question. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our single-click application installer tool. To avoid any risk, we will create daily backups of all your MySQL databases, so if anything goes wrong following some update or if you erase some content accidentally, we will be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS
All VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to use any open-source script-based web app that needs this database storage engine without the need to activate anything manually. You can select Hepsia on the VPS order page and your new server will be ready within 1 hour, so you can log in and start setting up your sites straight away. Once you set up a brand-new database and start the app activation process, our system will choose the engine for that MySQL database automatically. In this way, you can install various apps at the same time without updating anything on the server. You can create a WordPress-powered personal journal that uses MyISAM – the default MySQL engine, and a Magento-based web shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Hosting
InnoDB comes by default with all dedicated hosting that are ordered with the Hepsia Control Panel. It is an integral part of the standard software bundle that will be installed on all Hepsia-managed servers, so once your physical machine is set up, you’ll be able to log in and to install any type of script-powered software application that requires this particular storage engine. When you create a new MySQL database via the Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard starts entering information into the newly created database, the engine will be selected automatically on the basis of the requirements of the app in question, so you can run both MyISAM and InnoDB without the need to select either of them specifically at any moment. Therefore, you can use a vast collection of apps for your sites.