InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has plenty of strong sides which make it the engine of choice for plenty of PHP script-driven software apps, such as Joomla and Magento, which have switched over to InnoDB for good. For example, adding immense data volumes will be much faster with InnoDB, since it locks only one row to accomplish a specific task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the info is handled. In simpler words, appending new or updating existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case some problem appears in the meantime, hence the content that remains in the database won’t be lost.
InnoDB in Web Hosting
You can run any PHP-based software application that requires InnoDB if you have a web hosting plan with us, as the database storage engine is present on our innovative cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can run applications that require the MyISAM engine without encountering any problem as well and, once again, the engine will be selected automatically, so you will not need to configure any setting manually at any point. Furthermore, we’ll also generate regular backups of all the databases that you’ve got in the account, so if you delete or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
InnoDB is offered with each of our semi-dedicated plans by default, so once you obtain a new semi-dedicated account, you can go on and install any open-source script-powered application that requires this database engine. A number of engines are installed on our cloud website hosting platform, so when you create a new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen depending on the prerequisites of the app in question. This will permit you to install and manage InnoDB-specific applications without having any problem and without updating any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your MySQL databases, so if you erase or change any content by accident, we can quickly restore it.
InnoDB in VPS Servers
In case our in-house developed Hepsia hosting Control Panel is selected during the signup process for a new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server along with other necessary software, so you won’t have to do anything if you choose to manage PHP-powered software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can set up a brand new database and begin the app installation procedure manually or through our 1-click installation tool. The system will automatically recognize the engine that the particular app requires and will assign it to the specific database, so the installation process will continue flawlessly and the application can import its content into that database. In this way, you can use applications with various prerequisites concerning the MySQL engine without the need to make any changes on your VPS server.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an essential part of the software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is set up, you will be able to sign in and to install any open-source script-powered software application that needs this storage engine. When you create a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app installation wizard starts entering data into the newly created database, the engine will be selected automatically in accordance with the prerequisites of the given app, so you can use both InnoDB and MyISAM without having to select either one specifically at any point. Thus, you can use an immense range of applications for your sites.