We give you a simple to operate Database Manager, included inside our Control Panel, from where you could generate new MySQL and PgSQL databases instantly. Additionally, you’re able to manage each of their settings with the easy access offered to the phpMyAdmin and phpPgAdmin software tools.
An Easy to navigate User interface
Handle your databases with only a click of the mouse
Supervising your databases is simpler than before, due to the Control Panel user interface for MySQL and PgSQL administration! Provided you do not have thorough expertise in working with databases, it will be an easy task to work with the Database Manager.
You can make a brand new database by merely keying in the username and security password or create a database backup with only a click of the mouse. In addition, with the Data Manager you will have direct access to the administrative area for each and every database, meaning you can efficiently alter it.
Easy Database Backup
Back up your databases in just a moment
We’ve transformed the manual database backup creation into a quite simple job. To execute that: inside of the Database Manager, click on the ’clock’ icon on the side of the database that you would like to back up and after that hang on for a few seconds for the backup process to take place. With respect to the size of the database, the creation of a back–up file can take between a couple of seconds and a minute.
You may create as many backups per database as you would like. We’ve not specified any boundaries about the volume of databases that you could back up as well.
Support for PgSQL
Guaranteed protection for your personal databases
PgSQL databases are much less common when compared to the standard MySQL databases. On the other hand, they represent a favored option for web developers who seek the maximum security for their websites and apps. Through the intuitive Database Manager incorporated into the Saint Hosting Control Panel, you can manage all of your PostgreSQL databases with only a click of the mouse.
You can discover PgSQL databases provided by default with the top Linux hosting packages. If you are with a regular hosting package, you’ll be able to request PgSQL databases to be added in your website hosting account as upgrades.
The newest face of MySQL
The MySQL databases on Saint Hosting’s servers employ the most recent build of the InnoDB storage engine. InnoDB has been made to guarantee the maximum efficiency for web sites that deal with big amounts of data. It presents CPU efficiency that can not be matched up by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and grants complete transaction support, meaning that you are able to update/insert/create/alter/drop many times for a single "operation" of your application. Additionally, it takes advantage of row–level locking and not MyISAM’s table–level locking, that raises multi–user concurrency and performance.
Detailed Database Stats
Detailed stats for all of your databases
Checking the load caused by the databases in your powerful website assists you to stop any sort of overload problems that could slow it down and ward off visitors. For this purpose, we’ve built–in a in depth Database Stats tool inside the Control Panel. There you can get thorough information about the arriving requests to your databases for every single hour, day and month.
In line with the volume of day–to–day and per hour queries, it will be straightforward to determine which databases are utilized the most and also consider steps to enhance their work.