Database Manager

Database management may appear like a difficult job to novice cloud hosting users, however with Amprotek Hostings’s Database Manager, it’s in fact reasonably easy! To set up a completely new database, you only have to enter in the username and password. Database backups are just a mouse click away also.People who choose to look into their databases and change them can use the phpMyAdmin and phpPgAdmin tools.

We’ve evolved the manual database backup generation into a quite simple activity. To do so: inside the Database Manager, click on the ’clock’ icon next to the database that you want to back up and then wait for a couple of seconds for the backup process to take place. With regards to the size of the database, the building of the back–up file is going to take somewhere between a couple of seconds and a minute.

You may create as many back–ups per database as you desire. We have not set any restrictions on the amount of databases you can back up as well.

You’ll find PgSQL support in all of our hosting packages. PgSQL databases aren’t as popular and widely used as MySQL, but they provide you with the best level of safety for your website content. Because of this, a lot of well–known brands like Skype and Yahoo apply PgSQL databases. Taking care of PgSQL databases is as simple and easy as MySQL, because of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are provided by default inside of the most advanced web hosting packages. For the basic plans, they’re suggested as upgrades.

With Amprotek Hostings, you will consistently discover the latest variant of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is much more reliable when compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, above all – it gives total transaction support. It also employs row–level locking, as an alternative for MyISAM’s table–level locking, that previously used to result in functionality troubles at high usage periods.

Keeping tabs on the load caused by the databases in your busy site makes it possible to prevent all sorts of overload difficulties that can slow it down and chase away website visitors. For that reason, we have incorporated a complete Database Stats tool into your Hosting Control Panel. There you can get comprehensive info about the incoming requests to your databases for each hour, day and month.

Based on the number of day–to–day and by the hour queries, it will be straightforward to find out which databases are employed the most and then take steps to enhance their work.