Database Manager

The Database Manager in our Website Control Panel has an effective nevertheless well designed user interface. It is possible to set up a completely new MySQL or PostgreSQL database simply by entering a username and security password. Moreover, you may create a backup file or alter the security password of a database with simply a click of the mouse.

Through the Database Manager you will possess direct access to the administrator area for all of your databases, so that you can make uncomplicated modifications should you need to.

Within the Database Manager you can easily create an archived backup of your database anytime you would like! Therefore, you’ll always have a data backup of your operating content material in case your website gets hacked or if you accidentally eliminate a database. To make a back–up: click on the ’clock’ image next to a given database and after that just wait for a couple of seconds for the process to be executed.

There won’t be any limits about the number of databases you are able to back up or the quantity of back–ups you can create for any database.

PgSQL databases are less widespread compared to the popular MySQL databases. On the other hand, they represent a favored alternative for web developers seeking the best safety for their web sites and applications. Because of the incredibly user–friendly Database Manager integrated into the Spdy VPS Control Panel, you can control all your PostgreSQL databases with a simple click of the mouse.

Yow will discover PgSQL databases incorporated automatically within the top cloud website hosting packages. Assuming that you are using a standard hosting package, you can easily request PgSQL databases to be included in your cloud hosting account as upgrades.

The MySQL databases on our machines use the newest version of the InnoDB storage engine. InnoDB is meant to guarantee the optimum performance for websites that operate with sizeable amounts of data. It delivers CPU efficiency that could not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, so that you are able to update/insert/create/alter/drop a couple of times for a single "operation" of your application. Furthermore, it works by using row–level locking instead of MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Spdy VPS offers you an easy way for you to keep track of the database usage for your active websites. From the in–depth database stats interface, that is included in the Website Control Panel, you’re able to track the load created from your busy sites in real time. The displayed information will help you evaluate the database load fluctuations on an hourly basis, every day or monthly.

You can easily observe the database load for your web sites through the Database Stats area of the Website Control Panel. The table onscreen reveals the database lookups generated within the present month. To examine info for a past month, just click on the back arrows positioned at the top.