InnoDB
Find out about InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by widespread PHP-based web apps such as Magento and Joomla™ v3. It is perfect for scalable applications, because it performs really well when handling huge data volumes. Instead of locking the whole table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same length of time. Additionally, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and updates should be handled. If a particular operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially merged with newly added content.
-
InnoDB in Cloud Website Hosting
Any open-source script-based software application that needs InnoDB will function impeccably on our avant-garde cloud website hosting platform and the storage engine comes with all our
cloud website hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to edit any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We’ll perform regular backups of your content, so if you unintentionally remove a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore everything the way it was only several hours earlier.
-
InnoDB in Semi-dedicated Hosting
All our
semi-dedicated services support InnoDB and you’ll be able to take full advantage of all the features offered by this MySQL database engine with any PHP-based software app that requires it. It is among the engines that we have on our cloud platform, so the one that will be used depends on the prerequisites of the particular application. You will not need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To be on the safe side, we’ll make regular database backups, so if anything goes wrong after an upgrade or if you delete some data by mistake, we will be able to get the database back to the way it was on any of the past seven days.
-
InnoDB in VPS Hosting
All
Linux VPS hosting services that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to use any PHP script-based app that requires the storage engine without activating anything manually. You can pick Hepsia on the VPS configuration page and your brand new VPS server will be up and running within sixty minutes, so you can log in and start building your websites right away. Once you create a new MySQL database and start the app installation process, our system will choose the engine for that database automatically. Thus, you can activate various applications at the same time without having to configure anything on the server. You can create a WordPress-driven weblog that uses MyISAM – the default MySQL engine, and a Magento-powered online store that makes use of the InnoDB engine, for example.
-
InnoDB in Dedicated Web Hosting
Our Hepsia hosting Control Panel is among the features that you can choose on the order form when you buy a
dedicated server from our company. As this is the most powerful type of website hosting, it is quite likely that you’ll manage very popular sites that will draw lots of people, and since InnoDB is among the best choices for such Internet sites, we will enable it along with all the other software applications that are offered with a Hepsia-equipped server. When you create a brand new MySQL database in your dedicated account, there won’t be any active storage engine until you begin installing a script, whether manually via your browser or using the automatic scripts installer that is available in the Control Panel. The needed engine will be detected automatically and will be assigned to that database, so you can make use of scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without having to deal with any obstacle.