InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has plenty of advantages which have made it the preferred engine for a lot of script-driven web apps, such as Joomla and Magento, which have switched over to InnoDB permanently. For instance, importing immense amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to perform a given operation, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Simply put, appending new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem shows up during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
You’ll be able to install any PHP-driven web application that needs InnoDB in case you’ve got a cloud hosting with us, as the database engine is available on our avant-garde cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can activate applications that use the MyISAM engine without any impediments as well and, again, the engine will be selected automatically, so you will not need to update anything manually at any time. What’s more, we will also carry out daily backups of all the databases that you’ve got in your account, so in case you erase or overwrite anything, we can easily get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
If you set up a new MySQL database through the Control Panel provided with all our semi-dedicated server accounts and you start installing an open-source script-powered app either manually or using our one-click application installer tool, the storage engine for the database will be picked automatically depending on the prerequisites of the given app. Since InnoDB is present on the cloud hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without the need for any manual intervention on your end at any moment. To avoid any chance of losing data if you update an app or if you delete a database accidentally, we’ll carry out backups of all your MySQL databases each day, so if something goes wrong, we can rescue your data.
InnoDB in VPS Web Hosting
When you order a virtual private server from us, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will allow you to manage any script-powered application which requires InnoDB, as the storage engine is an integral part of the software package that will be installed on the server during its creation. When you create a brand-new database via the hosting Control Panel, you simply need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question requires it, so you will not have to do anything else in your account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers Hosting
InnoDB is included by default with all dedicated hosting services ordered with the Hepsia hosting Control Panel. It’s included in the standard software package that will be pre-installed on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to log in and to install any PHP script-based web app that requires this MySQL database engine. When you create a new database through the Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app configuration wizard starts inserting information into the database, the engine will be chosen automatically in accordance with the prerequisites of the given app, so you can use both MyISAM and InnoDB without selecting either one explicitly at any point. Thus, you can make use of a vast variety of applications for your sites.