Database Manager

Taking control of your databases is much easier than ever before, on account of the Hosting Control Panel interface for MySQL and PgSQL control! In case you do not have considerable knowledge of working with databases, you will find it effortless to deal with Vintage Recreations’s Database Manager.

You can create a whole new database by just specifying the user name and password or generate a database backup with a click of the mouse. In addition, within the Data Manager you will possess direct access to the administration area for each database, so you can efficiently alter it.

Provided you have dealt with databases, you already know that making a manual database backup is simply not an elementary task. In order to change this, we’ve developed a simple tool that can back up your complete database with a single mouse click. The data backup file shall be ready for you in under a minute, depending on the size of the chosen database.

There won’t be any limits on just how many backup copies you can create for a selected database.

PgSQL databases are less popular as opposed to the widespread MySQL databases. Then again, they are a favored option for programmers who are looking for the ultimate stability for their websites and applications. Via the incredibly user–friendly Database Manager integrated into the Vintage Recreations Control Panel, you can control all of your PostgreSQL databases with merely a mouse click.

You will find PgSQL databases included automatically inside the advanced shared web hosting packages packages. If you are using a standard hosting package, you can easily request PgSQL databases to be added to your website hosting account as upgrades.

With Vintage Recreations, you will inevitably discover the most recent version of MySQL as well as the default MySQL storage engine – InnoDB, installed.

InnoDB is far more stable in comparison to the former storage engine’s edition – MyISAM. It’s ACID–compliant and, best of all – it offers total transaction support. What’s more, it makes use of row–level locking, as an alternative to MyISAM’s table–level locking, that would always trigger performance troubles at high usage periods.

Checking the load produced by the databases for your dynamic website makes it possible to prevent virtually any overload difficulties that might slow it down and chase away visitors. For this reason, we have included a in depth Database Stats tool into your Hosting Control Panel. There you can see complete information about the inbound requests to your databases for every hour, day and month.

Based on the amount of day–to–day and per hour queries, it will be straightforward to determine which databases are being used the most and then take steps to enhance their work.