InnoDB
Find out more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by well known script-powered software applications like Joomla™ 3.x and Magento. It’s ideal for scalable apps, as it works astonishingly well when managing large amounts of data. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can process much more operations for the same period of time. Also, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. If a particular operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the content in the database will be preserved undamaged and won’t be partially mixed with newly entered content.
-
InnoDB in Hosting
Any PHP-driven web application that requires InnoDB will function impeccably on our innovative cloud website hosting platform and the storage engine comes with all our
hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s requirements without having to edit any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll create regular backups of your content, so if you accidentally delete a database that you need or you overwrite certain parts of it, we will be able to restore your data the way it was just a few hours earlier.
-
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our
Linux semi-dedicated hosting by default, so once you purchase a new semi-dedicated account, you can go on and install any PHP script-driven web app that requires this database storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a brand new database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be set based on the concrete app’s requirements. This will permit you to install and manage InnoDB-specific apps without needing to deal with any obstacle and without needing to edit any settings in your semi-dedicated account. To be on the safe side, we’ll always have a one-week-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can quickly retrieve it.
-
InnoDB in VPS Hosting
If you pick a
virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be part of the standard software pack that will be pre-installed on your VPS server before we hand it over to you. You will not need to activate anything manually and you’ll be able to enable and run any open-source script-powered software application that needs InnoDB once your VPS server is set up, which takes no more than one hour after the order submission itself. A couple of engines are available, so every time you set up a MySQL database via the Hepsia Control Panel, a particular engine will be picked once the app installation process starts and our system will automatically recognize the engine that is required by the application in question. If you need MyISAM, for instance, you won’t need to do anything different from installing the app of your preference, whether manually or using our application installer.
-
InnoDB in Dedicated Web Hosting
If you purchase a new
dedicated server, you will be able to choose any of the 3 Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database engine manually to be able to run open-source script-based software apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the server resources that you require to run large-size websites, it is pretty likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a certain app needs MyISAM instead of InnoDB, you will not come across any problem while running it. The engine that will be used will be recognized automatically once the app installation process commences, so you will not need to modify any settings manually at any time.