InnoDB
Learn more about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-powered software applications like Magento and Joomla™ v3. It is perfect for scalable applications, as it works really well when processing enormous amounts of data. Rather than locking the whole table to add new information to a database as many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same length of time. Also, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that specify how data imports and modifications should be handled. If a certain task has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept intact and won’t be partially merged with new content.
-
InnoDB in Website Hosting
InnoDB is available with all our
Linux website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP script-driven application which needs the InnoDB database storage engine without encountering any problem once you activate your shared account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation process, no matter if you make use of our single-click installation tool or create the database and install the app manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content in case you delete a database by mistake or you overwrite some essential info – you will just have to touch base with us and we will restore the database the way it was.
-
InnoDB in Semi-dedicated Hosting
You can activate an open-source script-driven web app that requires InnoDB with any of our
semi-dedicated server plans, because all the accounts are created on our advanced cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our 1-click app installer tool. Either way, the needed engine will be chosen automatically once the application’s activation begins, so you won’t need to modify anything manually, regardless of whether the application needs InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to recover any of your databases in case you unintentionally erase one, as we perform a couple of backups every day, each of which is preserved for one whole week.
-
InnoDB in VPS Web Hosting
If our custom-built Hepsia hosting Control Panel is chosen during the registration process for your new
Linux virtual private servers , InnoDB will be installed on the VPS server along with other necessary pieces of software, so you won’t have to do anything if you choose to use open-source script-powered apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new MySQL database and begin the app installation manually or through our 1-click installation tool. The system will detect the engine that the app in question needs and will assign it to the specific database, so the installation will proceed impeccably and the application can enter its data into that database. Thus, you can run applications with different prerequisites concerning the MySQL engine without having to make any modifications on your server.
-
InnoDB in Dedicated Servers Hosting
InnoDB is available by default with all
Linux dedicated servers hosting that are ordered with the Hepsia Control Panel. It’s an essential part of the software package that we install on all Hepsia-managed servers, so once your machine is ready, you will be able to log in and to activate any PHP script-driven web application that needs this particular database storage engine. When you create a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app setup wizard starts importing content into the database, the engine will be selected automatically in accordance with the prerequisites of the app in question, so you can run both MyISAM and InnoDB without selecting either one specifically at any time. In this way, you can use an immense range of apps for your websites.