InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got plenty of advantages that have made it the engine of choice for many PHP-based applications, among them Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, since it locks only one row to accomplish a task, 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 tackled. To put it simply, appending new or editing existent data will either be entirely completed, or will be annulled and the operation will be rolled back if any problem appears during the process, therefore the content that remains in the database will not be damaged.
InnoDB in Cloud Website Hosting
Every PHP-powered web app that requires InnoDB will function impeccably on our avant-garde cloud platform and the database storage engine comes with all our cloud website hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected based on the app’s specifications without having to update any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We’ll generate daily content backups, so if you unintentionally remove a database that’s important to you or you overwrite certain parts of it, we’ll be able to restore your data the way it was just a few hours earlier.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-powered web application that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our leading-edge cloud hosting platform where the database engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click app installer tool. In either case, the needed engine will be selected automatically as soon as the application’s activation starts, so you will not have to modify anything manually, irrespective of whether the application requires InnoDB or the more frequently used MyISAM. On top of that, we will always be able to recover any of your MySQL databases if you remove one by mistake, as we carry out a few database backups every day, each of which is stored for 1 week.
InnoDB in VPS Hosting
When you order a virtual private server from us, you will be able to use our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to activate any open-source script-powered application which needs InnoDB, as this storage engine is an essential part of the software bundle that will be pre-installed on the server during its configuration. When you create a brand-new MySQL database using the Control Panel, you’ll just have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you will not have to do anything else in your VPS account. Correspondingly, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Web Hosting
InnoDB comes by default with all Linux dedicated web hosting ordered with the Hepsia Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so once your physical machine is assembled, you will be able to sign in and to activate any type of PHP-based app that requires this particular database engine. When you create a new database via the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app activation wizard starts entering information into the database, the engine will be selected automatically based on the respective app’s prerequisites, so you can use both InnoDB and MyISAM without selecting either one of them specifically at any time. Thus, you can make use of a wide selection of applications for your websites.