Through the Databases Manager included in the Web Site Control Panel, it is possible to create new MySQL and PgSQL databases in an instant! At the same time, you’ll have direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), which enables you to quite easily manage the database you want.
Tidy and Straightforward Interface
Maintain all of your databases from within one place
The Databases Manager in the Web Site Control Panel has a powerful but convenient to use interface. You are able to set up a whole new MySQL or PostgreSQL database by just typing a user name and password. Furthermore, you can create a backup file or modify the password of any database with just a mouse click.
Via the Databases Manager you’ve got immediate access to the management area for every one of your databases, so that you can make effortless adjustments when you have to.
Quick and Simple Database Back–up
Database backup copies are just a click away
Via the Databases Manager you’ll be able to generate an archived duplicate of your database whenever you want! That way, you will always have a data backup of your dynamic information if your web site gets broken into or if you erroneously erase a database. To make a backup: click the ’clock’ image next to any database and after that just wait for a couple of seconds for the backup process to be performed.
There are not any limits about the number of databases you can back up or the volume of back–ups you may make for any database.
Just about the most stable open source databases
Almost all of Wiz VPS’s cloud hosting plans packages present PgSQL support. Although dropping behind MySQL with respect to popularity and usage, PgSQL databases are renowned for giving the highest level of stability for your website content material. That is the key reason why companies like Skype and Yahoo make use of PgSQL databases in lieu of MySQL.
When it comes to database administration, PgSQL is equally uncomplicated as MySQL.
The newest face of MySQL
The MySQL databases on Wiz VPS’s web servers make use of the most up–to–date version of the InnoDB storage engine. InnoDB is designed to guarantee the maximum efficiency for sites that operate with big amounts of data. It offers CPU performance that could not be equalled by any other disk–based relational database engines.
InnoDB is ACID–compliant and gives full transaction support, meaning you are able to update/insert/create/alter/drop many times for one "operation" of your web application. Moreover, it takes advantage of row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.
Detailed Database Stats
Thorough stats for your databases
Tracking the load made by the databases on your busy site makes it possible to reduce virtually any overload problems that could slow it down and chase away site visitors. For this reason, we’ve bundled a thorough Database Stats tool into your Web Site Control Panel. There you can see comprehensive information on the inbound requests to your databases for each hour, day and month.
Using the amount of day–to–day and hourly queries, it’s possible to determine which databases are used the most and then take procedures to optimize their work.