InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got plenty of pluses that make it the engine of choice for numerous PHP-based web apps, among them Magento and Joomla, which have shifted over to InnoDB for good. For instance, adding large volumes of data will be much faster with InnoDB, as it locks only a single row to perform a specific operation, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. Simply put, appending new or editing existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a certain issue shows up in the meantime, which means that the content that remains in the database will not be lost.
InnoDB in Website Hosting
InnoDB is available with all our website hosting by default, not as a paid upgrade or upon request, so you can install and run any script-driven web app which needs the database engine without any problems once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, no matter if you take advantage of our 1-click installation tool or create the database and activate the app manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll carry out regular backups of all your MySQL databases, so you can rest assured that you will never lose any content in case you delete a database by mistake or you overwrite some important information – you’ll simply have to notify us and we will restore everything back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our semi-dedicated servers by default, so as soon as you create a new account, you can move on and install any PHP script-driven software application that requires the MySQL database engine. A couple of engines are installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the given app’s requirements. This will allow you to install and run InnoDB-specific applications without any problems and without the need to configure any settings in your semi-dedicated account. To be on the safe side, we’ll always have a one-week-old backup of all your databases, so if you remove or change any content accidentally, we can easily rescue it.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom Hepsia Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not have to install it manually in case you wish to activate scripts that need it. All it takes to run such a script is to set up a new MySQL database and to initiate the setup – as soon as the installer wizard receives access to the database and begins entering content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you won’t have to modify any settings on the server. This will permit you to activate various scripts on one single server and to use it to its maximum capabilities.