From within the Database Manager integrated into the Website Control Panel, you’ll be able to set–up brand new MySQL and PgSQL databases right away! At the same time, you will possess direct access to the management area software programs (phpMyAdmin and phpPgAdmin, respectively), which enables you to conveniently modify the database you want.
A User–friendly User interface
Handle your databases with merely a mouse click
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.
Effortless Database Data backup
Secure your database content with a click
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.
The most protected open source databases
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 fresh new face of 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.
Detailed Database Stats
Comprehensive statistics for all your databases
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.