Find out more about InnoDB and find out why it’s already been chosen as the default MySQL database engine.
InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got a lot of strong sides that have made it the engine of choice for a lot of script-powered apps, such as Joomla™ and Magento, which have switched to InnoDB for good. For example, adding huge volumes of data will be much faster with InnoDB, due to the fact that it locks only a single row to perform a specific task, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Put simply, importing new or updating existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case any issue occurs during the process, which means that the content that remains in the database will not be lost.
InnoDB in Shared Website Hosting
You will be able to use any PHP script-powered app that needs InnoDB in case you’ve got a shared website hosting plan
with our company, as the database engine is available on our innovative cloud web hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can run applications that need the MyISAM engine without the need to deal with any complication as well and, once again, the engine will be pre-selected, so you will not need to modify anything manually at any time. Furthermore, we’ll also create daily backups of all the MySQL databases that you’ve got in the shared web hosting account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database from the Control Panel provided with each of our semi-dedicated server
packages and you begin installing a script-based software application either manually or using our 1-click application installer tool, the storage engine for the database will be picked automatically on the basis of the requirements of the particular app. As InnoDB is present on the cloud hosting platform where your new account will be set up, 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 avoid any risk of losing info if you update an application or if you erase a database by mistake, we will carry out backups of all your MySQL databases every day, so if anything goes wrong, we can rescue your data.
InnoDB in VPS Servers
If you order a VPS server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software bundle that will be pre-installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and manage any PHP script-powered software app that needs InnoDB once your VPS server is up and running, which takes no more than one hour after the order submission itself. A number of engines are offered, so anytime you create a database via the Hepsia hosting Control Panel, a particular engine will be activated when the app activation starts and our system will automatically detect the engine that is required by the application in question. In case you need to use MyISAM, for instance, you won’t have to do anything different from installing the chosen app, whether manually or using our app installer.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to activate it manually if you want to use open-source scripts that need it. All it takes to use such a script is to set up a new database and to start the setup process – as soon as the installation wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that need the other widely used MySQL engine, MyISAM, so you will not need to configure any settings on the server. This will permit you to install various scripts on one single physical server and to use it to its maximum capacity.