Database Manager

Supervising your databases is less complicated than in the past, as a result of Web Hosting Control Panel user interface for MySQL and PgSQL control! In case you do not have considerable knowledge of working with databases, it will be an easy task to deal with eshreya’s Database Manager.

You may create a new database by only keying in the username and security password or generate a database backup with just a mouse click. Likewise, from the Data Manager you will have direct access to the administrative area for every single database, so you can easily modify it.

We have developed the manual database backup creation into a quite easy task. To execute that: inside of the Database Manager, click on the ’clock’ symbol beside the database that you would like to back up and wait for a few seconds for the process to take place. Depending on the size of the database, the creation of a back–up file will require somewhere between a few seconds and a minute.

You may make as many backups per database as you desire. We have not fixed any limitations about the number of databases that you can back up as well.

PgSQL databases are much less common as compared to the widespread MySQL databases. However, they’re a favored selection for developers who seek the maximum stability for their web sites and apps. Thanks to the user–friendly Database Manager incorporated into the eshreya Control Panel, you can administer your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases provided automatically within the best Linux shared hosting packages. Provided that you are using a regular hosting package, it is easy to request PgSQL databases to be added in your hosting account as upgrades.

The MySQL databases on eshreya’s servers make use of the most current version of the InnoDB storage engine. InnoDB is developed to ensure the optimum effectiveness for websites that process significant amounts of data. It presents CPU effectiveness that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, which means you are able to update/insert/create/alter/drop many times for one "operation" of your application. At the same time, it takes advantage of row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Tracking the load made by the databases within your powerful site will help you prevent any sort of overload difficulties that could slow it down and chase away visitors. Therefore, we have included a detailed Database Stats tool straight into the Web Hosting Control Panel. There you can get broad information about the inbound requests to your databases for each and every hour, day and month.

Based on the quantity of daily and hourly queries, it’s possible to find out what databases are utilized the most and consider measures to optimize their work.