Database Manager

Overseeing your databases is easier than ever, thanks to the Web Site Control Panel interface for MySQL and PgSQL administration! Assuming you do not have substantial experience of working with databases, it will be effortless to handle our Database Manager.

You could make a whole new database by just entering the username and security password or create a database backup with a simple click of the mouse. At the same time, through the Data Manager you’ll get direct access to the administrative area for each individual database, which means you can quite simply modify it.

From the Database Manager it’s easy to generate an archived backup of your database whenever you want! Thus, you’ll always have a data backup of your operating content material in the event your website gets hacked or you incorrectly eliminate a database. To make a back–up: click on the ’clock’ image on the side of any database and then wait for a few seconds for the process to be performed.

There aren’t any boundaries for the volume of databases you can back up or the amount of backups you may make for a database.

PgSQL databases are less sought after than the popular MySQL databases. Nonetheless, they represent a favorite alternative for programmers who are looking for the maximum stability for their web sites and apps. Thanks to the easy–to–use Database Manager integrated into the Echo86Host Control Panel, you can administer all your PostgreSQL databases with only a mouse click.

Yow will discover PgSQL databases provided by default inside the top web hosting service packages. If you are with a regular hosting package, it’s possible to ask for PgSQL databases to be added to your account as upgrades.

We’ve added InnoDB – the new standard MySQL database engine on our servers. InnoDB is made for significant database sites that demand high effectiveness and scalability. Experiments have demonstrated that web sites making use of InnoDB based tables achieve a 3–fold efficiency boost for large joins, compared to those making use of MyISAM tables.

InnoDB works by using row–level locking in order to be able to eliminate the overall performance difficulties noticed at the top usage times of the previous variant of the database engine – MyISAM, which employs table–level locking.

We supply you an effortless route to observe the database usage of your busy sites. From the descriptive database stats user interface, which is built into the Web Site Control Panel, it’s possible to track the load made from your busy sites in real time. The provided info will help you to evaluate the database load fluctuations by the hour, every day or monthly.

You can easily keep track of the database load for all of your web sites through the Database Stats section of the Web Site Control Panel. The table on–screen features the database queries accumulated within the present month. To review info for a previous month, click on the back arrows situated at the top.