Database Manager

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.

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.

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.

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.

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.