Databases Manager

Overseeing your databases is much easier than in the past, due to the Web Control Panel interface for MySQL and PgSQL control! Provided you do not have thorough experience in making use of databases, it will be very easy to work with Pasifika Technology’s Databases Manager.

You may create a completely new database merely by typing the user name and password or produce a database backup with a mouse click. Likewise, through the Data Manager you’ll get direct access to the administrator area for each and every database, allowing you to quickly revise it.

If you have worked with databases, you know making a manual database backup is not really a simple task. So as to change this, we’ve developed a simple tool that will back up your entire database with only one click. The data backup file will be available for you in less than a minute, with respect to the size of the selected database.

There are no limitations on the amount of back–ups you can create for a chosen database.

Just about all of the cloud web hosting bundles feature PgSQL support. While dropping behind MySQL with regards to popularity and employment, PgSQL databases are famous for presenting the maximum level of safety for your site content. This is the reason why brands like Skype and Yahoo make use of PgSQL databases in lieu of MySQL.

With respect to database administration, PgSQL is just as straightforward as MySQL.

The MySQL databases on Pasifika Technology’s machines work with the most recent release of the InnoDB storage engine. InnoDB was meant to guarantee the top efficiency for websites that process sizeable volumes of data. It boasts CPU performance that could not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning that you can easily update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Additionally, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Checking the load generated by the databases for your busy web site makes it possible to stop all overload issues that can slow it down and chase away site visitors. As a result, we’ve bundled a detailed Database Stats tool within the Web Control Panel. There you can see in depth info on the inbound requests to your databases for every single hour, day and month.

Using the amount of daily and by the hour queries, it is possible to find out what databases are utilized the most and also take steps to optimize their work.