Databases Manager

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.

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.

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 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.

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.