InnoDB
Find out more about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got numerous strengths which make it the preferred engine for numerous PHP-driven apps, including Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, importing immense volumes of data will be faster with InnoDB, since it locks only one row to complete a given task, not the entire database 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. In simpler words, adding new or modifying existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a certain issue shows up during the process, which is why the content that remains in the database will not be lost.
-
InnoDB in Website Hosting
Any PHP-powered app that needs InnoDB will function impeccably on our innovative cloud website hosting platform and the database engine is offered with all our
website hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without having to configure any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to make the most of its full capacity. We’ll maintain daily backups of your content, so if you accidentally delete a database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only a few hours ago.
-
InnoDB in Semi-dedicated Servers
All our
semi-dedicated servers support InnoDB and you will be able to use all the features offered by this database engine with any PHP-powered application that needs it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be used depends on the particular app’s prerequisites. You will not need to do anything manually in order to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click application installer. To be on the safe side, we will maintain regular backups of all your databases, so if anything goes wrong following some update or if you erase some content accidentally, we’ll be able to restore the database the way it was on any of the previous seven days.
-
InnoDB in VPS Servers
When you acquire a
VPS server from us, you will be able to use our in-house built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to run any script-based web application which needs InnoDB, as this MySQL database storage engine is an integral part of the standard software bundle that will be pre-installed on your server during its configuration. When you set up a brand new database via the hosting Control Panel, you will just need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you will not need to do anything else in your account. Analogously, if a certain app requires MyISAM, it will be automatically set as the default engine for this particular database.
-
InnoDB in Dedicated Servers
InnoDB comes by default with all
Linux dedicated service ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is set up, you’ll be able to sign in and to activate any kind of PHP-driven software application that requires this particular database engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any active engine until you start installing an application. As soon as the app installation wizard starts entering data into the newly created database, the engine will be set automatically depending on the specific app’s prerequisites, so you can use both InnoDB and MyISAM without having to select either of them explicitly at any moment. In this way, you can use a wide variety of apps for your websites.