Database Manager

Administering your databases now is easier than before, due to the Web Site Control Panel user interface for MySQL and PgSQL control! Even if you do not have considerable knowledge of dealing with databases, it will be very easy to work with Yangon Host’s Database Manager.

You can make a new database by merely specifying the user name and password or generate a database backup with just a mouse click. Moreover, with the Data Manager you’ll get direct access to the administrative area for each and every database, meaning you can quite simply revise it.

We have evolved the manual database backup generation into a very easy activity. To execute that: in the Database Manager, click on the ’clock’ icon beside the database that you intend to back up and then wait around for a few seconds for the backup process to take place. With respect to the size of the database, the building of any back–up file can take between a couple of seconds and a minute.

You may create as many backup copies of a database as you wish. We have not fixed any restrictions for the number of databases you could back up as well.

Practically all of the website hosting services plans present PgSQL support. While dropping behind MySQL with respect to popularity and employment, PgSQL databases are renowned for delivering the top level of safety for your website content and articles. This is the basic reason why companies such as Skype and Yahoo rely on PgSQL databases instead of MySQL.

When it comes to database administration, PgSQL is as easy to understand as MySQL.

The MySQL databases on Yangon Host’s web servers utilize the latest version of the InnoDB storage engine. InnoDB is created to guarantee the max functionality for web sites that deal with sizeable amounts of data. It provides CPU performance that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, which means that you can easily update/insert/create/alter/drop many times for one "operation" of your web application. Also, it utilizes row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

We provide you a hassle–free way for you to keep track of the database utilization on your busy web sites. From your descriptive database statistics interface, that is incorporated into the Web Site Control Panel, it is easy to keep an eye on the load made by your dynamic sites in real time. The supplied info will allow you to analyze the database load variations per hour, on a daily basis or per month.

You can easily record the database load for all your web sites through the Database Stats area of the Web Site Control Panel. The table onscreen features the database queries created during the present month. To check information for a past month, simply click on the back arrows positioned at the top.