InnoDB is a very popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has a lot of strong sides which have made it the engine of choice for numerous PHP-based software applications, among them 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 row to perform a given operation, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is handled. Put simply, importing new or updating existent data will either be entirely completed, or will be aborted and the procedure will be rolled back in case any problem appears during the process, which means that the content that remains in the database won’t be lost.

InnoDB in Web Hosting

You can use any PHP-based software application that requires InnoDB if you’ve got a Linux web hosting package with us, as the database storage engine is present on our advanced 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 continue flawlessly if this engine is required. You can activate apps which use the MyISAM engine without any difficulty as well and, again, the engine will be selected automatically, so you will not need to edit any setting manually at any point. Furthermore, we’ll also generate daily backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

InnoDB comes with each of our Linux semi-dedicated packages by default, so the moment you purchase a new account, you can move on and install any script-driven app that requires the MySQL storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a new MySQL database and start installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the concrete app’s requirements. This will permit you to install and manage InnoDB-specific apps without encountering any problem and without the need to configure any settings in your semi-dedicated account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you delete or edit any content unintentionally, we can swiftly retrieve it.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t need to add it manually in case you want to run open-source scripts that require it. All it takes to activate such a script is to create a new MySQL database and to initiate the setup process – as soon as the installer wizard obtains access to the database in question and starts 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 will also be able to use scripts that need the other very popular MySQL engine, MyISAM, so you will not have to change any settings on the server. This will allow you to use different scripts on one single physical server and to use it to its full potential.