We grant you an easy to navigate Database Manager, incorporated in the Web Site Control Panel, from where you could generate new MySQL and PgSQL databases in an instant. What is more, you’re able to administer all their settings with the quick access offered to the phpMyAdmin and phpPgAdmin software instruments.
An Easy to use User interface
Maintain your databases with merely a mouse click
Supervising your databases is much simpler than in the past, thanks to the Web Site Control Panel user interface for MySQL and PgSQL management! Even though you may not have detailed experience in managing databases, it will be very easy to work with the Database Manager.
You can create a whole new database by merely keying in the username and security password or generate a database back–up with a simple click of the mouse. Moreover, through the Data Manager you have direct access to the admin area for every database, so you can quite easily alter it.
Easy Database Backup
Back up your databases in just a minute
We have evolved the manual database back–up creation into a very simple task. To do so: within the Database Manager, click on the ’clock’ image beside the database that you want to back up and then hang on for a few seconds for the process to take place. Depending on the size of the database, the building of the back–up file can take 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 about the quantity of databases you can back up as well.
The most stable open source databases
Most of our Linux cloud web hosting bundles offer PgSQL support. Although dropping behind MySQL in terms of popularity and utilization, PgSQL databases are famous for providing the highest level of protection for your web site content. That is the key reason why companies like Skype and Yahoo go with PgSQL databases in lieu of MySQL.
In terms of database management, PgSQL is as uncomplicated as MySQL.
The fresh new face of MySQL
The MySQL databases on Upstate Web Pros’s machines utilize the most recent version of the InnoDB storage engine. InnoDB is meant to guarantee the highest efficiency for sites that operate with large amounts of data. It supplies CPU efficiency that could not be matched by any other different disk–based relational database engines.
InnoDB is ACID–compliant and gives complete transaction support, meaning that you can update/insert/create/alter/drop several times for a single "operation" of your app. At the same time, it uses row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.
Detailed Database Stats
Comprehensive statistics for all of your databases
Checking the load generated by the databases within your busy website will let you avoid any overload issues that might slow it down and ward off website visitors. For this specific purpose, we’ve built in a descriptive Database Stats tool straight into the Web Site Control Panel. There you will find complete information about the inbound requests to your databases for every single hour, day and month.
Based on the number of day–to–day and hourly queries, it will be easier to find out what databases are being used the most and consider procedures to enhance their work.