What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a popular database engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got numerous pluses that have made it the preferred engine for plenty of PHP script-powered web applications, including Magento and Joomla™, which have moved to InnoDB permanently. For instance, adding huge volumes of data will be faster with InnoDB, because it locks only a single database row to complete a task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, importing new or modifying existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case any problem shows up during the process, hence the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
InnoDB is offered with all our cloud hosting plans
by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-based web application which needs the InnoDB database engine without having any problem once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation, regardless of whether you take advantage of our one-click installer or create the MySQL database and install the app manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll make daily backups of all your databases, so you can be sure that you’ll never lose any data if you erase a database by mistake or you overwrite some essential information – you will just need to touch base with us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Servers
You can use a PHP-driven app that requires InnoDB with any of our semi-dedicated server
packages, due to the fact that all the accounts are set up on our advanced cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer. Either way, the required engine will be picked automatically the moment the installation of the application begins, so you will not have to update anything manually, regardless of whether the application needs InnoDB or the more widely used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases if you unintentionally delete one, as we carry out a couple of database backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new VPS plans
, InnoDB will be activated on the server together with other needed pieces of software, so you will not need to do anything if you decide to install PHP-driven apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed too. You can set up a brand-new database and begin installing the application manually or through our 1-click installation tool. The system will automatically detect which engine the particular application needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can insert its data into that database. In this way, you can manage applications with different requirements regarding the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans
ordered with our custom-built Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you wish to run PHP scripts that require it. All it takes to use such a script is to create a new database and to begin the setup – as soon as the script configuration wizard gains access to the database and starts importing content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that need MyISAM, the other widely used MySQL engine, so you will not need to update any settings on the dedicated server. This will allow you to activate different scripts on a single physical server and to use it to its full capacity.