Databases Manager

Managing your databases is simpler than in the past, because of the Web Control Panel interface for MySQL and PgSQL administration! Even if you do not have thorough experience of making use of databases, it will be an easy task to handle the Databases Manager.

You could make a whole new database simply by keying in the user name and password or create a database backup with only a click of the mouse. At the same time, through the Data Manager you will possess direct access to the management area for each and every database, which means you can quite simply revise it.

Via the Databases Manager it’s easy to make an archived copy of your database anytime you need! Thus, you’ll always have a data backup of your dynamic information in the event your site gets hacked or you accidentally erase a database. To make a back–up: click the ’clock’ image next to a certain database and after that just wait for a few seconds for the backup process to be executed.

There are not any restricts for the volume of databases you can back up or the amount of backups you may make for any database.

Nearly all of our Linux cloud web hosting packages packages feature PgSQL support. Whilst falling behind MySQL with respect to reputation and usage, PgSQL databases are famous for providing the top level of stability for your site content and articles. It is the reason why businesses like Skype and Yahoo employ PgSQL databases instead of MySQL.

In terms of database administration, PgSQL is as straightforward as MySQL.

With JOMIZU SAC, you’ll invariably find the most up–to–date variant of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more stable as compared to the former storage engine’s version – MyISAM. It is ACID–compliant and, most importantly – it has full transaction support. You’ll find, it uses row–level locking, in lieu of MyISAM’s table–level locking, that seemed to lead to effectiveness problems at peak usage occasions.

Keeping tabs on the load accumulated by the databases on your dynamic site makes it possible to stop all kinds of overload troubles that could slow it down and chase away website visitors. For that reason, we’ve integrated a in–depth Database Stats tool into the Web Control Panel. There you can find extensive information on the incoming requests to your databases for each hour, day and month.

Using the number of day–to–day and by the hour queries, it is possible to determine which databases are used the most and take steps to optimize their work.