Databases Manager

The Databases Manager in our Online Control Panel features a robust nevertheless simplified interface. It is easy to set up a completely new MySQL or PostgreSQL database by just typing in a user name and security password. What’s more, you could make a back–up file or alter the security password of a database with simply a click of the mouse.

With the Databases Manager you’ll possess direct access to the administrative area for each of your databases, which means you can make uncomplicated adjustments in case you have to.

Assuming you have worked with databases, you are aware that generating a manual database backup isn’t an elementary job. In an effort to change this, we have developed a simple and easy to use tool that will back up your entire database with just one mouse click. The backup file shall be ready for you in under a minute, with regards to the size of the chosen database.

There won’t be any confines on just how many back–ups you could make for any chosen database.

You will find PgSQL support in every one of our Linux shared hosting packages offers. PgSQL databases are not as sought after and frequently used as MySQL, nonetheless they provide the highest possible level of stability for your web site content and articles. Therefore, many well–known companies such as Skype and Yahoo use PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, as a result of the incredibly user–friendly user interface of the Databases Manager.

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

With GlobalVisions.ca, you shall consistently find the most recent version of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is more reliable as compared to the former storage engine’s edition – MyISAM. It’s ACID–compliant and, even more importantly – it gives 100% transaction support. Furthermore, it utilizes row–level locking, as an alternative for MyISAM’s table–level locking, that seemed to trigger functionality issues at high usage occasions.

With the thorough database statistics tool included in the Online Control Panel, you are able to keep a record of the load produced by your busy web sites round the clock. Every single overload problem with your web sites could lower the loading speeds and have a damaging impact on the overall experience of your respective visitors. Therefore, by having data for the database load in real time, you are able to eliminate overload troubles in a timely manner.

The database statistics user interface shows information of the quantity of daily, hourly and monthly queries, in order to evaluate the way the load is spread over several time periods.