We supply you with a convenient Database Manager, included with our Site Control Panel, from where you could generate brand–new MySQL and PgSQL databases in an instant. What’s more, you’re able to handle all their settings with the immediate access made available to the phpMyAdmin and phpPgAdmin software tools.
A User–friendly User interface
The best database administration interface
Database management might sound like a complicated job to newbie cloud hosting customers, but with PortGlasgow.Com’s Database Manager, it’s actually simple! To make a brand new database, you simply have to enter in the username and password. Database back–ups are only a click away too.People who desire to look into their databases as well as modify them should use the phpMyAdmin and phpPgAdmin tools.
Easy Database Backup
Guard your database content with only a mouse click
Provided you have worked with databases, you already know that generating a manual database back–up is not a simple task. So as to change this, we’ve created a simple tool that will back up your whole database with only a single click of the mouse. The back–up file shall be available for you in under a minute, with regards to the size of the selected database.
There are no limitations on exactly how many copies you can create for any selected database.
PgSQL Support
Just about the most stable open source databases
The majority of PortGlasgow.Com’s Linux website hosting packages deliver PgSQL support. Whilst dropping behind MySQL regarding acceptance and usage, PgSQL databases are famous for presenting the highest level of stability for your website content material. That’s the basic reason why brands like Skype and Yahoo use PgSQL databases and not MySQL.
With regards to database management, PgSQL is equally simple as MySQL.
InnoDB Databases
The fresh new face of MySQL
The MySQL databases on PortGlasgow.Com’s servers employ the most current build of the InnoDB storage engine. InnoDB has been created to guarantee the highest possible performance for web sites that deal with large amounts of data. It features CPU effectiveness that could not be equalled by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and supplies total transaction support, which means that you can easily update/insert/create/alter/drop repeatedly for one "operation" of your app. Furthermore, it makes use of row–level locking instead of MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.
Detailed Database Stats
Complete statistics for all your databases
Keeping tabs on the load caused by the databases in your busy web site makes it possible to stop all overload difficulties that could slow it down and chase away visitors. For this specific purpose, we have designed a comprehensive Database Stats tool inside the Site Control Panel. There you shall find comprehensive information on the inbound requests to your databases for every hour, day and month.
Using the quantity of day–to–day and per hour queries, it’s possible to find out what databases are being used the most and take measures to optimize their work.
