InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of upsides that make it the preferred engine for numerous open-source script-powered software apps, among them Joomla™ and Magento, which have switched over to InnoDB for good. For example, importing large amounts of data will be much faster with InnoDB, due to the fact that it locks only one row to perform a task, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is tackled. In simpler words, importing new or updating existent data will either be entirely completed, or will be canceled and the procedure will be rolled back if a given issue shows up during the process, hence the content that remains in the database won’t be lost.

InnoDB in Hosting

Any script-powered software app that requires InnoDB will run flawlessly on our innovative cloud web hosting platform and the MySQL database engine comes with all our hosting plans. Whenever you create a MySQL 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 having to edit any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We’ll make daily content backups, so in case you accidentally remove a database that you need or you overwrite specific parts of it, we will be able to restore everything the way it was only several hours ago.

InnoDB in Semi-dedicated Hosting

You can make use of an open-source script-based web application that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our advanced cloud hosting platform where the MySQL database engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our single-click application installer tool. Either way, the needed engine will be chosen automatically the moment the activation of the application starts, so you won’t need to update anything manually, no matter if the app requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your MySQL databases if you accidentally remove one, as we carry out a few database backups every day, each of which is kept for one week.

InnoDB in VPS Hosting

All VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to run any PHP script-driven application that needs this MySQL database engine without having to configure anything manually. You can pick Hepsia on the VPS order form and your brand-new Virtual Private Server will be set up within sixty minutes, so you can sign in and begin setting up your websites straight away. When you set up a brand-new MySQL database and start the app activation process, our system will select the engine for this database automatically. In this way, you can make use of different applications simultaneously without having to change anything on the VPS server. You can have a WordPress-driven personal blog that uses the default MySQL engine – MyISAM, and a Magento online shop that makes use of InnoDB, for example.

InnoDB in Dedicated Web Hosting

All dedicated web hosting ordered with our custom-built Hepsia hosting Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database engine, so you won’t have to install it manually in case you would like to use PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to initiate the installation – once the script configuration wizard gets access to the database and starts importing data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to update any settings on the dedicated server. This will permit you to run various scripts on one single physical server and to use the latter to its full capacity.