Database Manager

Taking control of your databases is less complicated than in the past, as a result of Control Panel interface for MySQL and PgSQL administration! Even if you do not have substantial expertise in working with databases, you will find it effortless to use our Database Manager.

You could make a whole new database by simply keying in the username and security password or produce a database back–up with a click of the mouse. In addition, with the Data Manager you’ll have direct access to the administration area for each and every database, which means you can quickly edit it.

With the Database Manager you’ll be able to make an archived copy of your database whenever you would like! That way, you are going to always have a back–up of your operating content in the event your site gets hacked or if you incorrectly delete a database. To create a backup: click on the ’clock’ image next to a particular database and afterwards wait for a couple of seconds for the process to be finalized.

There are no limitations for the volume of databases you would be able to back up or the volume of backup copies you can make for any database.

PgSQL databases are less common than the standard MySQL databases. Even so, they’re a favored option for developers seeking the best stability for their sites and applications. Through the easy–to–use Database Manager integrated into the URLy Host Control Panel, you can administer all of your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases incorporated by default with the top cloud hosting packages. If you are using a basic hosting package, you can easily ask for PgSQL databases to be added in your website hosting account as upgrades.

With URLy Host, you shall regularly discover the most recent release of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is more dependable when compared to the old storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it offers 100% transaction support. In addition, it works by using row–level locking, in lieu of MyISAM’s table–level locking, that would always lead to performance issues at high usage periods.

Tracking the load produced by the databases within your dynamic website makes it possible to reduce all overload problems that could slow it down and ward off site visitors. For this purpose, we’ve incorporated a descriptive Database Stats tool directly into the Control Panel. There you can get comprehensive info about the arriving requests to your databases for each and every hour, day and month.

Using the amount of daily and per hour queries, you will be able to find out what databases are being used the most and then take steps to optimize their load.