InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got a number of pluses that make it the preferred engine for many script-powered apps, among them Joomla and Magento, which have switched over to InnoDB for good. For example, importing enormous data volumes will be faster with InnoDB, because it locks only a single row to perform a particular task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is handled. In simpler words, adding new or modifying existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a certain issue shows up during the process, so the content that remains in the database will not be damaged.

InnoDB in Hosting

You can make use of any open-source script-driven application that needs InnoDB if you have a Linux hosting package with us, as the database engine is present on our avant-garde 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 impeccably if this engine is needed. You can activate applications which require the MyISAM engine without having to deal with any impediment as well and, again, the engine will be selected automatically, so you won’t have to modify anything manually at any time. On top of that, we will also generate regular backups of all the databases that you have in your shared hosting account, so if you delete or overwrite something, we can swiftly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB is included with all our semi-dedicated packages by default, so the moment you get a new semi-dedicated account, you can move on and install any PHP script-based application that needs this database engine. A few engines are pre-installed on our cloud web hosting platform, so when you create a new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set in accordance with the particular app’s requirements. This will permit you to install and run InnoDB-specific applications without any obstacle and without the need to change any settings in your account. To avoid any risk, we’ll always keep a seven-day-old backup of all your databases, so if you erase or change any content unintentionally, we can swiftly restore it.

InnoDB in VPS

If our in-house built Hepsia Control Panel is chosen during the registration process for a new Linux VPS packages , InnoDB will be installed on the server together with other needed pieces of software, so you will not have to do anything if you choose to make use of PHP script-powered web apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new database and start the app installation process manually or using our single-click installation tool. The system will detect which engine the particular application needs and will assign it to the specific database, so the installation process will continue flawlessly and the application can enter its data into that database. Therefore, you can make use of apps with different requirements with regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Hosting

If you obtain a new dedicated server, you’ll be able to choose one of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to enable this storage engine manually in order to be able to run script-powered web apps that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the server resources that you need to manage large-scale sites, it’s pretty likely that you will use InnoDB. You will be able to make use of other engines too, so in case a particular app requires MyISAM rather than InnoDB, you won’t have to deal with any difficulty while managing it. The engine that will be used will be recognized automatically when the app installation starts, so you won’t have to configure any settings manually whatsoever.