InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got many pluses which make it the engine of choice for plenty of open-source script-driven software apps, including Joomla and Magento, which have switched over to InnoDB for good. For instance, adding large data volumes will be much faster with InnoDB, since it locks only a single row to perform a given task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. In simpler words, importing new or updating existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case any issue shows up in the meantime, thus the content that remains in the database will not be damaged.
InnoDB in Shared Web Hosting
Every open-source script-powered application that requires InnoDB will function flawlessly on our innovative cloud website hosting platform and the MySQL database engine comes with all our shared web hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s requirements without having to edit any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to take advantage of its full potential. We’ll keep regular content backups, so in case you unintentionally delete a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore the database the way it was just several hours earlier.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing a PHP script-driven software application either manually or using our single-click application installer tool, the MySQL database storage engine will be picked automatically based on the prerequisites of the particular application. Since InnoDB is present on the cloud hosting platform where your new account will be set up, it will be set as the default engine for each application that needs it without any manual action required on your end at any moment. To avoid any chance of losing info if you update an app or if you erase a database accidentally, we will carry out backups of all your MySQL databases every day, so if anything goes wrong, we can rescue your data.
InnoDB in VPS Servers
If you obtain a VPS server from us, you’ll be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to run any script-powered software app which requires InnoDB, as the MySQL database storage engine is an integral part of the default software package that will be installed on your server during its setup. When you create a brand new MySQL database through the hosting Control Panel, you just have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine given that the application in question needs it, so you won’t have to do anything else in your account. Likewise, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers ordered with the Hepsia Control Panel. It’s an essential part of the standard software bundle that will be pre-installed on all Hepsia-equipped servers, so as soon as your machine is ready, you’ll be able to sign in and to install any type of PHP-powered web application that needs this database 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. Once the app activation wizard starts entering information into the newly created database, the engine will be set automatically based on the prerequisites of the particular app, so you can use both InnoDB and MyISAM without the need to select either one of them specifically at any point. Therefore, you can use a vast collection of applications for your Internet sites.