InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP script-driven web applications such as Magento and Joomla 3. It is perfect for scalable applications, because it performs incredibly well when managing large data volumes. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – rules that determine how data inserts and updates should be treated. If a particular operation hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially mixed with new content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting providers, it’s part of the default set of services that we offer with our shared hosting packages. If you would like to make use of a PHP script-based app that requires InnoDB particularly, in order to be installed and to work correctly, you won’t experience any obstacles because the database engine is available on our custom-built cloud hosting platform. Irrespective of whether you create a brand new MySQL database and install an app manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app requires it rather than MyISAM. In addition to the exceptional database failure recovery offered by InnoDB, we also maintain regular backups of all databases, so we can swiftly recover any database in your shared account.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our semi-dedicated servers by default, so as soon as you order a new semi-dedicated account, you can go on and install any PHP script-powered application that needs this MySQL database storage engine. A number of engines are pre-installed on our cloud web hosting platform, so when you set up a new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be set based on the given app’s requirements. This will permit you to install and manage InnoDB-specific apps without having to deal with any complication and without having to modify any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a 1-week-old backup of all your databases, so if you delete or alter any content by accident, we can easily rescue it.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be installed on the server together with other necessary software, so you will not have to do anything if you choose to install PHP-based web apps that require this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand new database and begin installing the app manually or using our single-click installation tool. The system will recognize the engine that the application in question requires and will set it for the specific database, so the installation will proceed flawlessly and the app can import its data into that database. In this way, you can use applications with various requirements in regard to the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Servers
All dedicated servers ordered with our in-house built Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not need to add it manually if you want to use PHP scripts that require it. All it takes to install such a script is to create a new database and to start the setup process – once the script installation wizard acquires access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to configure any settings on the dedicated server. This will enable you to run a variety of scripts on one single physical machine and to use the latter to its fullest capacity.