Databases Manager

Taking control of your databases is less complicated than in the past, due to the Online Control Panel user interface for MySQL and PgSQL management! Even though you may not have thorough experience of working with databases, you will find it easy to handle UrlGuru.com’s Databases Manager.

You could make a brand new database just by entering the user name and security password or produce a database back–up with simply a click of the mouse. At the same time, within the Data Manager you’ll possess direct access to the management area for every database, so you can effectively modify it.

We have made the manual database back–up formation into a simple job. To do this: inside the Databases Manager, click the ’clock’ icon beside the database that you intend to back up and afterwards hang on for a few seconds for the process to take place. Depending on the size of your database, the building of any back–up file will take somewhere between a couple of seconds and a minute.

You can make as many copies of a database as you wish. We haven’t specified any confines on the quantity of databases you can back up either.

The majority of our Linux web hosting plans feature PgSQL support. While dropping behind MySQL when considering popularity and usage, PgSQL databases are famous for supplying the maximum level of security for your website content. That is the key reason why companies like Skype and Yahoo rely on PgSQL databases rather than MySQL.

When it comes to database management, PgSQL is equally easy to use as MySQL.

The MySQL databases on our machines utilize the newest release of the InnoDB storage engine. InnoDB is designed to guarantee the maximum effectiveness for web sites that work with massive volumes of data. It delivers CPU efficiency that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means you can easily update/insert/create/alter/drop a couple of times for one "operation" of your application. Furthermore, it employs row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Keeping track of the load caused by the databases for your powerful web site will help you prevent all overload troubles that might slow it down and chase away site visitors. As a result, we’ve provided a detailed Database Stats tool directly into the Online Control Panel. There you can find thorough info on the arriving requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and per hour queries, you are able to find out what databases are utilized the most and then take actions to optimize their work.