Database Manager

Managing your databases is much simpler than in the past, on account of the Online Control Panel user interface for MySQL and PgSQL management! Even if you do not have in depth knowledge of working with databases, it will be an easy task to deal with our Database Manager.

You may create a whole new database by only typing the username and password or generate a database back–up with a simple click of the mouse. Moreover, with the Data Manager you will have direct access to the administrative area for every database, so you’re able to effortlessly revise it.

If you have worked with databases, you know that creating a manual database backup is not really an elementary job. So as to change this, we’ve developed a simple tool that can back up your entire database with merely a single mouse click. The backup file shall be set for you in under a minute, with regards to the size of the chosen database.

There are no restrictions on the number of back–ups you could make for a selected database.

PgSQL databases are less popular as opposed to the popular MySQL databases. On the other hand, they are a favored option for programmers who are looking for the maximum safety for their sites and apps. Via the user–friendly Database Manager incorporated into the My Laguna Host Control Panel, you can control all of your PostgreSQL databases with simply a mouse click.

You’ll find PgSQL databases integrated by default inside the advanced shared hosting packages. Assuming that you are with a standard hosting package, you are able to request PgSQL databases to be added in your cloud hosting account as upgrades.

With My Laguna Host, you shall regularly find the most recent release of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more secure than the past storage engine’s edition – MyISAM. It is ACID–compliant and, even more importantly – it includes total transaction support. In addition, it utilizes row–level locking, instead of MyISAM’s table–level locking, that used to cause efficiency problems at high usage times.

Checking the load produced by the databases on your active web site will let you stop all sorts of overload troubles that can slow it down and ward off visitors. For this reason, we have incorporated a descriptive Database Stats tool in the Online Control Panel. There you will find broad info on the inbound requests to your databases for every single hour, day and month.

In line with the quantity of day–to–day and per hour queries, it will be easy to find out which databases are being used the most and also consider steps to enhance their load.