InnoDB is a very popular database storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has got many strong sides which make it the engine of choice for many PHP-driven web apps, including Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing immense volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to carry out a specific task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. Put simply, importing new or editing existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case any problem occurs in the meantime, hence the content that remains in the database won’t be lost.
InnoDB in Cloud Website Hosting
You can run any PHP script-based application that requires InnoDB in case you’ve got a cloud website hosting with our company, as the MySQL database engine is present on our leading-edge cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can activate applications that use the MyISAM engine without any problems as well and, again, the engine will be selected automatically, so you will not need to configure anything manually at any moment. What’s more, we will also perform daily backups of all the MySQL databases that you’ve got in your shared hosting account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our Linux semi-dedicated plans by default, so the moment you buy a new account, you can move on and install any PHP script-driven web application that needs the database storage engine. A few engines are installed on our cloud website hosting platform, so when you set up a new MySQL database and start installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the concrete app’s requirements. This will allow you to install and manage InnoDB-specific applications without needing to cope with any complication and without updating any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you erase or edit any content accidentally, we can easily retrieve it.
InnoDB in VPS Servers
All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any PHP-based app that needs the database storage engine without needing to set up anything manually. You can select Hepsia on the VPS configuration page and your new Virtual Private Server will be set up within 1 hour, so you can log in and begin creating your websites straight away. Once you create a brand-new MySQL database and begin the app installation process, our system will pick the engine for this MySQL database automatically. In this way, you can run different applications simultaneously without the need to change anything on the VPS server. You can set up a WordPress blog that makes use of MyISAM – the default MySQL engine, and a Magento-powered online shopping portal that makes use of InnoDB, for instance.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It’s included in the default software package that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you will be able to sign in and to install any type of script-based application that needs this particular MySQL 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 app. Once the app configuration wizard starts inserting content into the database, the engine will be set automatically depending on the given app’s prerequisites, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any time. Therefore, you can make use of a wide variety of apps for your websites.