Databases Manager

The Databases Manager within our Website Control Panel contains a refined but still intuitive user interface. You are able to configure a brand new MySQL or PostgreSQL database by simply specifying a user name and password. Moreover, you can make a backup file or change the security password of the database with simply a mouse click.

Within the Databases Manager you have immediate access to the administrator area for all of your databases, which enables you to make simple and easy adjustments in the event you have to.

If you have dealt with databases, you know making a manual database backup is not a basic job. As a way to change this, we have made an easy to understand tool that can back up the entire database with simply one mouse click. The back–up file will be completely ready for you in under a minute, depending on the size of the selected database.

There won’t be any limitations on the number of back–ups you can create for a selected database.

PgSQL databases are significantly less sought after in comparison to the prevalent MySQL databases. On the other hand, they represent a favorite option for designers who are looking for the finest stability for their web sites and web applications. Via the user–friendly Databases Manager included in the Double Zero Domain Shop - 00domain.com Control Panel, you can manage all your PostgreSQL databases with simply a mouse click.

You are going to find PgSQL databases included by default inside the top cloud hosting packages. In case you are with a standard hosting package, it is possible to request PgSQL databases to be added in your cloud hosting account as upgrades.

We have incorporated InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is made for substantial database sites that require high overall performance and scalability. Tests have established that web sites making use of InnoDB based tables attain a 3–fold overall performance boost for huge joins, as opposed to those using MyISAM tables.

InnoDB works by using row–level locking in an effort to eliminate general performance issues spotted at the peak consumption times of the prior release of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load generated by the databases within your busy web site makes it possible to prevent virtually any overload problems that could slow it down and ward off visitors. As a result, we’ve built in a complete Database Stats tool straight into the Website Control Panel. There you shall find broad info about the inbound requests to your databases for each and every hour, day and month.

Based on the amount of day–to–day and by the hour queries, it will be easy to find out what databases are employed the most and consider measures to enhance their work.