What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has got a number of strong sides which make it the preferred engine for many script-powered applications, such as Magento and Joomla™, which have switched over to InnoDB for good. For example, adding huge data volumes will be much faster with InnoDB, as it locks only one row to perform a particular task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is tackled. In simpler words, importing new or updating existing data will either be entirely completed, or will be canceled and the procedure will be rolled back if a given problem appears during the process, hence the content that remains in the database won’t be lost.
InnoDB in Shared Web Hosting
Every PHP-based application that requires InnoDB will run impeccably on our avant-garde cloud hosting platform and the MySQL storage engine comes with all our shared web hosting
packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to configure any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We will make regular content backups, so in case you accidentally remove a MySQL database that you need or you overwrite specific parts of it, we’ll be able to restore your content the way it was only several hours earlier.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting
support InnoDB and you’ll be able to use all the options offered by this database storage engine with any script-based software app that needs it. It’s among the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the respective app. You won’t need to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer. To be on the safe side, we’ll carry out daily backups of all your databases, so if something goes wrong following some update or if you erase some data unintentionally, we will be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS Hosting
All Linux VPS hosting
that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to make use of any PHP script-driven app that requires this particular database storage engine without having to set up anything manually. You can choose Hepsia on the VPS configuration page and your brand-new VPS server will be up and running within 1 hour, so you can log in and begin building your sites straight away. When you create a brand-new MySQL database and start the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can use different apps simultaneously without configuring anything on the Virtual Private Server. You can create a WordPress personal blog that uses the default MySQL engine – MyISAM, and a Magento-based online store that uses the InnoDB engine, for example.
InnoDB in Dedicated Web Hosting
If you get a new dedicated server
, you will be able to choose one of the three hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL database engine manually in order to be able to run open-source script-driven web applications that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you require in order to manage large-size sites, it’s quite possible that you’ll use InnoDB. You will be able to make use of other engines too, so in case a certain app requires MyISAM rather than InnoDB, you won’t experience any impediment while using it. The engine that will be used will be automatically detected as soon as the app installation commences, so you won’t have to change any setting manually at any point.