InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has a number of strong sides which have made it the preferred engine for a lot of script-powered applications, including Magento and Joomla, which have moved to InnoDB permanently. For instance, importing large volumes of data will be faster with InnoDB, due to the fact that it locks only one database row to perform a given task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is tackled. Put simply, appending new or updating existent data will either be fully completed, or will be canceled and the operation will be rolled back if a certain problem occurs during the process, which is why the content that remains in the database will not be damaged.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the Control Panel provided with each of our semi-dedicated server packages and you start installing a script-powered web application either manually or using our one-click app installer, the database storage engine will be set automatically based on the prerequisites of the specific application. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any time. To prevent any chance of losing information if you update an app or if you delete a database unintentionally, we will make backups of all your MySQL databases each day, so if anything happens, we can recover your data.
InnoDB in VPS Servers
If our custom-developed Hepsia Control Panel is picked during the registration process for your new VPS web hosting plans , InnoDB will be installed on the server together with other needed software, so you won’t need to do anything if you choose to use open-source script-driven web applications that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a new MySQL database and begin installing the application manually or through our single-click installer. The system will recognize which engine the particular app needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can import its data into that database. Thus, you can manage applications with various requirements with regard to the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Servers
All Linux dedicated web hosting plans ordered with our custom Hepsia Control Panel include a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually if you’d like to run PHP scripts that require it. All it takes to activate such a script is to create a new database and to initiate the setup – as soon as the script installation wizard obtains access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to install scripts that require MyISAM, the other popular MySQL engine, so you won’t have to configure any settings on the dedicated server. This will allow you to install various scripts on one single machine and to use it to its full potential.