Databases Manager

Taking control of your databases is less complicated than ever, on account of the Online Control Panel user interface for MySQL and PgSQL administration! Provided you do not have detailed knowledge in making use of databases, it will be an easy task to work with our Databases Manager.

You can make a completely new database just by keying in the user name and security password or create a database back–up with simply a click of the mouse. At the same time, with the Data Manager you will possess direct access to the administrator area for each database, allowing you to effectively manage it.

With the Databases Manager you are able to make an archived copy of your database whenever you would like! This way, you are going to always have a data backup of your dynamic content if your website gets hacked or if you incorrectly get rid of a database. To create a back–up: click on the ’clock’ symbol beside any database and afterwards just wait for a couple of seconds for the backup process to be concluded.

There are no limits on the amount of databases you are able to back up or the amount of backup copies you can make for any database.

PgSQL databases are much less famous compared to the widespread MySQL databases. On the other hand, they represent a favored alternative for developers who are looking for the maximum safety for their websites and apps. Due to the incredibly user–friendly Databases Manager built into the .Com Endeavors Control Panel, you can control all of your PostgreSQL databases with just a mouse click.

You can find PgSQL databases integrated by default inside of the best Linux shared website hosting packages packages. Assuming that you are using a basic hosting package, you can request PgSQL databases to be added to your website hosting account as upgrades.

With .Com Endeavors, you will inevitably discover the most current variant of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is much more secure in comparison to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, most of all – it offers complete transaction support. What’s more, it works by using row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to result in effectiveness issues at high usage occasions.

Keeping tabs on the load accumulated by the databases in your powerful website assists you to reduce any kind of overload problems that might slow it down and ward off website visitors. Therefore, we have built in a descriptive Database Stats tool in the Online Control Panel. There you can find in–depth information regarding the arriving requests to your databases for every hour, day and month.

Based on the number of daily and by the hour queries, it will be easier to find out what databases are used the most and then take steps to enhance their work.