Databases Manager

The Databases Manager inside our Online Control Panel contains a robust yet simplified interface. You can set up a completely new MySQL or PostgreSQL database by just entering a user name and password. Furthermore, you may create a back–up file or customize the password of the database with simply a click of the mouse.

Through the Databases Manager you’ll possess direct access to the administrative area for every one of your databases, allowing you to make quick adjustments in the event you need to.

In case you have worked with databases, you know creating a manual database back–up isn’t a basic job. In an effort to change this, we’ve developed an effortless to use tool that will back up your entire database with a single click of the mouse. The back–up file shall be ready for you in under a minute, with regards to the size of the selected database.

There won’t be any restrictions on the number of backup copies you can make for a chosen database.

You’ll find PgSQL support in all of our cloud hosting packages. PgSQL databases may not be as sought after and widespread as MySQL, nonetheless they provide you with the greatest level of protection for your web site content. Due to this, a lot of famous companies such as Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, on account of the user–friendly user interface of the Databases Manager.

PgSQL databases are bundled by default with the most advanced web hosting bundles. For the normal packages, they are suggested as upgrades.

The MySQL databases on GARP Hosting’s machines utilize the latest release of the InnoDB storage engine. InnoDB is created to guarantee the max functionality for websites that work with substantial amounts of data. It grants CPU performance that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, which means that it is easy to update/insert/create/alter/drop many times for a single "operation" of your app. Also, it works by using row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Checking the load caused by the databases in your powerful web site will let you avoid any sort of overload difficulties that might slow it down and chase away site visitors. For this specific purpose, we’ve integrated a complete Database Stats tool inside the Online Control Panel. There you can get in–depth information on the inbound requests to your databases for every single hour, day and month.

In line with the quantity of daily and per hour queries, you are going to be able to find out which databases are employed the most and also consider procedures to optimize their work.