Database Manager

Managing your databases is much simpler than ever, thanks to the Online Control Panel user interface for MySQL and PgSQL control! Assuming you do not have substantial experience in managing databases, you will find it simple to manage our Database Manager.

You could make a whole new database just by entering the user name and password or generate a database backup with simply a mouse click. Also, through the Data Manager you’ll possess direct access to the administrator area for each and every database, which means you can quite simply update it.

In case you have dealt with databases, you know generating a manual database back–up just isn’t a basic task. As a way to change this, we’ve made very simple tool that will back up your whole database with only a single click. The back–up file is going to be completely ready for you in under a minute, based on the size of the selected database.

There are no restrictions on the actual number of back–ups you may make for a chosen database.

PgSQL databases are much less sought after in comparison to the prevalent MySQL databases. Having said that, they are a preferred selection for designers who are looking for the greatest safety for their websites and web apps. Due to the easy–to–use Database Manager built–into the Golden Shield Web Hosting Control Panel, you can control your PostgreSQL databases with merely a mouse click.

You’ll find PgSQL databases included automatically within the advanced Linux website hosting packages packages. If you are using a basic hosting package, you can request PgSQL databases to be included in your account as upgrades.

The MySQL databases on Golden Shield Web Hosting’s machines use the most current version of the InnoDB storage engine. InnoDB is made to ensure the maximum performance for web sites that deal with big volumes of data. It grants CPU efficiency that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that you are able to update/insert/create/alter/drop more than once for one "operation" of your web application. At the same time, it utilizes row–level locking as an alternative to MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Monitoring the load produced by the databases for your dynamic website will let you reduce all overload issues that could slow it down and ward off visitors. For this specific purpose, we’ve built–in a detailed Database Stats tool within the Online Control Panel. There you can get complete information regarding the arriving requests to your databases for every hour, day and month.

Using the volume of daily and by the hour queries, you are going to be able to find out which databases are employed the most and consider procedures to optimize their work.