Through the Database Manager built–into the Website Control Panel, it will be easy to set–up new MySQL and PgSQL databases straight away! Additionally, you will have direct access to the administration area software tools (phpMyAdmin and phpPgAdmin, respectively), which enables you to easily edit the database you want.
An Easy to use Interface
Maintain your databases with a click of the mouse
Overseeing your databases is much easier than in the past, due to the Website Control Panel interface for MySQL and PgSQL control! Assuming you do not have detailed experience of working with databases, it will be an easy task to deal with the Database Manager.
You can create a whole new database by just keying in the user name and security password or make a database back–up with simply a click of the mouse. Additionally, through the Data Manager you have direct access to the administration area for each and every database, which enables you to immediately modify it.
Very easy Database Data backup
Guard your database content with a click of the mouse
Assuming you have dealt with databases, you are aware that generating a manual database back–up isn’t an elementary task. In an effort to change this, we have developed very simple tool that can back up your entire database with just one mouse click. The back–up file will be completely ready for you in less than a minute, based on the size of the selected database.
There are no restrictions on just how many back–ups you could make for a specific database.
Support for PgSQL
Guaranteed reliability for your databases
PgSQL databases are less common compared to the widespread MySQL databases. Having said that, they represent a favored choice for programmers who seek the best safety for their web sites and web applications. Due to the intuitive Database Manager incorporated into the CityTopper Control Panel, you can administer your PostgreSQL databases with only a mouse click.
You can discover PgSQL databases incorporated by default inside of the top Linux cloud website hosting packages. If you are using a basic hosting package, you’ll be able to request PgSQL databases to be added in your cloud hosting account as upgrades.
The fresh face of MySQL
With CityTopper, you’ll invariably find the latest variant of MySQL plus the default MySQL storage engine – InnoDB, set up.
InnoDB is definitely more stable than the former storage engine’s edition – MyISAM. It is ACID–compliant and, most significantly – it gives you complete transaction support. What’s more, it makes use of row–level locking, as an alternative to MyISAM’s table–level locking, that previously used to result in performance problems at peak usage occasions.
Detailed Database Stats
Comprehensive statistics for all your databases
Checking the load caused by the databases for your dynamic website will help you prevent any overload difficulties that might slow it down and chase away website visitors. For this purpose, we have included a in–depth Database Stats tool in the Website Control Panel. There you can find all–inclusive information about the arriving requests to your databases for every single hour, day and month.
Depending on the number of daily and by the hour queries, it is possible to find out which databases are utilized the most and also take steps to optimize their load.