Databases Manager

Taking control of your databases is easier than in the past, on account of the Site Control Panel user interface for MySQL and PgSQL control! Assuming you do not have in depth experience in managing databases, it will be effortless to use our Databases Manager.

You can make a new database by only keying in the user name and password or generate a database backup with only a mouse click. At the same time, with the Data Manager you’ll have direct access to the administrator area for each individual database, meaning you can effectively alter it.

If you have dealt with databases, you know making a manual database back–up is not an elementary job. As a way to change this, we have created a simple tool that will back up your entire database with just a single mouse click. The back–up file shall be prepared for you in less than a minute, depending upon the size of the chosen database.

You won’t notice any limitations on the total number of back–ups you could make for a specific database.

PgSQL databases are much less common when compared to the prevalent MySQL databases. Nonetheless, they represent a favorite alternative for developers who are looking for the finest stability for their sites and apps. Because of the incredibly user–friendly Databases Manager integrated into the New Vision Hosting Control Panel, you can manage all your PostgreSQL databases with only a click of the mouse.

You can discover PgSQL databases bundled by default inside of the advanced Linux cloud hosting packages. If you are with a standard hosting package, it is easy to request PgSQL databases to be added to your hosting account as upgrades.

The MySQL databases on our servers employ the most up–to–date release of the InnoDB storage engine. InnoDB has been built to ensure the max effectiveness for websites that operate with big volumes of data. It offers CPU efficiency that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means it is easy to update/insert/create/alter/drop repeatedly for a single "operation" of your web app. Moreover, it employs row–level locking in contrast to MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Checking the load accumulated by the databases in your dynamic web site will let you avoid any kind of overload issues that might slow it down and chase away site visitors. For this reason, we’ve built in a descriptive Database Stats tool inside the Site Control Panel. There you can see detailed info about the inbound requests to your databases for each hour, day and month.

In line with the amount of daily and per hour queries, it is possible to find out which databases are utilized the most and also consider actions to optimize their work.