Databases Manager

Taking control of your databases is much easier than before, on account of the Web Site Control Panel interface for MySQL and PgSQL management! Assuming you do not have thorough knowledge of dealing with databases, you will find it effortless to use Lovenote Websites’s Databases Manager.

You could make a completely new database by simply typing the username and password or create a database back–up with merely a click of the mouse. Moreover, through the Data Manager you will have direct access to the administrator area for every database, so you can instantly manage it.

If you have dealt with databases, you already know that generating a manual database back–up is just not an elementary task. In an effort to change this, we have developed an effortless to use tool that can back up your complete database with just one click of the mouse. The back–up file is going to be all set for you in less than a minute, depending on the size of the chosen database.

There are no limitations on the total number of copies you could make for a particular database.

A lot of Lovenote Websites’s hosting packages deliver PgSQL support. Although dropping behind MySQL in terms of acceptance and employment, PgSQL databases are renowned for delivering the top level of safety for your web site content and articles. That is the key reason why businesses like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

With respect to database administration, PgSQL is as quick as MySQL.

The MySQL databases on our web servers work with the most up–to–date build of the InnoDB storage engine. InnoDB is designed to guarantee the top performance for websites that work with substantial amounts of data. It grants CPU performance that could not be matched by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, which means you can easily update/insert/create/alter/drop more than once for one "operation" of your application. In addition, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Checking the load accumulated by the databases on your busy web site will let you prevent any sort of overload problems that might slow it down and ward off website visitors. For this specific purpose, we have designed a detailed Database Stats tool inside the Web Site Control Panel. There you can see extensive info about the incoming requests to your databases for every single hour, day and month.

Using the number of day–to–day and by the hour queries, you will be able to find out which databases are being used the most as well as consider actions to enhance their work.