Database Manager

The Database Manager in our Online Control Panel incorporates a powerful but uncomplicated user interface. You’re able to set up a new MySQL or PostgreSQL database simply by typing in a username and password. Furthermore, you could make a backup file or change the security password of the database with a mouse click.

Through the Database Manager you will possess immediate access to the administration area for all of your databases, meaning you can make quick modifications should you have to.

With the Database Manager you are able to produce an archived duplicate of your database whenever you desire! That way, you’ll always have a backup of your operating content if your site gets hacked or if you erroneously erase a database. To create a backup: click on the ’clock’ symbol on the side of a certain database and afterwards wait for a few seconds for the process to be finalized.

There aren’t any boundaries about the quantity of databases you can back up or the amount of back–ups you can create for a database.

You are going to find PgSQL support in all our Linux shared hosting packages offers. PgSQL databases aren’t as sought after and widely used as MySQL, however they offer the greatest level of stability for your web site content and articles. For this reason, a number of famous brands like Skype and Yahoo work with PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, because of the intuitive interface of the Database Manager.

PgSQL databases are included by default within the most innovative web hosting plans. For the regular packages, they are offered as upgrades.

The MySQL databases on TorontoHosting.com - Web Hosting in Toronto’s servers employ the most current build of the InnoDB storage engine. InnoDB has been meant to ensure the top efficiency for web sites that deal with sizeable volumes of data. It offers CPU efficiency that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, meaning that it’s possible to update/insert/create/alter/drop more than once for a single "operation" of your web application. At the same time, it uses row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Tracking the load made by the databases on your busy web site will help you avoid all overload difficulties that can slow it down and chase away site visitors. Therefore, we’ve included a comprehensive Database Stats tool into your Online Control Panel. There you can find broad information on the incoming requests to your databases for each and every hour, day and month.

Using the volume of daily and hourly queries, it is possible to find out what databases are employed the most and also consider measures to optimize their load.