InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of strong sides that have made it the preferred engine for many PHP-driven applications, among them Joomla and Magento, which have switched to InnoDB permanently. For example, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only one row to perform an operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is treated. Simply put, adding new or modifying existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if some problem occurs in the meantime, therefore the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any script-based application which requires the InnoDB database storage engine without the need to deal with any difficulty as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you make use of our single-click installer or create the MySQL database and install the app manually, provided that the app requires InnoDB instead of the more famous MyISAM engine. We will perform regular backups of all your databases, so you can rest assured that you won’t ever lose any content in case you erase a database unintentionally or you overwrite some key information – you just have to inform us and we will restore the database back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our Linux semi-dedicated plans by default, so once you order a new account, you can go ahead and install any PHP script-powered app that needs this particular MySQL database engine. A couple of engines are installed on our cloud hosting platform, so when you create a new MySQL database and begin installing an application manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set in accordance with the particular app’s requirements. This will permit you to install and run InnoDB-specific apps without running into any complication and without the need to change any settings in your account. To take no chances, we’ll always keep a one-week-old backup of all your databases, so if you remove or alter any content accidentally, we can easily retrieve it.
InnoDB in VPS Servers
In case our custom-developed Hepsia hosting Control Panel is chosen during the signup process for your new VPS plans , InnoDB will be installed on the Virtual Private Server together with other required software, so you will not have to do anything if you decide to use open-source script-powered software applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand-new MySQL database and start the app installation process manually or through our single-click installation tool. The system will automatically recognize the engine that the particular application requires and will set it for the specific database, so the installation will continue flawlessly and the app can import its content into that database. Therefore, you can install applications with different prerequisites concerning the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans ordered with our in-house developed Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you would like to activate open-source PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to begin the setup process – as soon as the installer wizard obtains access to the database in question and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to activate scripts that need MyISAM – the other popular MySQL engine, so you won’t have to configure any settings on the dedicated server. This will permit you to run various scripts on a single physical machine and to use it to its maximum capacity.