Databases Manager

Supervising your databases is much simpler than before, as a result of Control Panel user interface for MySQL and PgSQL administration! Even if you do not have substantial expertise in dealing with databases, it will be very easy to deal with the Databases Manager.

You could make a brand new database by merely specifying the user name and password or generate a database backup with simply a mouse click. At the same time, from the Data Manager you will get direct access to the administration area for each and every database, so that you can immediately update it.

In case you have dealt with databases, you know creating a manual database back–up is not really an elementary task. As a way to change this, we’ve created very simple tool that will back up your whole database with simply one click of the mouse. The backup file will be all set for you in under a minute, depending on the size of the chosen database.

There are not any limits on the number of back–ups you could make for a particular database.

PgSQL databases are much less sought after when compared to the prevalent MySQL databases. Having said that, they are a favorite option for designers seeking the maximum safety for their web sites and web apps. Because of the easy–to–use Databases Manager integrated into the Asheville Micro Services Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.

You’re going to find PgSQL databases included automatically inside of the top website hosting plans packages. In case you are using a basic hosting package, you’ll be able to ask for PgSQL databases to be added to your account as upgrades.

With Asheville Micro Services, you’ll invariably find the latest variant of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more stable than the past storage engine’s edition – MyISAM. It’s ACID–compliant and, most significantly – it offers full transaction support. You’ll find, it takes advantage of row–level locking, as an alternative to MyISAM’s table–level locking, that would always trigger functionality issues at high usage times.

From the thorough database stats tool integrated into the Control Panel, you are able to make a record of the load generated from your busy websites 24 / 7. Every overload difficulty with your websites could reduce the loading rates and have a damaging impact on the overall impression of your respective visitors. Thus, having information for the database load instantly, it will be easy to fix overload problems at once.

The database statistics user interface displays info of the number of daily, hourly and monthly queries, which enables you to assess just how the load is distributed over different periods of time.