Database Manager

Administering your databases is much simpler than in the past, because of the Web Site Control Panel user interface for MySQL and PgSQL administration! Provided you do not have detailed experience of utilizing databases, it will be an easy task to use CCG WEB’s Database Manager.

You may create a brand new database just by typing the username and security password or generate a database back–up with a click of the mouse. At the same time, through the Data Manager you have direct access to the administrative area for each and every database, so its possible to quickly manage it.

We have transformed the manual database backup formation into a simple job. To do this: within the Database Manager, click on the ’clock’ symbol on the side of the database that you plan to back up and after that wait for a few seconds for the backup process to take place. With respect to the size of the database, the building of a back–up file will need between a couple of seconds and a minute.

You can create as many backups per database as you wish. We’ve not determined any boundaries on the quantity of databases you can back up as well.

PgSQL databases are less common when compared to the common MySQL databases. Having said that, they’re a favored alternative for web developers who seek the utmost stability for their sites and web apps. Due to the user–friendly Database Manager integrated into the CCG WEB Control Panel, you can administer your PostgreSQL databases with just a mouse click.

You can find PgSQL databases bundled automatically within the advanced Linux web hosting packages packages. If you are with a standard hosting package, it’s possible to request PgSQL databases to be added in your web hosting account as upgrades.

We have integrated InnoDB – the new standard MySQL database engine on all our servers. InnoDB is made for massive database websites that need high levels of performance and scalability. Tests show that sites utilizing InnoDB based tables attain a 3–fold general performance grow for massive joins, as opposed to those using MyISAM tables.

InnoDB uses row–level locking as a way to clear away the functionality difficulties seen at the maximum consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

Monitoring the load made by the databases within your active web site will let you reduce all kinds of overload troubles that could slow it down and ward off website visitors. Therefore, we have designed a comprehensive Database Stats tool into the Web Site Control Panel. There you will find all–inclusive info about the arriving requests to your databases for every single hour, day and month.

In line with the quantity of day–to–day and per hour queries, it will be easy to find out which databases are being used the most and take procedures to enhance their load.