Database Manager

Administering your databases is much simpler than in the past, thanks to the Hosting Control Panel interface for MySQL and PgSQL management! Even though you may not have thorough experience in dealing with databases, it will be effortless to handle GrandGraphics’s Database Manager.

You could make a new database by simply entering the user name and security password or make a database backup with simply a click of the mouse. Furthermore, via the Data Manager you will have direct access to the administrator area for each individual database, allowing you to almost instantly modify it.

We have transformed the manual database back–up generation into a very simple activity. To execute that: within the Database Manager, click the ’clock’ image on the side of the database that you plan to back up and afterwards hang on for a couple of seconds for the process to take place. Depending upon the size of the database, the creation of any back–up file will take somewhere between a few seconds and a minute.

You may make as many copies of a database as you desire. We have not fixed any limits for the volume of databases you can back up either.

PgSQL databases are less common than the widespread MySQL databases. On the other hand, they are a favored choice for web developers who seek the finest stability for their sites and web applications. Due to the user–friendly Database Manager built–into the GrandGraphics Control Panel, you can administer all your PostgreSQL databases with a mouse click.

You can find PgSQL databases bundled by default inside of the advanced cloud web hosting packages. Assuming that you are using a regular hosting package, you are able to ask for PgSQL databases to be added to your website hosting account as upgrades.

The MySQL databases on our machines utilize the newest version of the InnoDB storage engine. InnoDB has been made to ensure the max functionality for sites that deal with substantial amounts of data. It provides CPU effectiveness that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, which means that you are able to update/insert/create/alter/drop more than once for a single "operation" of your web app. Moreover, it works by using row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Our company offers you a fairly easy way to keep track of the database utilization on your powerful websites. Through the detailed database statistics user interface, that’s integrated into the Hosting Control Panel, you’re able to keep an eye on the load created by your dynamic web sites in real time. The provided information will help you to analyze the database load changes per hour, on a daily basis or per month.

It is easy to track the database load for your web sites from the Database Stats section of the Hosting Control Panel. The table onscreen shows the database queries accumulated in the present month. To have a look at data for a past month, all you have to do is click on the back arrows located at the top.