Database Manager

The Database Manager within our Control Panel includes a refined but easy to use interface. You can set up a new MySQL or PostgreSQL database by simply entering a username and password. Moreover, you can create a back–up file or change the security password of any database with a click of the mouse.

Via the Database Manager you’ll get direct access to the administrative area for all of your databases, so you’re able to make quick corrections when you need to.

Provided you have dealt with databases, you already know that making a manual database backup just isn’t a basic job. In an effort to change this, we have created an effortless to use tool that will back up your whole database with only a single click of the mouse. The back–up file will be all set for you in less than a minute, depending on the size of the selected database.

There are no limits on the total number of back–ups you can make for any specific database.

You are going to find PgSQL support in our Linux hosting plans plans. PgSQL databases might not be as sought after and widespread as MySQL, nonetheless they provide the top level of protection for your site content. Due to this, a lot of popular businesses like Skype and Yahoo work with PgSQL databases. Managing PgSQL databases is as easy as MySQL, as a result of the easy–to–use user interface of the Database Manager.

PgSQL databases are bundled automatically inside the most sophisticated web hosting bundles. For the regular bundles, they are offered as upgrades.

The MySQL databases on our web servers make use of the most up–to–date release of the InnoDB storage engine. InnoDB was developed to ensure the maximum efficiency for web sites that work with massive volumes of data. It features CPU performance that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that you are able to update/insert/create/alter/drop many times for a single "operation" of your app. At the same time, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Club Pyme offers you a pretty simple route to keep track of the database utilization for your dynamic sites. From the thorough database stats interface, that’s included in the Control Panel, you can monitor the load accumulated by your busy sites in real time. The presented details will assist you to assess the database load fluctuations every hour, daily or monthly.

It is easy to monitor the database load for all your web sites in the Database Stats part of the Control Panel. The table onscreen reveals the database lookups generated within the present month. To inspect information for an earlier month, simply click on the back arrows situated at the top.