From within the Databases Manager incorporated into the Online Control Panel, it’s possible to make brand new MySQL and PgSQL databases right away! Moreover, you will have direct access to the management area software tools (phpMyAdmin and phpPgAdmin, respectively), which means you can easily update the database you want.
A Convenient–to–use User interface
Control your databases with a click
Overseeing your databases is easier than ever, thanks to the Online Control Panel interface for MySQL and PgSQL control! Even though you may not have extensive experience in making use of databases, you will find it simple to use the Databases Manager.
You can create a brand new database by just specifying the username and password or create a database back–up with only a click of the mouse. Likewise, with the Data Manager you will have direct access to the administrator area for each individual database, to help you to conveniently revise it.
Simple and quick Database Back–up
Database backups are just a mouse click away
Via the Databases Manager you can make an archived copy of your database when you would like! For this reason, you are going to always have a back–up of your operating information in the event your site gets compromised or if you incorrectly delete a database. To produce a backup: click on the ’clock’ symbol next to a particular database and after that just wait for a couple of seconds for the backup process to be finalized.
There won’t be any restrictions for the amount of databases you can back up or the amount of back–ups you may make for any database.
PgSQL Databases Support
Simply the most risk–free open source databases
You’ll find PgSQL support in all our website hosting bundles. PgSQL databases aren’t as famous and widely used as MySQL, but they supply the top level of security for your web site content and articles. Therefore, many famous companies like Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as simple and easy as MySQL, thanks to the intuitive interface of the Databases Manager.
PgSQL databases are integrated by default inside of the most innovative web hosting packages. For the regular plans, they’re presented as upgrades.
The fresh face of MySQL
The MySQL databases on Tree House Web Hosting and Domain name registration’s web servers use the most recent build of the InnoDB storage engine. InnoDB has been designed to guarantee the highest possible efficiency for websites that deal with sizeable amounts of data. It supplies CPU efficiency that could not be equalled by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and provides full transaction support, meaning that you can update/insert/create/alter/drop a couple of times for one "operation" of your web application. Additionally, it works by using row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.
Detailed Database Stats
Precise stats for all of your databases
Checking the load accumulated by the databases on your active web site makes it possible to reduce all kinds of overload issues that could slow it down and chase away website visitors. For this reason, we’ve provided a in depth Database Stats tool straight into the Online Control Panel. There you can see extensive info about the arriving requests to your databases for every single hour, day and month.
Using the quantity of day–to–day and hourly queries, it will be straightforward to find out what databases are employed the most and also take steps to optimize their work.