InnoDB is a popular database storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got plenty of pluses which have made it the engine of choice for a lot of PHP-powered web apps, among them Joomla and Magento, which have switched to InnoDB permanently. For instance, importing immense amounts of data will be much faster with InnoDB, since it locks only one row to accomplish a specific operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is treated. To put it simply, appending new or modifying existing data will either be entirely completed, or will be annulled and the operation will be rolled back in case any issue occurs in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our cloud web hosting by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP-based application which needs the InnoDB database engine without encountering any problem as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, no matter if you take advantage of our 1-click installation tool or create the database and install the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We’ll generate daily database backups, so you can be certain that you’ll never lose any data if you delete a database by accident or you overwrite some crucial information – you’ll just have to alert us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you can make use of all the options offered by this database engine with any PHP script-driven web app that requires it. It is among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the respective app. You won’t need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To be on the safe side, we will perform regular backups of all your databases, so if anything goes wrong after some update or if you remove some data unintentionally, we will be able to get the database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software pack that will be pre-installed on your VPS server before we hand it over to you. You will not have to activate anything manually and you’ll be able to install and manage any PHP script-driven web application that requires InnoDB when your VPS is set up, which takes no more than one hour after the order procedure itself. Several engines are available, so whenever you create a database through the Hepsia hosting Control Panel, a specific engine will be picked once the app activation process starts and our system will detect the engine that is required by the application in question. In case you need to use MyISAM, for instance, you will not have to do anything different than installing the application of your preference, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is an integral part of the software bundle that will be pre-installed on all Hepsia-equipped servers, so once your physical machine is set up, you will be able to sign in and to activate any script-based web application that requires this particular MySQL storage engine. When you set up a new database via the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app activation wizard begins entering content into the newly created database, the engine will be chosen automatically depending on the prerequisites of the app in question, so you can run both InnoDB and MyISAM without having to select either of them explicitly at any moment. Therefore, you can make use of a large range of apps for your Internet sites.