From within the Databases Manager built–into the Control Panel, it will be easier to create new MySQL and PgSQL databases straight away! Moreover, you will have direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), in order for you to be able to conveniently manage the database you want.
An Easy to use Interface
Take care of your databases with just a click
Supervising your databases is less complicated than before, due to the Control Panel user interface for MySQL and PgSQL control! In case you do not have thorough expertise in managing databases, it will be simple to manage our Databases Manager.
You could make a new database by just keying in the user name and password or create a database back–up with merely a mouse click. In addition, through the Data Manager you will get direct access to the administrative area for every database, so its possible to quickly update it.
Quick and Simple Database Back–up
Database backup copies are a mouse click away
From the Databases Manager you’ll be able to create an archived backup of your database when you want! For this reason, you are going to always have a backup of your active information in case your site gets hacked or you erroneously delete a database. To create a backup: click on the ’clock’ symbol beside any database and then wait for a few seconds for the backup process to be concluded.
There aren’t any boundaries on the quantity of databases you would be able to back up or the number of backup copies you can create for a database.
The most secure open source databases
A lot of our shared web hosting bundles present PgSQL support. Whilst dropping behind MySQL with respect to acceptance and usage, PgSQL databases are famous for delivering the maximum level of safety for your website content. That is the reason why businesses like Skype and Yahoo go with PgSQL databases as opposed to MySQL.
When it comes to database administration, PgSQL is just as straightforward as MySQL.
The new face of MySQL
The MySQL databases on alvahosting’s machines utilize the most current release of the InnoDB storage engine. InnoDB has been intended to ensure the top performance for web sites that process large volumes of data. It features CPU efficiency that can not be equalled by any other disk–based relational database engines.
InnoDB is ACID–compliant and supplies complete transaction support, meaning that it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your app. Also, it employs row–level locking in place of MyISAM’s table–level locking, that raises multi–user concurrency and performance.
Detailed Database Stats
In depth stats for your databases
Keeping track of the load produced by the databases on your dynamic site will help you stop virtually any overload problems that could slow it down and ward off website visitors. For this specific purpose, we have provided a in–depth Database Stats tool straight into the Control Panel. There you can see thorough information regarding the arriving requests to your databases for every hour, day and month.
Depending on the volume of day–to–day and per hour queries, it will be easy to determine which databases are utilized the most and also consider measures to optimize their work.