InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got lots of strong sides that have made it the engine of choice for lots of PHP script-driven web apps, including Joomla and Magento, which have moved to InnoDB permanently. For example, adding immense amounts of data will be much faster with InnoDB, because it locks only one database row to perform a certain operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. In simpler words, importing new or updating existent data will either be fully completed, or will be annulled and the operation will be rolled back if some problem occurs in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

Every script-based web application that requires InnoDB will function flawlessly on our advanced cloud web hosting platform and the MySQL database engine comes with all our cloud hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s specifications without the need to configure any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We’ll generate regular content backups, so in case you accidentally delete a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was just several hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated service by default, so once you create a new account, you can go on and install any PHP-based software application that requires this particular database storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a brand-new MySQL database and start installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen in accordance with the prerequisites of the particular application. This will allow you to activate and manage InnoDB-specific apps without running into any problem and without having to configure any settings in your account. To be on the safe side, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you remove or edit any content accidentally, we can easily retrieve it.

InnoDB in VPS Servers

If our in-house built 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 required pieces of software, so you will not have to do anything if you decide to run PHP-driven web applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand-new database and begin the app installation process manually or through our one-click installation tool. The system will recognize which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the app can enter its content into that database. In this way, you can run applications with different requirements about the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t have to activate it manually if you want 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 accesses the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You’ll also be able to activate scripts that need the other very popular MySQL engine – MyISAM, so you will not need to update any settings on the server. This will permit you to run various scripts on a single physical server and to use the latter to its full potential.