Database Manager

Overseeing your databases is much simpler than ever before, thanks to the Control Panel interface for MySQL and PgSQL administration! Assuming you do not have extensive experience in working with databases, it will be very easy to deal with the Database Manager.

You could make a whole new database simply by entering the user name and password or generate a database back–up with just a mouse click. Moreover, from the Data Manager you’ll get direct access to the administration area for each and every database, allowing you to conveniently update it.

Via the Database Manager you’re able to produce an archived duplicate of your database anytime you would like! For this reason, you’ll always have a data backup of your active content in the event your website gets hacked or you incorrectly get rid of a database. To generate a backup: click on the ’clock’ image on the side of a particular database and afterwards simply wait for a couple of seconds for the backup process to be done.

There won’t be any boundaries about the number of databases you can back up or the amount of backups you may make for a database.

PgSQL databases are less popular as compared to the prevalent MySQL databases. Even so, they’re a favorite selection for designers seeking the ultimate safety for their web sites and web apps. Through the easy–to–use Database Manager incorporated into the Embury Road Technologies, LLC Control Panel, you can control your PostgreSQL databases with a mouse click.

You can find PgSQL databases incorporated automatically inside the best shared website hosting packages. Provided that you are with a regular hosting package, it is possible to request PgSQL databases to be included in your website hosting account as upgrades.

With Embury Road Technologies, LLC, you’ll inevitably find the most recent build of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more dependable compared to the earlier storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it gives complete transaction support. In addition, it makes use of row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to cause functionality issues at peak usage periods.

Keeping track of the load caused by the databases in your powerful website makes it possible to stop all overload problems that might slow it down and chase away website visitors. For that reason, we’ve built–in a detailed Database Stats tool directly into the Control Panel. There you can see comprehensive info about the inbound requests to your databases for each hour, day and month.

In line with the quantity of day–to–day and hourly queries, you’re going to be able to determine which databases are being used the most as well as consider procedures to enhance their load.