Databases Manager

Taking control of your databases is simpler than ever, because of the Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have substantial expertise in working with databases, you will find it effortless to work with the Databases Manager.

You can make a completely new database just by keying in the user name and security password or produce a database back–up with just a click of the mouse. Additionally, with the Data Manager you will possess direct access to the administrator area for every single database, so you’re able to conveniently revise it.

We’ve designed the manual database backup generation into a quite easy task. To do this: inside the Databases Manager, click on the ’clock’ icon on the side of the database that you want to back up and then wait for a few seconds for the backup process to take place. With respect to the size of your database, the building of any back–up file can take somewhere between a couple of seconds and a minute.

You may make as many copies per database as you desire. We’ve not set any limits for the amount of databases you can back up as well.

PgSQL databases are much less sought after than the common MySQL databases. Nonetheless, they are a favored option for programmers who seek the ultimate safety for their web sites and apps. Thanks to the incredibly user–friendly Databases Manager integrated into the Philosopher hosting Control Panel, you can manage all of your PostgreSQL databases with only a mouse click.

You can discover PgSQL databases incorporated automatically inside of the top hosting packages. In case you are with a standard hosting package, it is easy to ask for PgSQL databases to be included in your hosting account as upgrades.

With Philosopher hosting, you’ll consistently find the newest variant of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is more dependable as compared to the earlier storage engine’s version – MyISAM. It is ACID–compliant and, above all – it gives you total transaction support. What’s more, it takes advantage of row–level locking, in lieu of MyISAM’s table–level locking, that used to cause functionality issues at high usage periods.

Tracking the load generated by the databases on your dynamic website makes it possible to avoid all sorts of overload issues that can slow it down and chase away website visitors. As a result, we’ve designed a detailed Database Stats tool in the Control Panel. There you can get thorough information about the incoming requests to your databases for each and every hour, day and month.

Using the volume of daily and hourly queries, you’re going to be able to determine which databases are used the most and also consider actions to optimize their load.