InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got many strong sides that make it the preferred engine for a lot of script-driven software apps, among them Magento and Joomla™, which have moved to InnoDB for good. For instance, adding enormous volumes of data will be much faster with InnoDB, since it locks only a single database row to complete a given operation, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is treated. Put simply, importing new or updating existent data will either be entirely completed, or will be aborted and the procedure will be rolled back in case some problem occurs in the meantime, therefore the content that remains in the database will not be lost.
InnoDB in Cloud Web Hosting
Any PHP script-based software application that needs InnoDB will function flawlessly on our innovative cloud platform and the database storage engine is offered with all our cloud web 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 in question will use will be selected based on the app’s specifications without having to configure any setting in your hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We’ll store daily backups of your content, so in case you accidentally delete a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore your data the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server packages and you start installing an open-source script-driven application either manually or using our 1-click application installer, the storage engine for the MySQL database will be set automatically based on the specific app’s requirements. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any app that requires it without any manual action needed on your end at any time. To prevent any risk of losing info if you update an app or if you remove a database accidentally, we’ll generate a backup of all your databases each and every day, so if something happens, we can recover your content.
InnoDB in VPS
All VPS packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to use any PHP-based web app that requires this database engine without having to install anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be ready within 1 hour, so you can sign in and begin building your sites straight away. Once you create a brand-new database and start the app activation process, our system will choose the engine for that database automatically. In this way, you can make use of various applications at the same time without the need to update anything on the server. You can set up a WordPress personal journal that makes use of MyISAM – the default MySQL engine, and a Magento online shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Hosting
InnoDB is included by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It is an essential part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so once your machine is assembled, you’ll be able to sign in and to activate any type of PHP-powered web application that requires this MySQL storage engine. If you set up a new database via the hosting Control Panel, there won’t be any active engine till you start installing an application. As soon as the app configuration wizard begins importing data into the newly created database, the engine will be selected automatically depending on the prerequisites of the respective application, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any moment. In this way, you can make use of a vast range of apps for your Internet sites.