Databases Manager

Overseeing your databases is much easier than ever before, thanks to the Web Control Panel user interface for MySQL and PgSQL control! Even though you may not have extensive knowledge of making use of databases, it will be an easy task to handle EnCenterWEB’s Databases Manager.

You could make a new database just by specifying the username and password or generate a database backup with only a mouse click. Also, via the Data Manager you will possess direct access to the admin area for every single database, meaning you can easily alter it.

We’ve developed the manual database back–up generation into a quite simple activity. To execute that: inside of the Databases Manager, click the ’clock’ image near the database that you intend to back up and afterwards wait for a few seconds for the backup process to take place. With respect to the size of the database, the creation of the back–up file will need between a couple of seconds and a minute.

You can create as many copies of a database as you desire. We’ve not set any confines about the volume of databases you can back up as well.

You’ll find PgSQL support in all of our web hosting offers. PgSQL databases may not be as famous and widespread as MySQL, nevertheless they deliver the highest possible level of stability for your web site content and articles. Therefore, a lot of well–known brands like Skype and Yahoo implement PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, on account of the user–friendly interface of the Databases Manager.

PgSQL databases are integrated by default within the most sophisticated web hosting packages. For the normal bundles, they’re included as upgrades.

We’ve integrated InnoDB – the new standard MySQL database engine on all our web servers. InnoDB is good for large database sites that need high levels of overall performance and scalability. Experiments have shown that web sites employing InnoDB based tables achieve a 3–fold general performance boost for very big joins, in contrast to those working with MyISAM tables.

InnoDB takes advantage of row–level locking so as to remove the effectiveness difficulties seen at the maximum consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

EnCenterWEB offers you a surprisingly simple method to keep an eye on the database utilization on your dynamic sites. From your descriptive database stats interface, that’s integrated into the Web Control Panel, it is possible to track the load produced by your dynamic websites in real time. The provided details will assist you to assess the database load fluctuations on an hourly basis, daily or per month.

You are able to keep an eye on the database load for all of your websites through the Database Stats part of the Web Control Panel. The table on–screen features the database queries made within the present month. To check info for a previous month, all you have to do is click on the back arrows placed at the top.