InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has lots of upsides which have made it the engine of choice for lots of script-powered applications, such as Magento and Joomla™, which have shifted over to InnoDB permanently. For example, importing large data volumes will be faster with InnoDB, as it locks only one row to perform a particular task, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is treated. Put simply, adding new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain issue appears during the process, hence the content that remains in the database will not be damaged.
InnoDB in Website Hosting
InnoDB is available with all our Linux website hosting service by default, not as a paid upgrade or upon request, so you can activate and manage any PHP script-driven application which requires the storage engine without the need to deal with any problem once you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, regardless of whether you take advantage of our single-click installer or create the database and set up the application manually, provided that the application requires it instead of the more famous MyISAM engine. We will generate daily database backups, so you can be certain that you will never lose any data in case you erase a database by accident or you overwrite some crucial information – you will just have to contact us and we will restore everything the way it was.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database through the hosting Control Panel offered with each of our semi-dedicated server accounts and you begin installing a script-driven software app either manually or using our 1-click application installer, the database storage engine will be set automatically on the basis of the prerequisites of the specific application. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any time. To prevent any chance of losing information if you update an app or if you remove a database unintentionally, we’ll perform a backup of all your databases each day, so if anything happens, we can restore your content.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other needed software, so you will not need to do anything if you decide to manage PHP-driven applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new database and start installing the application manually or using our one-click installer tool. The system will detect the engine that the application in question requires and will set it for the specific database, so the installation process will continue impeccably and the app can insert its data into that database. Therefore, you can run applications with various requirements with regard to the MySQL engine without making any modifications on your VPS server.
InnoDB in Dedicated Servers
All Linux dedicated servers that are ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not have to install it manually in case you want to run open-source PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to initiate the installation process – once the setup wizard gains access to the database in question and begins entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to run scripts that need the other widely used MySQL engine, MyISAM, so you will not have to change any settings on the dedicated server. This will permit you to run a variety of scripts on a single physical machine and to use it to its full capacity.