We provide you with a user–friendly Databases Manager, incorporated in the Control Panel, from where you could make completely new MySQL and PgSQL databases straight away. Also, you’re allowed to administer each of their adjustments with the immediate access presented to the phpMyAdmin and phpPgAdmin software tools.
A Simple to use Interface
Deal with your databases with merely a click
Managing your databases is much simpler than ever, thanks to the Control Panel user interface for MySQL and PgSQL administration! Even if you do not have substantial experience in utilizing databases, it will be effortless to use our Databases Manager.
You can create a new database just by keying in the username and password or create a database back–up with only a mouse click. Furthermore, within the Data Manager you will have direct access to the administration area for every single database, so its possible to almost instantly revise it.
Simple Database Back up
Back up your databases in just a minute
We’ve made the manual database back–up generation into a quite easy activity. To do this: in the Databases Manager, click on the ’clock’ symbol next to the database that you would like to back up and hang on for a couple of seconds for the backup process to take place. With regards to the size of your database, the creation of the backup file will take between a few seconds and a minute.
You can make as many backup copies per database as you want. We haven’t specified any limitations for the amount of databases that you could back up as well.
Support for PgSQL
Warranted reliability for your personal databases
PgSQL databases are much less common as opposed to the popular MySQL databases. Nevertheless, they represent a favorite alternative for designers who seek the ultimate stability for their websites and web applications. Due to the intuitive Databases Manager built into the Space City Net Solutions Control Panel, you can manage your PostgreSQL databases with just a click of the mouse.
You can find PgSQL databases incorporated by default with the advanced cloud hosting plans packages. Assuming that you are using a basic hosting package, you are able to request PgSQL databases to be included in your hosting account as upgrades.
The fresh new face of MySQL
We have integrated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is made for significant database sites that demand high general performance and scalability. Experiments have revealed that websites employing InnoDB based tables attain a 3–fold general performance grow for very big joins, as opposed to those utilizing MyISAM tables.
InnoDB takes advantage of row–level locking in order to clear away the general performance issues discovered at the high usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Complete statistics for all your databases
Keeping track of the load caused by the databases within your dynamic site assists you to prevent any kind of overload issues that could slow it down and chase away site visitors. For that reason, we have built–in a thorough Database Stats tool straight into the Control Panel. There you can get detailed info about the incoming requests to your databases for every hour, day and month.
Depending on the quantity of daily and per hour queries, you are going to be able to find out which databases are being used the most and then consider measures to optimize their load.