Databases Manager

The Databases Manager within our Online Control Panel comes with an effective but still convenient to use interface. You are able to set up a whole new MySQL or PostgreSQL database simply by typing in a user name and security password. Additionally, you can create a back–up file or alter the security password of an database with merely a mouse click.

With the Databases Manager you will have direct access to the management area for every one of your databases, so you’re able to make convenient adjustments should you have to.

We’ve designed the manual database back–up generation into a quite easy task. To execute this: in the Databases Manager, click the ’clock’ icon next to the database that you plan to back up and after that wait around for a couple of seconds for the process to take place. Depending on the size of your database, the building of the backup file will take between a few seconds and a minute.

You can make as many copies of a database as you desire. We’ve not fixed any limitations about the number of databases that you can back up too.

You’ll find PgSQL support in every one of our Linux cloud packages packages. PgSQL databases aren’t as popular and widely used as MySQL, but they provide you with the top level of safety for your website content and articles. For this reason, several famous businesses like Skype and Yahoo apply PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, due to the incredibly user–friendly interface of the Databases Manager.

PgSQL databases are included by default in the most sophisticated web hosting bundles. For the basic bundles, they are presented as upgrades.

We’ve integrated InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is made for large database websites which require high levels of efficiency and scalability. Tests indicate that websites making use of InnoDB based tables reach a 3–fold operation boost for very large joins, in comparison to those applying MyISAM tables.

InnoDB uses row–level locking in an effort to eliminate the efficiency problems witnessed at the maximum consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

Val-Expert Ltd. offers you a pretty simple route to keep an eye on the database use for your dynamic web sites. From the in–depth database statistics user interface, which is included in the Online Control Panel, you are able to monitor the load accumulated through your busy web sites in real time. The provided information will allow you to evaluate the database load changes each hour, daily or on a monthly basis.

You can easily record the database load for all your sites in the Database Stats portion of the Online Control Panel. The table on–screen presents the database lookups generated in the present month. To inspect information for an earlier month, just click on the back arrows located at the top.