Find out more on InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a very popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has a lot of pluses which make it the engine of choice for lots of open-source script-based apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing huge data volumes will be much faster with InnoDB, due to the fact that it locks only one row to perform a given operation, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. To put it simply, adding new or editing existing data will either be fully completed, or will be canceled and the procedure will be rolled back in case some problem appears during the process, thus the content that remains in the database won’t be lost.
InnoDB in Shared Website Hosting
InnoDB is offered with all our shared website hosting plans
by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any script-driven web app that needs the MySQL database engine without the need to deal with any obstacle once you activate your shared account. InnoDB will be selected automatically as the default engine for a certain database during the app activation, no matter if you make use of our one-click installer or create the database and set up the application manually, as long as the application requires it instead of the more popular MyISAM engine. We will store regular MySQL database backups, so you can be certain that you will never lose any content in case you erase a database accidentally or you overwrite some key information – you will just need to alert us and we will restore the database the way it was.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting plans
include InnoDB and you’ll be able to use all the features offered by this MySQL database engine with any PHP-based software application that needs it. It’s one of the engines that are available on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the app in question. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click app installer. To avoid any risk, we will make daily MySQL database backups, so if something goes wrong following an upgrade or if you erase some content by accident, we will be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
If you select a VPS server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be included in the default software package that will be installed on your server before we give it to you. You will not need to set up anything manually and you will be able to install and use any PHP-based software application that needs InnoDB once your Virtual Private Server is set up, which takes no more than one hour after the order procedure itself. A few engines are available, so whenever you set up a MySQL database through the Hepsia Control Panel, a specific engine will be picked when the app installation process starts and our system will automatically recognize which engine is required by the app in question. If you need to use MyISAM, for example, you will not have to do anything different than installing the app of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the options that you can select on the server order page when you buy a dedicated server
from our company. Since this is the most powerful type of website hosting, it is rather likely that you will run very popular Internet sites that will draw lots of visitors, and since InnoDB is one of the best options for such websites, we’ll activate it together with all the other software applications that come with a Hepsia-managed server. If you set up a brand-new MySQL database in your dedicated server account, there won’t be any active database engine until you start installing a script, whether manually via your Internet browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The necessary engine will be recognized automatically and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without experiencing any obstacle.