InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP-based apps such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, as it performs astonishingly well when handling huge volumes of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same period of time. Also, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. If a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and will not be partially mixed with newly inserted content.
InnoDB in Shared Website Hosting
Every PHP script-powered app that requires InnoDB will function impeccably on our avant-garde cloud platform and the database engine is offered with all our shared website hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without having to edit any setting in your shared hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll generate daily backups of your content, so in case you unintentionally delete a MySQL database that you need or you overwrite a certain part of it, we will be able to restore the database the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our semi-dedicated hosting by default, so once you order a new account, you can move on and install any open-source script-powered web app that requires this particular storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you set up a brand-new database and start installing an application manually, or decide to use the Hepsia Control Panel-integrated app installer, the engine for the database will be set in accordance with the requirements of the application in question. This will allow you to activate and manage InnoDB-specific apps without encountering any difficulty and without needing to edit any settings in your account. To avoid any risk, we’ll always keep a 1-week-old backup of all your MySQL databases, so if you erase or alter any content unintentionally, we can swiftly restore it.
InnoDB in VPS Web Hosting
If our in-house developed Hepsia hosting Control Panel is picked during the signup process for a new Linux VPS web hosting packages , InnoDB will be activated on the VPS server along with other necessary pieces of software, so you won’t have to do anything if you decide to use script-powered software applications that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and begin the app installation procedure manually or through our one-click installer. The system will recognize which engine the app in question requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can insert its data into that database. In this way, you can activate apps with different prerequisites concerning the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers Hosting
InnoDB is available by default with all Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It is included in the software bundle that we install on all Hepsia-equipped servers, so once your machine is assembled, you will be able to log in and to install any type of open-source script-based web app that needs this MySQL storage engine. When you create a new MySQL database via the Control Panel, there won’t be any active engine until you begin installing an app. Once the app setup wizard begins inserting content into the database, the engine will be picked automatically in accordance with the requirements of the given app, so you can run both MyISAM and InnoDB without having to select either one of them explicitly at any point. Thus, you can use a vast variety of applications for your websites.