Inside of the ZipWeb.ca Web Control Panel you’re going to find a fully–featured, convenient Databases Manager! Employ it to get full control of all your databases. It is easy to conveniently set up new MySQL and PgSQL databases and control them through the phpMyAdmin and phpPgAdmin software programs, respectively.
A User friendly Interface
Control your databases with only a click of the mouse
Overseeing your databases now is easier than before, thanks to the Web Control Panel user interface for MySQL and PgSQL management! Even though you may not have in depth knowledge of dealing with databases, it will be easy to deal with our Databases Manager.
You could make a completely new database by only typing the user name and security password or create a database backup with a mouse click. Likewise, with the Data Manager you have direct access to the administrative area for every single database, meaning you can quite easily manage it.
Quick and easy Database Back–up
Database backups are a mouse click away
With the Databases Manager you can generate an archived backup of your database whenever you want! Thus, you will always have a data backup of your operating information in case your site gets hacked or if you accidentally remove a database. To create a back–up: click on the ’clock’ image on the side of any database and after that wait for a few seconds for the process to be concluded.
There aren’t any limits on the number of databases you can back up or the quantity of backups you can make for a database.
Support for PgSQL
Guaranteed stability for your databases
PgSQL databases are significantly less sought after than the standard MySQL databases. Even so, they represent a preferred option for developers seeking the utmost security for their web sites and web apps. Thanks to the intuitive Databases Manager integrated into the ZipWeb.ca Control Panel, you can administer all of your PostgreSQL databases with just a click of the mouse.
You will find PgSQL databases included by default inside the top Linux shared plans packages. Provided that you are with a standard hosting package, it is easy to ask for PgSQL databases to be included in your cloud hosting account as upgrades.
The newest face of MySQL
The MySQL databases on ZipWeb.ca’s machines use the latest release of the InnoDB storage engine. InnoDB has been built to ensure the highest performance for web sites that deal with sizeable amounts of data. It supplies CPU effectiveness that can not be matched up by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and gives full transaction support, which means that you can easily update/insert/create/alter/drop several times for one "operation" of your web application. Also, it employs row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.
Detailed Database Stats
Comprehensive stats for your databases
We offer you a fairly easy option to observe the database use for your active websites. Via the detailed database statistics interface, that’s included in the Web Control Panel, it is easy to record the load produced through your busy sites in real time. The supplied data will allow you to analyze the database load fluctuations per hour, every day or per month.
It’s possible to keep track of the database load for all of your websites through the Database Stats portion of the Web Control Panel. The table onscreen shows the database lookups accumulated during the present month. To assess info for a past month, just click on the back arrows placed at the top.