Database Manager

The Database Manager within our Web Site Control Panel provides a powerful but still straightforward interface. You can configure a whole new MySQL or PostgreSQL database by simply typing in a user name and security password. In addition, you could make a backup file or alter the password of an database with merely a click of the mouse.

From the Database Manager you will possess direct access to the management area for every one of your databases, which means you can make convenient corrections if you ever need to.

Within the Database Manager it’s easy to make an archived duplicate of your database whenever you need! That way, you’ll always have a backup of your operating information in case your web site gets hacked or you mistakenly eliminate a database. To produce a back–up: click the ’clock’ symbol on the side of any database and after that simply wait for a few seconds for the backup process to be performed.

There are not any confines on the amount of databases you would be able to back up or the number of back–ups you can create for any database.

PgSQL databases are significantly less popular when compared to the popular MySQL databases. Having said that, they’re a favored option for programmers seeking the finest safety for their sites and applications. Through the easy–to–use Database Manager built–into the SGK Hosting Control Panel, you can manage all your PostgreSQL databases with just a click of the mouse.

Yow will discover PgSQL databases incorporated by default inside the best Linux hosting packages. Provided that you are using a regular hosting package, it is easy to ask for PgSQL databases to be included in your website hosting account as upgrades.

We have integrated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is perfect for significant database web sites which require high effectiveness and scalability. Tests have demonstrated that web sites applying InnoDB based tables reach a 3–fold general performance increase for very big joins, in comparison to those using MyISAM tables.

InnoDB takes advantage of row–level locking as a way to eliminate the operation problems found at the peak consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

We provide you a quick method to monitor the database use for your powerful websites. Through the in–depth database statistics user interface, that is built into the Web Site Control Panel, it’s possible to keep track of the load generated by your busy websites in real time. The delivered info will enable you to evaluate the database load changes per hour, per day or each month.

You are able to track the database load for all your websites in the Database Stats area of the Web Site Control Panel. The table onscreen presents the database queries made within the present month. To examine data for a previous month, click on the back arrows placed at the top.