InnoDB is a popular storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got many pluses that have made it the preferred engine for a lot of open-source script-powered web applications, including Magento and Joomla™, which have switched to InnoDB permanently. For example, importing immense amounts of data will be much faster with InnoDB, because it locks only one database row to complete a task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is tackled. Simply put, adding new or modifying existing data will either be fully completed, or will be canceled and the procedure will be rolled back if some issue appears in the meantime, so the content that remains in the database won’t be lost.
InnoDB in Web Hosting
InnoDB is offered with all our web hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP-driven app that needs the InnoDB database engine without any problems as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation process, irrespective of whether you use our 1-click installer or create the MySQL database and activate the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We’ll store daily backups of all your MySQL databases, so you can be certain that you will never lose any data in case you delete a database by accident or you overwrite some crucial information – you just need to inform us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server accounts and you start installing a PHP-driven web application either manually or using our single-click application installer, the database storage engine will be picked automatically based on the prerequisites of the given application. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any time. To avoid any risk of losing information if you update an application or if you delete a database accidentally, we’ll perform backups of all your databases each day, so if anything happens, we can recover your content.
InnoDB in VPS Servers
All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to make use of any PHP-powered web app that needs the database engine without the need to configure anything manually. You can choose Hepsia on the VPS order form and your brand new server will be ready within sixty minutes, so you can sign in and start creating your web sites straight away. Once you set up a new database and begin the app installation process, our system will choose the engine for that database automatically. Thus, you can use various applications at the same time without having to update anything on the Virtual Private Server. You can have a WordPress-powered online blog that makes use of the default MySQL engine – MyISAM, and a Magento online shopping portal that makes use of InnoDB, for instance.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is among the features which you can select on the order page when you purchase a dedicated server from us. As this is the most powerful kind of hosting, it is rather likely that you will manage highly popular websites that will draw plenty of individuals, and since InnoDB is one of the very best choices for such sites, we’ll enable it along with all the other software apps that come with a Hepsia-managed server. When you set up a new MySQL database in your account, there won’t be any activated MySQL storage engine till you start installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installer tool that is included in the hosting Control Panel. The needed engine will be detected and will be assigned to that database, so you can make use of scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without encountering any obstacle.