Database Manager

Taking control of your databases is much simpler than before, on account of the Control Panel user interface for MySQL and PgSQL administration! Even though you may not have extensive experience in making use of databases, you will find it effortless to manage our Database Manager.

You can create a completely new database by merely specifying the username and security password or create a database back–up with a simple click of the mouse. Moreover, through the Data Manager you’ll possess direct access to the administrator area for each database, so its possible to effectively modify it.

Within the Database Manager it is easy to generate an archived backup of your database whenever you want! This way, you’ll always have a data backup of your active content in the event your site gets hacked or if you mistakenly remove a database. To produce a back–up: click the ’clock’ image alongside a particular database and then wait for a couple of seconds for the backup process to be finished.

There aren’t any restricts about the quantity of databases you can back up or the number of back–ups you can make for a database.

PgSQL databases are significantly less famous in comparison to the popular MySQL databases. However, they’re a favored option for programmers who are looking for the ultimate stability for their web sites and web apps. Via the user–friendly Database Manager included in the Deshonline IT Control Panel, you can administer all your PostgreSQL databases with only a mouse click.

You will find PgSQL databases provided by default inside the advanced Linux shared hosting services packages. In case you are using a basic hosting package, you’re able to ask for PgSQL databases to be added to your website hosting account as upgrades.

The MySQL databases on our machines employ the most up–to–date build of the InnoDB storage engine. InnoDB is created to ensure the highest effectiveness for websites that work with significant volumes of data. It delivers CPU performance that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means that it is possible to update/insert/create/alter/drop a couple of times for a single "operation" of your web app. Also, it uses row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Keeping tabs on the load accumulated by the databases on your busy site will let you avoid any overload difficulties that could slow it down and ward off website visitors. For that reason, we have built in a complete Database Stats tool in the Control Panel. There you can find comprehensive information about the inbound requests to your databases for every single hour, day and month.

Using the amount of daily and hourly queries, it is possible to find out which databases are used the most and take actions to enhance their load.