Database Manager

Supervising your databases is much simpler than in the past, because of the Web Control Panel user interface for MySQL and PgSQL administration! Provided you do not have considerable knowledge in managing databases, you will find it simple to use Yellowhosting.org’s Database Manager.

You may create a brand new database merely by entering the user name and password or produce a database back–up with only a mouse click. At the same time, with the Data Manager you’ll possess direct access to the admin area for every database, so you can effortlessly edit it.

We have developed the manual database backup formation into a quite simple job. To do so: within the Database Manager, click on the ’clock’ symbol next to the database that you intend to back up and wait around for a couple of seconds for the process to take place. Depending upon the size of the database, the generation of the back–up file can take somewhere between a couple of seconds and a minute.

You can create as many backup copies per database as you wish. We haven’t determined any restrictions on the quantity of databases you could back up either.

A majority of our cloud website hosting packages deliver PgSQL support. Whilst falling behind MySQL with respect to global recognition and employment, PgSQL databases are famous for offering the highest level of safety for your website content. That’s the primary reason why brands like Skype and Yahoo employ PgSQL databases and not MySQL.

With respect to database administration, PgSQL is equally quick as MySQL.

With Yellowhosting.org, you’ll invariably find the latest release of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more stable compared to the old storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it grants total transaction support. It also takes advantage of row–level locking, in contrast to MyISAM’s table–level locking, that seemed to result in effectiveness problems at peak usage times.

We offer you a pretty simple approach to keep tabs on the database utilization for your powerful web sites. From the in–depth database statistics user interface, that is built into the Web Control Panel, you can record the load made through your dynamic websites in real time. The presented data will help you evaluate the database load variations each hour, each day or per month.

You’ll be able to observe the database load for all of your websites within the Database Stats section of the Web Control Panel. The table onscreen presents the database queries accumulated in the present month. To assess details for a previous month, all you have to do is click on the back arrows placed at the top.