While in the TorontoHosting.com - Web Hosting in Toronto Online Control Panel you will find a feature–rich, well designed Database Manager! Employ it in order to enjoy complete control over your databases. You are able to efficiently configure new MySQL and PgSQL databases and administer them with the phpMyAdmin and phpPgAdmin software tools, respectively.
Tidy and Straightforward User interface
Maintain all of your databases from a single location
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.
Simple and quick Database Backup
Database backup copies are just a mouse click away
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.
PgSQL Databases Support
The most risk–free open source databases
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 newest face of MySQL
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.
Detailed Database Stats
Comprehensive statistics for all of your databases
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.