InnoDB is a storage engine for MySQL databases, which is used by famous PHP script-based apps like Joomla™ 3 and Magento. It’s ideal for scalable applications, because it performs stunningly well when managing enormous volumes of data. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. In addition, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and updates should be treated. In case a given task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay undamaged and won’t be partially merged with newly inserted content.
InnoDB in Shared Website Hosting
You will be able to use any PHP script-based application that requires InnoDB if you have a shared website hosting with our company, as the database engine is present on our cutting-edge cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can run apps which use the MyISAM engine without any difficulties as well and, once again, the engine will be pre-selected, so you won’t need to change any setting manually at any time. On top of that, we will also carry out regular backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated servers ordered with the Hepsia Control Panel. It is included in the software package that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is assembled, you will be able to sign in and to install any script-powered application that requires this MySQL storage engine. When you create a new database through the Control Panel, there won’t be any active engine till you start installing an application. Once the app installation wizard begins entering content into the database, the engine will be chosen automatically based on the requirements of the specific application, so you can use both InnoDB and MyISAM without selecting either one explicitly at any time. Thus, you can use an immense selection of apps for your websites.