Database Manager

Administering your databases now is easier than in the past, due to the Website Control Panel interface for MySQL and PgSQL control! Even though you may not have extensive knowledge of making use of databases, you will find it very easy to deal with our Database Manager.

You can create a new database by only specifying the username and password or make a database backup with just a mouse click. In addition, through the Data Manager you will get direct access to the administrator area for every single database, so that you can quickly manage it.

If you have worked with databases, you know creating a manual database back–up is just not an elementary task. So as to change this, we’ve created a simple tool that can back up the entire database with only a single mouse click. The backup file is going to be prepared for you in less than a minute, with respect to the size of the chosen database.

There are no confines on exactly how many copies you can create for a particular database.

A majority of Plaza Hosting Services’s website hosting bundles grant PgSQL support. Whilst falling behind MySQL with regard to reputation and utilization, PgSQL databases are renowned for providing the best level of safety for your web site content and articles. This is the key reason why companies like Skype and Yahoo go with PgSQL databases rather than MySQL.

When considering database administration, PgSQL is identically simple as MySQL.

The MySQL databases on Plaza Hosting Services’s servers employ the newest build of the InnoDB storage engine. InnoDB was intended to ensure the maximum effectiveness for sites that deal with substantial amounts of data. It supplies CPU performance that could not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, meaning you are able to update/insert/create/alter/drop repeatedly for one "operation" of your application. In addition, it works by using row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Monitoring the load made by the databases for your active site will let you reduce any kind of overload issues that might slow it down and chase away visitors. For this specific purpose, we’ve provided a thorough Database Stats tool directly into the Website Control Panel. There you shall find in–depth information on the arriving requests to your databases for every hour, day and month.

Depending on the amount of daily and per hour queries, you’ll be able to find out what databases are being used the most as well as take measures to enhance their load.