We give you a simple to use Databases Manager, incorporated inside our Website Control Panel, from where you could set up completely new MySQL and PgSQL databases immediately. Also, you are able to administer all of their settings via the convenient access presented to the phpMyAdmin and phpPgAdmin software tools.
Tidy and Very easy User interface
Be in charge of all your databases from within one location
The Databases Manager inside the Website Control Panel provides a robust nevertheless user friendly interface. You are able to set up a whole new MySQL or PostgreSQL database by just typing a user name and password. Also, you can make a backup file or alter the password of your database with merely a click of the mouse.
With the Databases Manager you’ll possess direct access to the administrator area for all of your databases, allowing you to make simple and easy corrections should you have to.
Quick Database Backup
Take care of your database information with just a click of the mouse
In case you have worked with databases, you know that generating a manual database backup just isn’t an elementary job. In order to change this, we have developed a simple tool that can back up your entire database with only one mouse click. The back–up file will be prepared for you in less than a minute, with regards to the size of the selected database.
There aren’t any limitations on the actual number of backups you can make for a particular database.
Support for PgSQL
Assured stability for your personal databases
PgSQL databases are significantly less famous when compared to the standard MySQL databases. Then again, they represent a preferred alternative for developers who seek the best security for their web sites and apps. Via the user–friendly Databases Manager built into the Ayasoftware.ca Control Panel, you can control all your PostgreSQL databases with only a mouse click.
You can find PgSQL databases included by default in the best Linux shared hosting packages packages. Provided that you are using a regular hosting package, it is easy to request PgSQL databases to be included in your account as upgrades.
The new face of MySQL
The MySQL databases on our web servers utilize the most up–to–date build of the InnoDB storage engine. InnoDB has been intended to guarantee the optimum performance for web sites that operate with significant volumes of data. It offers CPU efficiency that could not be matched by other different disk–based relational database engines.
InnoDB is ACID–compliant and gives complete transaction support, which means you are able to update/insert/create/alter/drop many times for one "operation" of your web application. In addition, it takes advantage of row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.
Detailed Database Stats
Comprehensive stats for all your databases
Keeping track of the load caused by the databases within your dynamic website makes it possible to avoid any kind of overload issues that could slow it down and ward off site visitors. For this specific purpose, we’ve built–in a in–depth Database Stats tool inside the Website Control Panel. There you shall find complete info about the inbound requests to your databases for every hour, day and month.
In line with the amount of day–to–day and by the hour queries, you will be able to find out which databases are used the most as well as consider procedures to enhance their load.