InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has a lot of strong sides which have made it the engine of choice for lots of PHP-based web apps, among them Magento and Joomla, which have switched to InnoDB permanently. For example, adding immense amounts of data will be faster with InnoDB, because it locks only a single row to accomplish a particular operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the info is handled. In simpler words, adding new or modifying existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case some problem appears during the process, thus the content that remains in the database will not be lost.
InnoDB in Shared Web Hosting
Every PHP-based app that requires InnoDB will run flawlessly on our leading-edge cloud website hosting platform and the database engine is available with all our shared web hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s requirements without the need to configure any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will create daily backups of your content, so if you accidentally delete a database that’s important to you or you overwrite some part of it, we will be able to restore your database the way it was only a few hours earlier.
InnoDB in Semi-dedicated Servers
You can activate a PHP-powered application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our leading-edge cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our single-click application installer tool. In either case, the required engine will be chosen automatically the moment the installation of the application starts, so you will not need to configure anything manually, no matter if the application needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to retrieve any of your databases in case you unintentionally erase one, as we perform several backups every day, each of which is saved for seven days.
InnoDB in VPS Servers
If our custom Hepsia Control Panel is picked during the registration process for your new VPS plans , InnoDB will be activated on the Virtual Private Server together with other necessary pieces of software, so you won’t need to do anything if you decide to run PHP-based web apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new MySQL database and start installing the app manually or using our 1-click installer tool. The system will automatically recognize which engine the application in question requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can dump its content in that database. In this way, you can install applications with various prerequisites about the MySQL engine without making any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB database engine, so you won’t have to activate it manually in case you’d like to run PHP scripts that need it. All it takes to install such a script is to create a new database and to start the setup process – as soon as the script configuration wizard acquires access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to change any settings on the dedicated server. This will allow you to install various scripts on a single machine and to use the latter to its full capabilities.