Databases Manager

Overseeing your databases is much easier than in the past, as a result of Hosting Control Panel interface for MySQL and PgSQL administration! Provided you do not have substantial expertise in handling databases, it will be an easy task to deal with the Databases Manager.

You can create a whole new database merely by keying in the username and password or generate a database back–up with a mouse click. Likewise, with the Data Manager you’ll have direct access to the administrator area for each individual database, to help you to instantly alter it.

Within the Databases Manager you’ll be able to make an archived duplicate of your database when you want! Thus, you are going to always have a data backup of your active content material in the event your website gets compromised or you incorrectly erase a database. To produce a back–up: click the ’clock’ symbol on the side of a certain database and afterwards simply wait for a couple of seconds for the backup process to be done.

There aren’t any limits about the quantity of databases you would be able to back up or the amount of backup copies you can create for a database.

Almost all of Click2Connect’s Linux cloud hosting packages plans present PgSQL support. While dropping behind MySQL with regards to acceptance and employment, PgSQL databases are famous for supplying the greatest level of security for your web site content and articles. This is the reason why companies like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

When considering database management, PgSQL is equally quick as MySQL.

We have set up InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is good for significant database web sites that demand high levels of effectiveness and scalability. Experiments have demonstrated that web sites making use of InnoDB based tables reach a 3–fold effectiveness boost for very big joins, compared with those applying MyISAM tables.

InnoDB works by using row–level locking in order to be able to eliminate general performance problems seen at the maximum consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Through the all–encompassing database statistics tool incorporated into the Hosting Control Panel, you are able to keep a record of the load generated by your dynamic websites around the clock. Virtually any overload difficulty with your websites could slow the loading rates and have a damaging impact on the overall impression of your visitors. Which means that, having data about the database load in real time, it will be easier to fix overload difficulties straight away.

The database stats interface displays information of the quantity of daily, hourly and monthly lookups, allowing you to examine how the load is distributed over various periods of time.