InnoDB
Learn more about InnoDB and find out why it’s recently been selected 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 engine – MyISAM, and it has a number of strengths that have made it the preferred engine for many PHP-based applications, among them Magento and Joomla™, which have switched over to InnoDB for good. For example, importing immense data volumes will be much faster with InnoDB, as it locks only a single row to execute a particular operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, importing new or modifying existent data will either be entirely completed, or will be aborted and the operation will be rolled back if a given issue shows up during the process, which means that the content that remains in the database won’t be damaged.
-
InnoDB in Shared Website Hosting
You’ll be able to use any script-driven web application that requires InnoDB if you’ve got a
shared website hosting plan with us, as the database storage engine is present on our innovative cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can run apps that need the MyISAM engine without encountering any difficulty as well and, once again, the engine will be selected automatically, so you won’t need to configure anything manually at any point. Furthermore, we will also make daily backups of all the databases that you have in your shared account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.
-
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our
semi-dedicated plans by default, so once you order a new semi-dedicated account, you can go on and activate any PHP script-based web app that requires this database storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a brand-new MySQL database and begin installing an application manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected based on the specific app’s requirements. This will permit you to install and manage InnoDB-specific applications without running into any difficulty and without needing to configure any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can easily rescue it.
-
InnoDB in VPS Servers
If you order a
VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an indivisible part of the standard software bundle that will be pre-installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and manage any script-based web application that needs InnoDB when your VPS server is up and running, which takes no more than one hour after the order process itself. A couple of engines are available, so anytime you set up a database using the Hepsia Control Panel, a specific engine will be picked once the app activation process commences and our system will recognize the engine that is required by the app in question. If you need to use MyISAM, for instance, you won’t need to do anything different than installing the preferred app, whether manually or using our application installer tool.
-
InnoDB in Dedicated Servers
If you obtain a new
dedicated server, you will be able to choose one of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to activate this database storage engine manually so as to be able to run PHP-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you require in order to manage very large websites, it is quite possible that you’ll resort to InnoDB. You will be able to use other engines too, so if a given app requires MyISAM instead of InnoDB, you won’t have to deal with any problem while using it. The engine that will be used will be recognized automatically when the app installation procedure starts, so you won’t have to update any setting manually at any point.