Databases Manager

Taking control of your databases is much simpler than in the past, as a result of Online Control Panel user interface for MySQL and PgSQL management! Even though you may not have detailed knowledge in working with databases, it will be an easy task to deal with Derp Dot Hosting’s Databases Manager.

You can create a new database by just typing the username and password or create a database back–up with only a click of the mouse. Moreover, from the Data Manager you’ll have direct access to the management area for every database, so its possible to conveniently manage it.

We’ve transformed the manual database backup formation into a simple activity. To do this: in the Databases Manager, click the ’clock’ icon beside the database that you intend to back up and wait for a couple of seconds for the process to take place. Depending upon the size of your database, the creation of a back–up file is going to take somewhere between a few seconds and a minute.

You can create as many copies of a database as you would like. We have not determined any confines about the quantity of databases that you could back up either.

PgSQL databases are much less common compared to the well–known MySQL databases. On the other hand, they’re a preferred option for designers seeking the utmost security for their web sites and applications. Via the incredibly user–friendly Databases Manager included in the Derp Dot Hosting Control Panel, you can administer your PostgreSQL databases with only a mouse click.

You’ll find PgSQL databases incorporated automatically inside of the top Linux cloud packages packages. Assuming that you are with a standard hosting package, it is possible to ask for PgSQL databases to be added in your account as upgrades.

The MySQL databases on Derp Dot Hosting’s servers use the newest release of the InnoDB storage engine. InnoDB is built to guarantee the maximum efficiency for websites that process substantial amounts of data. It grants CPU efficiency that can not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, which means you are able to update/insert/create/alter/drop several times for a single "operation" of your web application. Additionally, it works by using row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

We offer you an easy way for you to monitor the database utilization on your active sites. Through the detailed database statistics interface, which is built–into the Online Control Panel, it is easy to record the load accumulated by your active websites in real time. The supplied details will help you evaluate the database load fluctuations by the hour, each day or on a monthly basis.

You’re able to observe the database load for all of your sites within the Database Stats area of the Online Control Panel. The table onscreen shows the database queries generated within the present month. To have a look at details for an earlier month, all you have to do is click on the back arrows located at the top.