Databases Manager

Taking control of your databases is easier than in the past, due to the Site Control Panel interface for MySQL and PgSQL management! In case you do not have in depth experience of managing databases, it will be very easy to work with the Databases Manager.

You may create a whole new database simply by keying in the username and password or make a database back–up with merely a mouse click. Likewise, from the Data Manager you’ll have direct access to the admin area for each and every database, so that you can instantly edit it.

We have made the manual database backup formation into a very simple job. To execute this: inside of the Databases Manager, click on the ’clock’ icon beside the database that you would like to back up and afterwards hang on for a few seconds for the process to take place. Depending on the size of the database, the generation of a backup file will take somewhere between a couple of seconds and a minute.

You may create as many backup copies of a database as you wish. We’ve not set any confines about the quantity of databases you can back up too.

PgSQL databases are significantly less popular when compared to the common MySQL databases. Nonetheless, they are a preferred choice for designers seeking the greatest protection for their sites and web applications. Thanks to the intuitive Databases Manager built–into the FinlandVPS Control Panel, you can manage all your PostgreSQL databases with just a mouse click.

You’re going to find PgSQL databases provided by default in the advanced Linux shared website hosting packages. In case you are using a basic hosting package, you’re able to request PgSQL databases to be added to your cloud hosting account as upgrades.

With FinlandVPS, you will inevitably find the most current build of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is far more stable when compared to the past storage engine’s version – MyISAM. It is ACID–compliant and, even more importantly – it has complete transaction support. It also works by using row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to trigger efficiency problems at peak usage occasions.

Checking the load accumulated by the databases on your busy web site assists you to prevent virtually any overload difficulties that can slow it down and ward off site visitors. For this specific purpose, we have built in a complete Database Stats tool directly into the Site Control Panel. There you will find comprehensive information about the inbound requests to your databases for each and every hour, day and month.

Based on the number of day–to–day and hourly queries, you are going to be able to determine which databases are used the most and take measures to optimize their load.