Database Manager

Database management may sound like a difficult task to newbie hosting clients, however with PegasusforHosting’s Database Manager, it’s in fact simple! To set up a new database, you simply need to key in your username and password. Database backups are simply a click away too.People that wish to examine their databases and then alter them can use the phpMyAdmin and phpPgAdmin tools.

With the Database Manager it is easy to create an archived duplicate of your database whenever you desire! Thus, you will always have a backup of your active content material if your site gets compromised or if you mistakenly delete a database. To create a back–up: click the ’clock’ icon beside a certain database and then wait for a few seconds for the process to be executed.

There aren’t any limits about the volume of databases you can back up or the volume of backup copies you may make for any database.

Most of the Linux shared hosting packages present PgSQL support. While falling behind MySQL with regards to popularity and usage, PgSQL databases are famous for supplying the best level of security for your site content. This is the primary reason why companies such as Skype and Yahoo rely upon PgSQL databases and not MySQL.

With regard to database administration, PgSQL is as straightforward as MySQL.

The MySQL databases on PegasusforHosting’s machines utilize the latest build of the InnoDB storage engine. InnoDB was created to ensure the optimum performance for websites that work with big amounts of data. It offers CPU efficiency that could not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, which means that you’re able to update/insert/create/alter/drop several times for one "operation" of your web app. Moreover, it employs row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Checking the load generated by the databases on your active website will let you reduce all sorts of overload troubles that might slow it down and chase away website visitors. For that reason, we’ve built–in a detailed Database Stats tool straight into the Web Control Panel. There you can get complete information regarding the arriving requests to your databases for every single hour, day and month.

Using the volume of day–to–day and by the hour queries, you’re going to be able to find out what databases are employed the most and also consider procedures to optimize their work.