InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has numerous upsides that make it the engine of choice for a lot of PHP script-based software apps, including Joomla and Magento, which have shifted over to InnoDB for good. For instance, importing enormous amounts of data will be faster with InnoDB, because it locks only a single row to accomplish a task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is tackled. Put simply, importing new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain issue occurs in the meantime, which means that the content that remains in the database will not be damaged.

InnoDB in Web Hosting

InnoDB is available with all our web hosting plans by default, not as a paid upgrade or upon request, so you can install and manage any PHP script-driven application which needs the InnoDB database engine without encountering any problem once you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, no matter if you use our single-click installer or create the MySQL database and set up the app manually, as long as the application requires it instead of the more famous MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you will never lose any data if you erase a database accidentally or you overwrite some key info – you’ll just have to touch base with us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel offered with all our semi-dedicated server accounts and you start installing an open-source script-powered web application either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically based on the requirements of the particular application. Since InnoDB is available on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual intervention required on your end at any moment. To avoid any risk of losing info if you update an app or if you erase a database by accident, we will generate a backup of all your MySQL databases every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Servers

If our in-house developed Hepsia Control Panel is selected during the registration process for your new VPS plans , InnoDB will be activated on the Virtual Private Server along with other needed software, so you won’t need to do anything if you choose to activate script-powered software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a new MySQL database and begin installing the app manually or using our 1-click installation tool. The system will recognize which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will continue impeccably and the app can insert its data into that database. In this way, you can install apps with different requirements in regard to the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options that you can pick on the server configuration page when you buy a dedicated server from us. Since this is the most powerful type of hosting, it’s pretty likely that you will run popular sites that will draw a lot of people, and since InnoDB is among the best choices for such Internet sites, we will activate it along with all the other software applications that come with a Hepsia-managed server. When you set up a new MySQL database in your account, there won’t be any activated storage engine till you start installing a PHP script, whether manually via your Internet browser or using the automatic scripts installer that is included in the Control Panel. The needed engine will be detected and will be set for that database, so you can run scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without experiencing any difficulty.