InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got a number of advantages that make it the preferred engine for plenty of PHP-powered web applications, among them Joomla and Magento, which have switched over to InnoDB for good. For instance, importing enormous amounts of data will be faster with InnoDB, because it locks only one row to complete a certain operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is tackled. To put it simply, adding new or editing 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, thus the content that remains in the database will not be damaged.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our cloud website hosting services by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any PHP-based web application that requires the InnoDB storage engine without any difficulties as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation process, irrespective of whether you make use of our one-click installer or create the MySQL database and install the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will keep regular MySQL database backups, so you can rest assured that you will never lose any data in case you erase a database accidentally or you overwrite some vital info – you will just need to alert us and we’ll restore the database back to normal.
InnoDB in Semi-dedicated Hosting
You can install an open-source script-driven app that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are created on our innovative cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our single-click app installer. In either case, the needed engine will be selected automatically as soon as the app’s activation begins, so you will not need to change anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you accidentally remove one, as we make a few MySQL database backups every day, each of which is preserved for 1 whole week.
InnoDB in VPS
When you acquire a virtual private server from us, you will be able to use our custom-built Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to run any open-source script-powered software application which requires InnoDB, as the database storage engine is an essential part of the software bundle that will be pre-installed on the server during its creation. When you create a new database using the Control Panel, you just need to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine if the app in question needs it, so you won’t need to do anything else in your VPS account. Correspondingly, if an app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Hosting
InnoDB comes by default with all dedicated hosting services ordered with the Hepsia hosting Control Panel. It is an essential part of the software bundle that will be installed on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to log in and to install any kind of PHP script-based web app that requires this particular storage engine. If you set up 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 activation wizard starts inserting information into the newly created database, the engine will be selected automatically in accordance with the prerequisites of the particular app, so you can run both InnoDB and MyISAM without having to select either one of them explicitly at any time. Therefore, you can use a large variety of apps for your sites.