Inside the hostshot Site Control Panel you can find a feature–rich, user–friendly Database Manager! Employ it in order to enjoy complete control over your databases. It is easy to very easily create new MySQL and PgSQL databases and control them through the phpMyAdmin and phpPgAdmin software tools, respectively.
Neat and User–friendly User interface
Control all your databases from one place
The Database Manager inside the Site Control Panel provides a refined but straightforward user interface. You can configure a brand new MySQL or PostgreSQL database by simply entering a username and password. Additionally, you can create a backup file or alter the security password of any database with just a mouse click.
Through the Database Manager you have immediate access to the administration area for each of your databases, allowing you to make hassle–free corrections if you ever have to.
Speedy Database Back–up
Back up your databases in a minute
We have made the manual database back–up creation into a very simple job. To execute that: inside of the Database Manager, click on the ’clock’ icon next to the database that you intend to back up and afterwards wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of a back–up file will need somewhere between a few seconds and a minute.
You may make as many backup copies of a database as you wish. We have not determined any restrictions about the number of databases you could back up too.
PgSQL Support
Just about the most risk–free open source databases
Practically all of our cloud hosting bundles feature PgSQL support. Although falling behind MySQL with regard to acceptance and usage, PgSQL databases are famous for giving the greatest level of protection for your site content material. It is the main reason why businesses like Skype and Yahoo rely on PgSQL databases as opposed to MySQL.
With regard to database management, PgSQL is as hassle–free as MySQL.
InnoDB Databases
The fresh new face of MySQL
The MySQL databases on our machines use the most up–to–date version of the InnoDB storage engine. InnoDB has been developed to guarantee the highest functionality for web sites that process big amounts of data. It delivers CPU efficiency that can not be matched by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and gives complete transaction support, which means you can easily update/insert/create/alter/drop more than once for one "operation" of your app. Also, it employs row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and performance.
Detailed Database Stats
Complete statistics for all of your databases
Checking the load made by the databases on your powerful web site will let you prevent virtually any overload troubles that can slow it down and ward off visitors. For this reason, we have built–in a complete Database Stats tool inside the Site Control Panel. There you can find thorough info on the inbound requests to your databases for each hour, day and month.
Depending on the amount of day–to–day and hourly queries, you will be able to find out which databases are being used the most and then consider measures to optimize their work.
