Databases Manager

The Databases Manager inside the Web Hosting Control Panel comes with a refined but user friendly interface. You’ll be able to configure a brand new MySQL or PostgreSQL database by just specifying a user name and password. Moreover, you can make a backup file or change the security password of any database with just a click of the mouse.

Via the Databases Manager you’ll possess direct access to the administration area for all of your databases, which enables you to make convenient adjustments in case you need to.

In case you have dealt with databases, you are aware that creating a manual database back–up is just not a simple task. In order to change this, we’ve developed a simple tool that can back up the entire database with just one mouse click. The back–up file will be set for you in under a minute, with respect to the size of the selected database.

There are no limitations on how many back–ups you may make for any particular database.

PgSQL databases are significantly less popular as opposed to the popular MySQL databases. On the other hand, they’re a favored option for web developers who are looking for the best safety for their websites and apps. Via the user–friendly Databases Manager built–into the JMR Web LLC Control Panel, you can manage your PostgreSQL databases with merely a mouse click.

You’re going to find PgSQL databases included automatically inside of the best Linux cloud website hosting packages packages. Provided that you are with a standard hosting package, you can request PgSQL databases to be added to your website hosting account as upgrades.

The MySQL databases on our web servers work with the latest version of the InnoDB storage engine. InnoDB is developed to guarantee the maximum effectiveness for sites that operate with significant amounts of data. It presents CPU efficiency that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, so that it’s possible to update/insert/create/alter/drop a couple of times for one "operation" of your web app. Additionally, it uses row–level locking and not MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping track of the load caused by the databases within your powerful web site will let you reduce any overload issues that can slow it down and ward off visitors. As a result, we’ve incorporated a complete Database Stats tool into the Web Hosting Control Panel. There you will find extensive info on the inbound requests to your databases for every single hour, day and month.

Using the amount of daily and per hour queries, you’ll be able to find out which databases are utilized the most and consider steps to enhance their work.