InnoDB is a very popular database engine for MySQL. It’s an alternative to the default MyISAM engine and it has a lot of upsides which make it the preferred engine for numerous PHP-based web applications, among them Joomla and Magento, which have switched to InnoDB for good. For example, importing enormous volumes of data will be much faster with InnoDB, because it locks only one database row to carry out a specific task, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is treated. Put simply, importing new or editing existent data will either be entirely completed, or will be annulled and the procedure will be rolled back if some problem occurs during the process, so the content that remains in the database won’t be lost.
InnoDB in Website Hosting
InnoDB is offered with all our Linux website hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP script-driven software app which requires the database storage engine without having to deal with any problem once you order your account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, no matter if you take advantage of our 1-click installer or create the database and install the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will create regular MySQL database backups, so you can be sure that you’ll never lose any data if you erase a database unintentionally or you overwrite some essential info – you’ll just have to touch base with us and we will restore your data the way it was.
InnoDB in Semi-dedicated Hosting
You can install an open-source script-powered web application that requires InnoDB with all of our semi-dedicated server plans, as all the accounts are created on our innovative cloud hosting platform where the database engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our one-click app installer tool. Either way, the needed engine will be chosen automatically as soon as the installation of the app begins, so you won’t have to configure anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to restore any of your MySQL databases in case you unintentionally erase one, as we carry out a couple of backups every day, each of which is kept for one whole week.
InnoDB in VPS Web Hosting
If you select a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be included in the default software bundle that will be installed on your server before we hand it over to you. You will not need to set up anything manually and you will be able to install and run any PHP script-powered app that needs InnoDB when your VPS server is up and running, which takes no more than sixty minutes after the order submission itself. A couple of engines are available, so every time you create a MySQL database using the Hepsia Control Panel, a particular engine will be selected when the app installation process starts and our system will automatically recognize which engine is required by the app in question. In case you need MyISAM, for example, you will not need to do anything different from installing the desired app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers Hosting
InnoDB is included by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It is included in the default software bundle that we install on all Hepsia-managed servers, so once your machine is up and running, you’ll be able to log in and to activate any type of script-based web app that needs this MySQL database storage engine. When you set up a new database via the Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app setup wizard starts inserting data into the newly created database, the engine will be selected automatically in accordance with the prerequisites of the specific application, so you can run both MyISAM and InnoDB without the need to select either of them explicitly at any point. Therefore, you can make use of a huge selection of apps for your Internet sites.