From within the Databases Manager included in the Hosting Control Panel, it will be easier to make new MySQL and PgSQL databases instantly! In addition, you will possess immediate access to the management area software programs (phpMyAdmin and phpPgAdmin, respectively), allowing you to easily update the database you want.
A Convenient–to–use Interface
Be in charge of your databases with simply a click of the mouse
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.
Quick and Simple Database Backup
Database backup copies are a mouse click away
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.
By far the most secure open source databases
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.
The newest face of 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.
Detailed Database Stats
In depth statistics for all your databases
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.