Find out more about InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has lots of strong sides that have made it the preferred engine for a lot of script-powered software apps, among them Joomla™ and Magento, which have moved to InnoDB for good. For instance, importing large amounts of data will be faster with InnoDB, as it locks only a single row to complete a certain task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is handled. To put it simply, appending new or editing existing data will either be entirely completed, or will be annulled and the procedure will be rolled back if a certain issue appears during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Cloud Website Hosting
Every PHP script-powered web application that requires InnoDB will function flawlessly on our advanced cloud hosting platform and the MySQL database storage engine comes with all our cloud website hosting
packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s requirements without having to update any setting in your shared account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to make the most of its full potential. We will generate daily content backups, so if you unintentionally delete a MySQL database that’s important to you or you overwrite certain parts of it, we will be able to restore your database the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a brand-new MySQL database from the hosting Control Panel included with each of our semi-dedicated server
accounts and you start installing an open-source script-driven app either manually or using our 1-click app installer, the storage engine for the database will be selected automatically depending on the prerequisites of the app in question. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without any manual action needed on your end at any moment. To prevent any risk of losing info if you update an app or if you erase a database by mistake, we’ll carry out backups of all your MySQL databases each day, so if something goes wrong, we can retrieve your content.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting packages
ordered with our custom Hepsia Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t have to add it manually in case you wish to activate scripts that need it. All it takes to run such a script is to create a new MySQL database and to initiate the setup process – once the script configuration wizard receives access to the database and begins dumping content in it, InnoDB will be set as the default 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 very popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will permit you to install different scripts on one single physical machine and to use it to its maximum capabilities.