What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a database engine for MySQL databases, which is used by popular PHP script-driven web applications like Magento and Joomla™ 3. It is perfect for scalable apps, since it works very well when handling immense amounts of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. Furthermore, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and updates should be treated. If a given operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially merged with newly entered content.
InnoDB in Website Hosting
InnoDB is offered with all our Linux website hosting plans
by default, not as a paid upgrade or upon request, so you can install and run any open-source script-powered app that requires the storage engine without the need to deal with any problem as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and set up the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will carry out regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you delete a database accidentally or you overwrite some important information – you’ll just have to inform us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Servers
You can run a script-powered application that needs InnoDB with all of our semi-dedicated server
packages, since all the accounts are set up on our cutting-edge cloud web hosting platform where the storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the needed engine will be selected automatically as soon as the activation of the app begins, so you won’t have to change anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Also, we’ll always be able to recover any of your databases if you delete one by accident, as we make a few database backups every day, each of which is preserved for 1 week.
InnoDB in Dedicated Servers
InnoDB is available as standard with all Linux dedicated servers
that are ordered with the Hepsia Control Panel. It’s part of the default software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to activate any type of open-source script-driven software application that requires this particular MySQL database engine. When you create a new database via the hosting Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard begins dumping content in the database, the engine will be set automatically on the basis of the prerequisites of the particular application, so you can run both MyISAM and InnoDB without selecting either one of them specifically at any point. In this way, you can make use of a broad selection of apps for your websites.