InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of advantages which make it the engine of choice for lots of open-source script-based apps, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, importing large data volumes will be faster with InnoDB, since it locks only a single database row to accomplish a particular operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. In simpler words, appending new or editing existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if any problem shows up during the process, so the content that remains in the database will not be damaged.
InnoDB in Website Hosting
InnoDB is offered with all our Linux website hosting packages by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP-based software application that needs the InnoDB database engine without any difficulties once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, regardless of whether you make use of our single-click installation tool or create the database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll perform daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content if you erase a database by mistake or you overwrite some vital information – you will just have to contact us and we’ll restore everything the way it was.
InnoDB in Semi-dedicated Hosting
You can use a script-driven web application that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our leading-edge cloud platform where the MySQL database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our one-click application installer. Either way, the required engine will be selected automatically as soon as the activation of the app begins, so you won’t have to edit anything manually, regardless of whether the application needs InnoDB or the more frequently used MyISAM. On top of that, we will always be able to restore any of your MySQL databases in case you erase one by accident, as we generate a couple of database backups every day, each of which is preserved for one week.
InnoDB in VPS
If our custom-built Hepsia Control Panel is selected during the registration process for a new Linux VPS packages , InnoDB will be activated on the VPS server along with other essential software, so you will not have to do anything if you choose to manage PHP script-powered applications that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand-new database and start the app installation procedure manually or using our one-click installer. The system will automatically recognize the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will proceed impeccably and the application can enter its data into that database. Therefore, you can run apps with various prerequisites concerning the MySQL engine without having to make any modifications on your server.
InnoDB in Dedicated Hosting
When you obtain a new dedicated server, you will be able to choose any of the 3 Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this MySQL storage engine manually to be able to run PHP script-powered web applications that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you require in order to run very large websites, it is rather possible that you’ll use InnoDB. You will be able to use other engines too, so in case a particular application requires MyISAM instead of InnoDB, you won’t need to deal with any problem while managing it. The engine that will be used will be automatically detected as soon as the app installation procedure starts, so you won’t have to update any settings manually at any moment.